Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003
20 pts.
0
Q:
Automated export/import between Microsoft Outlook 2003 and Microsoft Excel 2003
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.
ASKED: Mar 3 2009  9:18 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
20 pts.
0
A:
 RATE THIS ANSWER
-1
Click to Vote:
  •   0
  •  -1
  • AddThis Social Bookmark Button
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.
Last Answered: Mar 3 2009  7:14 PM GMT by Nizw1   20 pts.
Latest Contributors: Mshen   23535 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0