+ Reply to Thread
Results 1 to 4 of 4

Automatic Email Reminder From Excel Without Spreadsheet Being Open

  1. #1
    Registered User
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    4

    Automatic Email Reminder From Excel Without Spreadsheet Being Open

    Hi all,

    I am trying to make a spreadsheet with a list of dates and for it to send automatic email reminders at given times. As the purpose of this is to create reminders, the idea is to be able to receive these reminders via email without the spreadsheet being open. I have attached below a macro spreadsheet created with just a small dummy sample of names and dates but have not been able to get it to work.

    Any help would be much appreciated.

    Kind Regards
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,987

    Re: Automatic Email Reminder From Excel Without Spreadsheet Being Open

    The workbook will need to be open to run the macro.

    You can use the Windows Scheduler program to run the workbook.


    Or you can utilize this resource instead :

    https://wellsr.com/vba/2015/excel/ru...sing-vbscript/

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Automatic Email Reminder From Excel Without Spreadsheet Being Open

    Give more details on how,when, what you would like to Email.
    To access to Window Program scheduler you could see

    https://www.top-password.com/blog/5-...in-windows-10/
    - Battle without fear gives no glory - Just try

  4. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,163

    Re: Automatic Email Reminder From Excel Without Spreadsheet Being Open

    samsmith123, perhaps a minor modification to your macro is enough. The secret is in the use of the DeferredDeliveryTime property of the MailItem object. The whole is attached.
    How it's working? Every now and then, once a day is enough, open this workbook. In MS Outlook, e-mails with a delayed dispatch date will be defined according to the value in column C. But for these e-mails to be actually sent, Outlook must be running on the defined dispatch days (at this point, Excel can be closed). Until they are sent, the e-mails are stored in the "Outbox" folder.

    Code in ThisWorkbook module:
    Please Login or Register  to view this content.
    and in standard module (eg Module1):
    Please Login or Register  to view this content.
    Artik
    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. Actions tracker automatic email reminder
    By LeonCubano in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2017, 05:50 PM
  2. Due date automatic email reminder excel vba
    By Vicky2413 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2017, 11:48 AM
  3. [SOLVED] Automatic Email or Reminder When Birthday is Approaching
    By jebindavidson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-08-2016, 08:59 AM
  4. Interactive calendar and automatic email (Lotus) reminder help
    By Cassie4258 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2016, 10:45 AM
  5. Automatic Reminder email from Excel 2013 in Windows 7 pc
    By ashook.p in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2015, 06:16 AM
  6. 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
  7. Automatic Reminder Email
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2010, 07:29 PM

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