Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003
Excel import/export, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2003 import/export, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2003 import/export, Outlook, Outlook Import/Export
I need to keep track of my activities in a excelfile and am looking for a way in wich my appointments (in my Microsoft Outlook 2003 calendar) automaticly get imported in specifed fields of the 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 automaticly update the fields in a Microsoft excelsheet with the fields from a Microsoft Outlook calendar?
thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 3, 2009 9:18 AM
UPDATED:
September 1, 2010 3:45 PM
Answer Wiki:
1. Go to File -> Import and Export
2. Select Export to a file
3. Select Microsoft Excel
4. Select your calendar
5. Set the file name
6. Set the dates you want to export
Copy the fields you need to your excel spreadsheet.
I'm sorry, but this is still a very manual exercise. What i want is to open my excelsheet which starts with an automated input from outlook. Maybe with Macro's?
Can you help me with that?
thanks.
To see all answers submitted to the Answer Wiki: View Answer History.
…or use a 3rd party app like wincalendar to facilitate see