Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Outlook appointment info and export into an Excel spreadsheet
I need to access the information in the "Call Information" of the
appointments of a specific calendar in Outlook. The calendar is saved in a public folder, and if you open any of the appointments and select "Call Information" in the "Show" box a form pops up and displays info that was saved there for that meeting. I need access to that information for all the appointments in this calendar, and need to export them into an Excel Spreadsheet. I'm thinking that I need to know where this data is saved? How can I access it? Or how do I find out where it is? Very broad, I know, but any help would be greatly appreciated! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200902/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Outlook appointment info and export into an Excel spreadsheet
So far I have recieved this code (mixed/pseudo), but I need to know how to
reference the proper library??? If you can help at all, please do! Dim OLApp As Outlook.Application Dim OLNameSpace As Outlook.NameSpace Dim OLCalendar As Outlook.MAPIFolder Dim MyAppointmentItem As Outlook.AppointmentItem Private Sub Command1_Click() Set OLApp = New Outlook.Application Set OLNameSpace = OLApp.GetNamespace("MAPI") Set OLCalendar = OLNameSpace.GetDefaultFolder(olFolderCalendar) Set MyAppointmentItem = OLCalendar.Items.GetFirst Do Until MyAppointmentItem Is Nothing With MyAppointmentItem ' Do whatever End With Set MyAppointmentItem = OLCalendar.Items.GetNext Loop Set OLCalendar = Nothing Set OLNameSpace = Nothing Set OLApp = Nothing End Sub cmonroe21 wrote: I need to access the information in the "Call Information" of the appointments of a specific calendar in Outlook. The calendar is saved in a public folder, and if you open any of the appointments and select "Call Information" in the "Show" box a form pops up and displays info that was saved there for that meeting. I need access to that information for all the appointments in this calendar, and need to export them into an Excel Spreadsheet. I'm thinking that I need to know where this data is saved? How can I access it? Or how do I find out where it is? Very broad, I know, but any help would be greatly appreciated! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200902/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to export data from excel spreadsheet to outlook distribution | Excel Discussion (Misc queries) | |||
outlook appointment labels colour from excel | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
Pass a time value from Excel to Outlook appointment | Excel Discussion (Misc queries) | |||
export spreadsheet from excel to access table | Excel Programming |