+ Reply to Thread
Results 1 to 1 of 1

Automatically send a email when date is matching

  1. #1
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Automatically send a email when date is matching

    Hi

    At closing of 2019 we've got thread about creating something what can automatically creates email based on date in cell.
    I am using something like this. I've been asked to put this solution here as quite easy and helpful.

    So:
    1. Data are organised like below:
    A
    B
    C
    D
    E
    F
    G
    1
    WHO body text DUE DATE ADDRESS
    2
    Dave Just reminder
    03/04/2020
    [email protected]
    3
    Steve Happy Birthday pal
    05/08/2020
    [email protected]


    column C/D/E are empty and can be use to more text in particular email.

    2. Macros in xlsm file:
    Standard module
    (if you want to recopy this macros please remove additional space in html tags, I have to add it on because firewall does not let me send html in post, check blueish lines)

    HTML Code: 
    as you can spot, there is few lines commented (' at start). All are related in case if you want to add picture in email. Picture path have to be set properly and then line can be uncommented.
    BE AWARE THAT IF YOU UNCOMMENT THESE LINES AND PICTURE FILE DOES NOT EXIST, EMAIL WON'T BE CREATED!

    ThisWorkbook code:
    Please Login or Register  to view this content.

    3. Running file (TXT file with VBS extension):
    strPath of course have to be set according to your structure on disk and access
    Please Login or Register  to view this content.
    4. Set schedule to run VBS file as above in Windows TaskScheduler (I've got on daily at 10:00)

    VBA file should run excel file in background, excel itself should runs its macros and due to the fact that .Send parameter is set message should be send in outlook background without displaying.
    Attached Files Attached Files
    Last edited by KOKOSEK; 01-02-2020 at 06:08 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. Send a reminder email automatically when the due date is approaching
    By AMKTS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-31-2019, 05:39 AM
  2. automatically send out an email when a certain date is getting nearby as an Alert
    By Tagmaniak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2018, 04:58 AM
  3. Send email automatically through outlook on near due date with attachment
    By janakkaneria in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2018, 11:22 AM
  4. Replies: 1
    Last Post: 01-05-2017, 08:33 AM
  5. How to write macro to send email when date is matching with current date
    By gunanidhi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2016, 02:16 AM
  6. Have excel automatically send an email when a date is near
    By MCCranes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2014, 09:16 AM
  7. Send email automatically before due date
    By Kara_xy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2013, 06:11 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