Yet another Excel question

[DrPhil]

Is it possible to set up Excel to send an email reminder or outlook calendar reminder on set dates?

I'm working out a more efficient way to manage invoice requests so rather than having to manually go and check the spreadsheet I want Excel to tell me when one is due.

There are 40+ projects all with different payment schedules etc.

 

[hippy240980]

This any use to you?

Create Excel Alerts, then write a macro to email them

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

www.pcworld.com

 

[DrPhil]

This any use to you?

Create Excel Alerts, then write a macro to email them

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

www.pcworld.com

Just going through that at the minute.

Hopefully idiot proof...