I need to manually copy the start and stop times of my monthly appointments (in my Microsoft Outlook 2003 calendar running on Exchange Server 2003) to a Microsoft Excel file. This is part of a monthly report to account for my time, and how much time I spent on an appointment. Is there a way to export the fields from a Microsoft Outlook/Exchange Server calendar to specified fields in Microsoft Excel or Microsoft Access?
Requires Free Membership to View
VIEW MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A.
MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A:
Do you have comments on this Ask the Expert Q&A? Let us know.Expert Advice: Exporting Exchange public folder contacts to Microsoft Excel
Tip: How to export data from a Microsoft Outlook .PST file to a .CSV file
Tip: Fix mangled directory imports
Reference Center: Exchange Server contacts and calendars resources
Reference Center: Microsoft Outlook tips and resources
Follow these steps to export your calendar to a Microsoft Excel file:
- Select the Microsoft Outlook calendar.
- Go to File -> Import and Export.
- Click Export to a file.
- Choose Comma Separated Values (DOS) for Microsoft Excel or Microsoft Access.
- Select the Microsoft Outlook calendar.
- Type a name for the new file.
- Set a date range to narrow your data.
- Open the file using Microsoft Excel.
MEMBER FEEDBACK TO THIS ASK THE EXPERT Q&A:
Yes, it works, but it didn't export the attendees list.
—Dayalan P.
**************************************************
I have exported my Microsoft Outlook 2003 calendar to Microsoft Excel, but not all of the items showed up. I have some recurring items that show, and some that do not. How can I fix this so I can see everything?
—Eric G.
Do you have comments on this Ask the Expert Q&A? Let us know.
Related information from SearchExchange.com:
This was first published in October 2006
Join the conversationComment
Share
Comments
Results
Contribute to the conversation