Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.outlook.vba,microsoft.public.outlook.proram_vba
|
|||
|
|||
Sending Appointments via Outlook
Can anyone offer some help here? My code generates the proper
appointment entry in Outlook (from Excel) but will not send it out to the recipient. I've included the problem code snippet below. Really appreciate any help! Thanks! [snippet] For n = 1 To ACChangeCount With OutlookApp.CreateItem(olAppointmentItem) .Subject = "`AC Change Multiple"" .Start = ACScheduledStart(n) .End = ACScheduledEnd(n) .ReminderMinutesBeforeStart = 15 .ReminderSet = True If ACFYI(n) = True Then .Location = "FYI ONLY" Else .Location = "Operations Performs Change" End If .Recipients.Add ") .Recipients.ResolveAll .Send End With Next n Set OutlookApp = Nothing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending Excel through Outlook | Excel Discussion (Misc queries) | |||
Appointments from Excel into Outlook Calendar | Excel Worksheet Functions | |||
Export simple appointments from Excel to Outlook | Excel Worksheet Functions | |||
linking Outlook appointments and contacts from Excel | Excel Programming | |||
sending outlook mail | Excel Programming |