+ Reply to Thread
Results 1 to 2 of 2

Help! Macro that sends auto emails based on date

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help! Macro that sends auto emails based on date

    okay i am brand new to vba and macros and went through this and tried to figure it out but to no avail. do i use a separate code for each column? for an example for column D (DL. Exp.) i need an automatic email to send that lets me know that their driver's license expires in less than 30 days. then an email if column F is 30 days from expiring and the email to say cpr expires and same for G. im sorry as i said before i am brand new to this. Thanks for however can help me out.


    Name D.O.H. DL Exp. CPR Exp. Ins. Exp. Med. Exp
    Amekudzi Charlton 2/13/2013 11/20/2016 1/1/2015 4/2/2014 1/23/2015
    Anderson Melissa 11/12/2012 1/4/2016 4/1/2014 4/30/2013 -
    Anderson Robert 4/6/2013 5/20/2013 11/1/2013 1/4/2014 -

  2. #2
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Help! Macro that sends auto emails based on date

    bump..........

+ 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. Macro not Auto-Sending Emails
    By remadison3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 08:32 PM
  2. Auto generating emails based on date in cell
    By Snaga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2014, 12:41 PM
  3. Macro that will auto save only emails with an attachment?
    By Castillb in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 06-05-2013, 01:31 PM
  4. Auto Send Emails Based on Due Date
    By Nuclearman83 in forum Excel General
    Replies: 5
    Last Post: 03-23-2012, 02:54 PM
  5. Send Mail Merge Auto-Emails based on date
    By Phillycheese5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2005, 11:40 AM

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