Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003

20 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • EasyTech
    ...or use a 3rd party app like wincalendar to facilitate see
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following