+ Reply to Thread
Results 1 to 1 of 1

Automatic Reminder email from Excel 2013 in Windows 7 pc

  1. #1
    Registered User
    Join Date
    05-01-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    1

    Automatic Reminder email from Excel 2013 in Windows 7 pc

    Hello Everyone!

    This is my first post here. I am using Excel 2013 OS win 7. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

    In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

    Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

    I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

    I'd really appreciate any help,
    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. [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
  2. [SOLVED] Set Outlook reminder from Excel cell date. Office 2013
    By Peterino in forum Excel General
    Replies: 1
    Last Post: 10-22-2014, 05:41 PM
  3. Outlook Email & Reminder from Excel
    By rucker222 in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2014, 04:43 AM
  4. Excel 2013, Formula entry with two windows.
    By Kevin UK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2013, 12:43 PM
  5. Automatic Reminder Email
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2010, 07:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1