+ Reply to Thread
Results 1 to 4 of 4

HOw to send a notification to a user when date is almost due

  1. 04-13-2018, 06:12 AM #1
    marcioalberto03
    marcioalberto03 is offline
    Registered User
    Join Date
    04-13-2018
    Location
    ANGOLA
    MS-Off Ver
    OFFICE 16
    Posts
    3

    Post HOw to send a notification to a user when date is almost due

    HI guys,
    I am new to this,
    I have a file that need to be check if the dates are due, and i need to send a e-mail to the person whos date is almost due, each person should have up to 20 documents attach,if one or more are due an e-mail should be sent.
    the file looks like this
    ID Name E-mail Doc1 Doc2 Doc3 Doc4 and so on, if one doc is due an email should be send to the person.
    I am trying to use VBA to help me on it.
    any helpwould be great.

    thanks
    Last edited by marcioalberto03; 04-13-2018 at 06:15 AM.
    Reply With QuoteRegister To Reply
  2. 04-13-2018, 06:16 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: HOw to send a notification to a user when date is almost due

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 04-13-2018, 06:39 AM #3
    marcioalberto03
    marcioalberto03 is offline
    Registered User
    Join Date
    04-13-2018
    Location
    ANGOLA
    MS-Off Ver
    OFFICE 16
    Posts
    3

    Re: HOw to send a notification to a user when date is almost due

    I have done it,
    can u see now
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-17-2018, 03:56 AM #4
    marcioalberto03
    marcioalberto03 is offline
    Registered User
    Join Date
    04-13-2018
    Location
    ANGOLA
    MS-Off Ver
    OFFICE 16
    Posts
    3

    Re: HOw to send a notification to a user when date is almost due

    Hi Guys,
    can someone help with this issue.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vba macro to send a notification to email based on a date
    By jennah63 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-15-2018, 01:10 PM
  2. How do I send a notification email?
    By stodd72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-03-2015, 12:08 PM
  3. Excel Macro to send notification email when items pass a certain date
    By Krist87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2014, 09:08 AM
  4. How To Have Email Notification 30 Days Before Due Date Send To Outlook
    By Blizzard13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2013, 10:20 AM
  5. Auto send email notification
    By blackdiam0nd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2012, 04:12 AM
  6. How to send email notification from excel
    By amitwaje in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 06:49 AM
  7. Send notification from Excel
    By Link in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2008, 03:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1