+ Reply to Thread
Results 1 to 5 of 5

I need excel to send out an email as a reminder that an expiration date is coming due.

  1. #1
    Registered User
    Join Date
    08-01-2014
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    4

    I need excel to send out an email as a reminder that an expiration date is coming due.

    Can anyone help me with getting Excel to send an email in outlook as a reminder that a expiration date is coming due?
    I need to know a month in advance that a date in column F is coming due.
    Btw, I have zero experience with VBA but I am anxious to learn.
    Any help with this will be greatly appreciated.
    Thank you,
    Grim
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: I need excel to send out an email as a reminder that an expiration date is coming due.

    Here's an article about that. Post back if you have more questions.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    08-01-2014
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    4

    Re: I need excel to send out an email as a reminder that an expiration date is coming due.

    Thank for the reply.
    The article in the link you posted is very confusing. It appears that the only time the code in it will send an email as if/when you manually change the value in the target cell.
    I need an email sent 30 days prior to the due dates if column F (F3:F21) in the sample workbook in my original post.
    Any help you can provide will be greatly appreciated.
    Thank you,
    Grim

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: I need excel to send out an email as a reminder that an expiration date is coming due.

    OK, you got me.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-01-2014
    Location
    Virginia
    MS-Off Ver
    2010
    Posts
    4

    Re: I need excel to send out an email as a reminder that an expiration date is coming due.

    Thank you Tinbender.
    Works like a charm.
    R/
    Grim

+ 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. Use Hyperlink to send email 6 months before expiration date
    By mcivli65 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-28-2015, 01:24 PM
  2. Send email reminder based on due date while excel doc is closed
    By gnada in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2015, 07:51 PM
  3. using excel to send reminder email using vb
    By Keith Gold in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2015, 01:05 AM
  4. send reminder email from excel spreadsheet based on several next due columns
    By lisanoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2013, 02:38 AM
  5. Replies: 5
    Last Post: 02-22-2013, 02:00 AM
  6. auto search for expiration date and send email to users
    By mingchu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2013, 06:07 PM
  7. Excel 2007 : Pop up reminder and send email from Excel 2007
    By excel_for_dummy in forum Excel General
    Replies: 1
    Last Post: 12-19-2011, 05:06 PM

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