[calvert27]

I am creating a spreadsheet of activities that need to be completed on certain dates. What my boss wants is for those dates in Excel to pop up on the Outlook calendar when Outlook is opened.

Obviously I know how to put dates into Outlook, but I'm not sure how to link Excel and Outlook without exporting data all the time.

The spreadsheet layout is as such:
Column A: Activity
Column B: Commencement Date
Column C: Days to Complete
Column D: End Date
Column E: Assigned To

D is the key/schedule date here... I also want A and E to be displayed...

I've seen a few VBA codes but being rather inexperienced in this area I seem to be missing the first few steps... If anyone can help, please do! But please keep it nice and simple and start from scratch

Thanks!

[Advertisements]

I've no experience of this myself but maybe this will help?

http://forums.techgu...to-outlook.html

[Vino Rosso]

I've no experience of this myself but maybe this will help?

http://forums.techgu...to-outlook.html