Tech Support Guy banner
Status
Not open for further replies.

Automatic Outlook mail reminder based on Excel file

2K views 2 replies 2 participants last post by  draceplace 
#1 · (Edited)
Hi,

i have used the following to get automatic alerts setup when a due date is near:
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

but instead of this looking at the due date column, i would like it to look at a conditonal formatted column, which shows status as either "due" and "expired" depending on due date. i would like it send out to all those with "due tag and not "expired"

I have name in column A, details in column B, emails address in column C, status in column i, and reminder in column k

Somethng else i would like to do later on, if at all possible,is to get a particluar email from outlook be transfered to excel and and then emailed to specific people based on a status column. So if an email is recieved to say a project is extended or cancelled,, it contents is copied to excel and emailed back out to certain people.

Thank you for your support.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top