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.
| Attachment | Size |
|---|---|
| Email & Call helpdesk claims_tracker.xls | 119.5 KB |
»
- jawed_h777's blog
- Login or register to post comments
- 8177 reads
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