Automated email from excel / outlook

 

I have a spreadsheet, which we maintain for work allocation for our team, we have a 24 hours Turn around Time (TAT) for the work to processed. I want an automated email to be sent through excel once a particular work has exceeded the 24 hours TAT.

 

This spreadsheet is a shared file, as we all need to update it.

 

Please advice.

AttachmentSize
Email & Call helpdesk claims_tracker.xls119.5 KB
Nick's picture

conditional formatting

hi

a full solution to this is a bit involved.. not sure anyone will volunteer that time.

How about using conditional formatting to highlight the ones that are > 24 hours

- if you have the "time added", create another column called Age.

- the formula for Age would be something like =now()-A1  (where A1 is the time added cell)

 

25. Excel Tips - Conditional formatting

 

Related to your query, here's a tip on how to email a workbook using VBA:

25. VBA Tips - Email Workbook