+ Reply to Thread
Results 1 to 2 of 2

Auto generating emails based on date in cell

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    1

    Auto generating emails based on date in cell

    I'm afraid this might be difficult. Any assistance is much appreciated.

    I want to create a macro or VBA that sends out reminder emails to addresses in one cell based on a date in another cell on the same row. This woyuld be to remind the recipients that their closing date has arrived and that action is required on their end.

    The attached picture shows a simplified version of the data I'm working with.

    So the email would be automatically sent to the address in E, based on the date in D. Preferably the email would have blanks that could be filled in with info from A, B and D. And if F could be filled in with sent/not sent that would also be terrific.

    Is there any way of going about this? or is it too complex?

    Sample.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2506 Win 11
    Posts
    24,901

    Re: Auto generating emails based on date in cell

    See if one of Ron's solutions work for you.

    http://www.rondebruin.nl/win/s1/outlook/mail.htm
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Auto Send Emails Based on Due Date
    By Nuclearman83 in forum Excel General
    Replies: 5
    Last Post: 03-23-2012, 02:54 PM
  2. auto generating number based on information from other cells
    By cody1187 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 02-21-2012, 02:27 PM
  3. Auto generating a printed date
    By Tbone in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-17-2006, 06:20 PM
  4. Send Mail Merge Auto-Emails based on date
    By Phillycheese5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2005, 11:40 AM
  5. Generating Emails from Excel
    By Emyn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2005, 05:46 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