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.

Auto send an email based on date in Excel

Discussion in 'Business Applications' started by agodfrey07, Sep 13, 2010.

Thread Status:
Not open for further replies.
  1. agodfrey07

    agodfrey07 Thread Starter

    Joined:
    Sep 12, 2010
    Messages:
    2
    I've read the previous post with the same issue, but I'm unable to understand how to use the other codes posted within my product. I would like to send an email based on a date. I will attach my document so it is easier for me to explain the requirement. Columns L37-L45 have due dates - I would like the email to be sent 60 days prior. I have posted some mock emails in R37-R45 and the email message in the EMAIL workbook tab. Any assistance would be greatly appreciated.

    Thank you so much!
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Welcome to the board.
    I've had to save it as 2003 version but the code works under 2007

    See attached my copy of your sheet with the code in ThisWorksheet module.

    This just a simple way of doing it and you will have to edit it for your needs but maybe it can put you on the right track.
     

    Attached Files:

  3. agodfrey07

    agodfrey07 Thread Starter

    Joined:
    Sep 12, 2010
    Messages:
    2
    Thank you so much. I appreciate your time. I will make the changes and put it to the test. :)
     
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/949639

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice