Results 1 to 13 of 13

Simple VBA for sending email when date value in cell is reached

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-08-2008
    Location
    Belfast
    Posts
    112

    Simple VBA for sending email when date value in cell is reached

    Hi guys,
    I know this will be easy for many here but not for me. I know I require VBA to carry out the operation I require but I have little to no knowledge of VBA even into what sheet/module to place codes.

    I have a spread sheet that I insert dates into if a report is due review, these dates are in column "G" I require an email to be sent to the address entered in the adjacent cell "H" 14 days before this date is reached (most cells in "G" will be empty and only addresses will be entered in "H" if a review is required.) In column "B" I list the report names.

    I need a reminder email sent saying something like "Please review the report "XXXX"


    I am using Microsoft Oultook

    Any help would be greatly appreciated.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to send Automated Email when specific cell value reached due date
    By grlinks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2016, 12:22 AM
  2. Replies: 0
    Last Post: 11-24-2015, 03:29 AM
  3. Set outlook to send email when due date is reached
    By Camps1 in forum Excel General
    Replies: 5
    Last Post: 10-09-2014, 06:38 AM
  4. sending an email from excel when date is reached in a cell date
    By ldelafosse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2014, 08:58 PM
  5. Outlook email sent when date is reached
    By Dubby20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 10:19 AM
  6. Sending an email when a cell is todays date
    By ngrant01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2012, 07:51 AM
  7. Email once date reached on spreadsheet
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-13-2008, 10:47 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