Link to home
Start Free TrialLog in
Avatar of crestsolutions
crestsolutions

asked on

Looking for a clever way of adding appointments to another user's Outlook calendar

I need to add a recurring appointment to another user's calendar in VB6. Currently I use the following code to send a meeting request for each instance of the recurring appointment. The code works OK but becuase I am using Outlook 2003 it pops up a number of warning messages about an application trying to send an email on your behalf. Theses warning messages pop up for each instance of the recurring appointment.

    Set objOutlook = New Outlook.Application
   
    Set appItem = objOutlook.CreateItem(olAppointmentItem)
    appItem.MeetingStatus = olMeeting
   
    appItem.Start = dtDueDate
    appItem.Duration = 60
    appItem.Subject = "Subject"
    appItem.Body = "Body"
   
    appItem.ReminderMinutesBeforeStart = 15

    Set myRecipient = appItem.Recipients.Add(strEmail)

    appItem.Send

Say for example I want to schedule something to happen each week for a year, I will get about 1000 warning messages from outlook and as well as that,  the recipient of the recurring appointment will get an email for each instance of the recurring appointment ( in this case 52 emails )

Ideally I would like to add a recurring appointment without the recipient receiving any emails and the sender receiving any warnings. If there is a way I could perform this operation by going directly to the mail server that would be ideal as then I would not be relying on Outlook being installed on the host workstation

Thanks

Michael

ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of crestsolutions
crestsolutions

ASKER

Thanks for that. That works very well to eliminate the warnings. If you don't mind I will just wait to see is there any solution out there for the emails appearing in the recipients inbox before I award the points. Even if there is I will award you some of the points.
Hi crestsolutions,

You should be able to add an appointment directly to another user's calendar, no messages involved, if the other user grants you access to their calendar and if you then add that user's calendar to your profile.  The other user will have to give you authoring permission to their calendar.  

Cheers!
Thanks for the comment BlueDevilFan but I cannot ensure that the Calendar will be shared. I'm sorry but I will be awarding the points to Dhaest as his solution solved most of the problems I was encountering
No problem.