+ Reply to Thread
Results 1 to 4 of 4

Need VBA script for sending automatic emails when excel cell date equals current date

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    Lubbock, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need VBA script for sending automatic emails when excel cell date equals current date

    I am trying to set up a macro that will automatically email the names checkmarked in the excel file three days before the due date listed. I've tried to attach a template, but it is not allowing me to add attachments. Instead I will be linking it from my Dropbox. Can anyone help? I am brand new to macros, never touched them before, so I need as much help as I can get. Thanks!

    https://www.dropbox.com/s/g3cxd57m0s...lank.xlsx?dl=0

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Need VBA script for sending automatic emails when excel cell date equals current date

    Try this:

    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Registered User
    Join Date
    02-12-2013
    Location
    Lubbock, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need VBA script for sending automatic emails when excel cell date equals current date

    Thanks! Is there anything I need to do to connect the email addresses to the names in the checkmark list? I want only the ones checkmarked to be emailed when the due date on that row triggers.

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Need VBA script for sending automatic emails when excel cell date equals current date

    Yep, should already do that, see attached.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. automatic sending mail from excel 30 days before due date
    By tekken in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2013, 09:12 AM
  2. Sending Automatic emails from Excel
    By AliceHamilton in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 01:09 PM
  3. macro for sending emails to employees on a particular date of each month
    By hiteshdemla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2013, 08:47 AM
  4. Sending automatic emails dependant on date in a certain column
    By DannyJ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2012, 08:51 AM
  5. Excel 2007 : sending automatic emails from excel
    By barneyrubble1965 in forum Excel General
    Replies: 0
    Last Post: 11-16-2011, 08:10 AM
  6. Sending email using excel with current time/date
    By undergraduate in forum Excel General
    Replies: 1
    Last Post: 03-24-2010, 02:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1