Help passing information from Outlook to Excel

[Guest]

Hi, can anyone help?
I've created a leave spreadsheet that creates a calendar appointment in
Outlook and sends it to the authorising officer. What I'd like to do next is
to be able to update a timesheet workbook when the authorising officer agrees
to the time off. The leave sheet and timesheet are both part of the same
excel document
This is how I'd envisage it working:
I request 2 days leave, 15 and 16 November, in my spredsheet. Outlook
emails my authorising officer for approval. When the authorising officer
clicks on accept and the information comes back to me I'd like Outlook to
search for 15 & 16 November in my timesheet and update it with information
from the acceptance notification.

If this is not possible, that the alternative would be to pass the
information from the leave worksheet to the timsheet workbook at the time of
request.

Any ideas?

 

[Ken Slovak - [MVP - Outlook]]

You certainly can write code to access the timesheet workbook when a parsed
email message comes in that has the scheduling information. You have to
figure out how to distinguish between those emails and the others you get
and how to parse out the scheduling information. Beyond that it's all Excel
automation code.