Can Excel issue reminders via email ?

[jonsi]

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

 

[mintjulep]

Yes, it could.

But why?

Create an Outlook task for each task.
Set due date and reminder date.
Assign.

 

[Andrzejek]

If this is your data:

[pre]
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
[/pre]

And the DATA column is a Date (not just text), and you don't mind to do a little VBA, that could be simple.

VBA questions - ask here: forum707

In my opinion, you need to establish some rules for e-mails, ie:
From: ???
To: ???
CC: ??? (if any)
Subject: ???
Body: ???

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[jonsi]

Mintjulep wrote:
Create an Outlook task for each task.
Set due date and reminder date.
Assign.

Thanks for your reply.

The Excel worksheet is likely to be populated/updated by others (it lives on a shared resource) so while I could manage it from my Outlook account others couldn't access it (...and I don't want the responsibility).

Andrzejek
Thanks for your reply.

I thought the answer would be VBA ...I'll ask the question on the forum you suggest.

cheers
Jonsi

 

[SkipVought]

so you don't have Exchange where there are shared calendars and common areas?

 

[jonsi]

Hi Skip

Shared Calendars aren't in use ...I shall investigate

thanks
Jonsi