Email Based On Condition Of Cell Value

  • This is a modification of Ron DeBruin's program, which will satisfy many email needs.


    A1. First Name
    B1. Last Name
    C1. To: Email Address
    D1. Begin Date
    E1. Present Date
    F1. Formula for Yes to send. Must copy down
    G.1 Sent is inserted if email was sent.
    H1. Date and time sent
    I1. CC Email Address
    J1. Subject line. "Annual Physical"
    J2. First part of Body. "Hi"
    J3. Body:
    J4. Date 31 days from present date.
    J6. Thanks
    J7. From: Name
    To run it must have a "yes"in column "F" and no "Sent" in Column "G"
    Remove the "sent" to run again to test.

  • Re: Email Based On Condition Of Cell Value


    I tried it, it didn't work for me. The only thing it had was the Show it calendar and the codes for that.


    Will check back on this thread if there was something I missed.


    Thanks,
    David

    Thanks,
    David
    [size=-2]Bad news. These are the good old days.[/size]

  • Re: Email Based On Condition Of Cell Value


    Try this


  • Re: Email Based On Condition Of Cell Value


    Good submission. It can do the trick with the code submitted.

    Thanks,
    David
    [size=-2]Bad news. These are the good old days.[/size]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!