Outlook Appointment export to CSV/Excel, including appointment item body text
Posted on 2011-10-23
Outlook 2010's export to file wizard (File|Options|Advanced|Export...) doesn't refernce appointment item body, would anyone have a VBA solution to export Outlook apppointment items from a shared calendar to CSV or Excel file, including appointment item body as string?
To limit file size, only appointments who'se body text contains the string: "Catering: " need to be exported. The shared Calendar is named "C3 Conference Center Calendar” in folder view. To be useful, the CSV file would include key fields from the appoitnment item, for example: StartDate&Time (AppointmentItem.Start), EndDate&Time (AppointmentItem.End), Alldayevent (AppointmentItem.AllDayEvent), BillingInformation (AppointmentItem.BillingInformation), Categories (AppointmentItem.Categories), Description/Subject (AppointmentItem.Subject), Location(AppointmentItem.Location) + body as string.
We tried outlook's export wizard, File | Options | Advanced | Export... but that does not reference the appointment item body. Appreciate any help. Thanks!