1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Automatic Outlook mail reminder based on Excel file

Discussion in 'Business Applications' started by ahsa, Apr 9, 2017.

Thread Status:
Not open for further replies.
Advertisement
  1. ahsa

    ahsa Thread Starter

    Joined:
    Apr 9, 2017
    Messages:
    2
    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.
     
    Last edited: Apr 9, 2017
  2. ahsa

    ahsa Thread Starter

    Joined:
    Apr 9, 2017
    Messages:
    2
    Managed to get my main query soughted using: If Cells(i, 9).Value = "Due" Then

    What if i want to email again on the day of the expiry date, how would i go about doing that?
     
    Last edited: Apr 9, 2017
  3. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,550
    Something like If Today() = Expirey Date then
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1188175