+ Reply to Thread
Results 1 to 5 of 5

Automatic email notification based on due date

  1. #1
    Registered User
    Join Date
    09-26-2014
    Location
    Indiana, USA
    MS-Off Ver
    2010
    Posts
    6

    Automatic email notification based on due date

    I am trying to set up an excel that will automatically email someone when their complaint is due in 5 days.
    I need to know what's wrong with my code here. I copied it from another forum and I thought I had converted it correctly but now I have no idea what is wrong. It doesn't show any errors but it just does nothing.

    Please help!
    Thanks in advance

    New CRMT.xlsm

  2. #2
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Automatic email notification based on due date

    see if it helps you
    it reads date in column U. add a button to yr sheet and copy/paste this piece of code without the first line ("Private Sub..") and the last line (End Sub)
    Please Login or Register  to view this content.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Automatic email notification based on due date

    Hi sarsmelt

    Column A has no data in it
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    09-26-2014
    Location
    Indiana, USA
    MS-Off Ver
    2010
    Posts
    6

    Re: Automatic email notification based on due date

    Yay!! this worked John! Thank you so much

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Automatic email notification based on due date

    You're welcome.

+ 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 email notification based on due date
    By sarsmelt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2014, 10:41 AM
  2. Replies: 1
    Last Post: 04-23-2014, 03:36 AM
  3. [SOLVED] VBA code to send automatic email notification to the users
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-24-2013, 08:46 AM
  4. excel 2007 automatic email notification
    By Jayrene in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-29-2012, 02:56 AM
  5. automatic email notification
    By alxnlsn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2009, 03:03 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