Excel transfer date to Outlook automatically

[jonsi]

This question was posted on the MS Office forum but it was suggested that my answer lies in VBA

I have a list of tasks on a simple worksheet that I'd like to use to generate an automatic email to various recipients as a reminder on a specified date.

I know that I can import from Excel into an Outlook Calendar which would be OK were it just me needing the reminder, but the reminders are for many other people.

The list gets updated/amended at frequent intervals too so importing all the time or trying to get others to import into Outlook would be impractical. I don't want to miss anything so couldn't rely on me being the diary for so many people although I need to know whether these tasks have been done.

example:
DATE DEPT TASK INVOLVES
Mon 1st June 2015 Engineering Drain survey engineer@company.com
Mon 1st June 2015 HR Training Records for Audit hr@company.com
Tue 2nd June 2015 Safety Fire Training Safety@company.com; HR@company.com
Wed 3rd June 2015 ALL ISO14001 Audit meeting SiteUsers@company.com
Wed 3rd June 2015 Safety Check Fire Doors safety@company.com; engineer@company.com
Wed 3rd June 2015 Safety Check Fire Extinguihsers safety@company.com
Wed 3rd June 2015 Safety Check Fire Alarms safety@company.com

Would I be asking too much from Excel to accomplish this or am I better off just managing an Outlook diary?

Jonsi

 

[SkipVought]

Hi,

Are these one time events or recurring?

 

[jonsi]

both.

Some may be recurring on a weekly / Monthly basis but other would be single events.

I am investigating using Exchange and Tasks with a shared calendar

thanks
Jonsi