Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.outlook.vba,microsoft.public.outlook.program_vba
|
|||
|
|||
![]()
Does it help if you set .MeetingStatus = olMeeting?
-- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "Paul Thompson" wrote in message ... 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 | |
|
|
![]() |
||||
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 |