How to include mulitple meeting attendee via VBA?

A

AirDuster101

Hi,

I am using ACCESS 2002 and Outlook 2000. I need to setup a meeting
appointment with mulitple attendees. Such as strRecipients = "Joe Lee; Adam
West; Jane White". But, I can't get the name separator to work correctly.
I've tried comma but, all still just show as one attendee. Please help!


'ADD ATTENDEE
Dim oRecipt As Outlook.Recipient
Dim strRecipients As String

strRecipients = "Joe Lee; Adam West; Jane White"

With objAppt
'Add the recipient to the Meeting Request
Set oRecipt = .Recipients.Add(strRecipients)
.Start = Me!ApptDate & " " & Me!ApptTime
.Duration = Me!ApptLength
.Subject = Me!Appt

If Not IsNull(Me!ApptNotes) Then .Body = Me!ApptNotes
If Not IsNull(Me!ApptLocation) Then .Location = Me!ApptLocation
If Me!ApptReminder Then
.ReminderMinutesBeforeStart = Me!ReminderMinutes
.ReminderSet = True
End If


.Save
'.Close

End With



Thanks,
AD
 
K

Ken Slovak - [MVP - Outlook]

Parse them out yourself and call Recipients.Add once for each one.

To recipients are required, Cc recipients are optional and Bcc recipients
are resources.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top