software

Hi Guys

I found the below code within this forum to insert appointments into
your Outlook Calendar, the .RequiredAttendees is the section that I am
stuck on, I want it to send appointments to people I state in Cell E1.

These people are listed in our active directory as surname, firstname I
have tried this format in the cell E1 and also their full e-mail
address but no appointment is sent.

I want to send the appointment to , internally
it will be Bloggs, Joe.

Can anyone point out where I am going wrong?

Many Thanks

Mark

Sub CreateOutlookAppointment()
Dim ol As Object
Dim objItem As AppointmentItem

Set ol = CreateObject(quot;outlook.applicationquot;)

Set objItem = ol.CreateItem(olAppointmentItem)
With objItem
.Subject = Range(quot;A1quot;).Value
.Location = Range(quot;B1quot;).Value
.Start = Range(quot;C1quot;).Value
.Duration = Range(quot;D1quot;).Value
.RequiredAttendees = Range(quot;E1quot;).Value
.ReminderSet = True
.ReminderMinutesBeforeStart = 20
.Save
End With

Set objItem = Nothing
Set ol = Nothing
End Sub