W
Webmaster
When I export my Calendar's data to Access or Excel, the data is missing a
significant number of records. I need to explain this way:
1. I set up some recurring events many months ago. Like, "Gone for Lunch"
at 12:00 PM until 1:00 PM every weekday with no end date.
2. Then, from time to time, I miss lunch or don't take a full hour...so I
simply adjust it in my calendar. (i.e. I modify a single instance of the
recurring event to indicate the 'actual' time that I was gone for lunch.
3. I do the same to indicate when I arrive at work and when I leave work.
(And if I stay late, I simply adjust that particular instance of the
recurring event.)
3. I want to export the data to Access or Excel so I can produce a line
graph of my 'actual work hours' to show the boss how much overtime I'm not
being paid for.
4. But the data that is exported from Outlook does NOT include those
'modified' recurring appointments. What I mean is, the exported data has a
"Gone for lunch" appointment on all weekdays EXCEPT FOR those days that were
adjusted.
Try it....like:
- make a recurring appoinment in your calendar.
- change the time or duration of a SINGLE instance of that appointment in
your calendar.
- then export the calendar to Excel
- are you missing that one instance?!
Have I done something wrong? Or has Microsoft?
Many thanks for any and all replies.
significant number of records. I need to explain this way:
1. I set up some recurring events many months ago. Like, "Gone for Lunch"
at 12:00 PM until 1:00 PM every weekday with no end date.
2. Then, from time to time, I miss lunch or don't take a full hour...so I
simply adjust it in my calendar. (i.e. I modify a single instance of the
recurring event to indicate the 'actual' time that I was gone for lunch.
3. I do the same to indicate when I arrive at work and when I leave work.
(And if I stay late, I simply adjust that particular instance of the
recurring event.)
3. I want to export the data to Access or Excel so I can produce a line
graph of my 'actual work hours' to show the boss how much overtime I'm not
being paid for.
4. But the data that is exported from Outlook does NOT include those
'modified' recurring appointments. What I mean is, the exported data has a
"Gone for lunch" appointment on all weekdays EXCEPT FOR those days that were
adjusted.
Try it....like:
- make a recurring appoinment in your calendar.
- change the time or duration of a SINGLE instance of that appointment in
your calendar.
- then export the calendar to Excel
- are you missing that one instance?!
Have I done something wrong? Or has Microsoft?
Many thanks for any and all replies.