+ Reply to Thread
Results 1 to 2 of 2

Mapping email addresses, then send and email according to 3 days prior to task date

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Mapping email addresses, then send and email according to 3 days prior to task date

    I hope someone can help me as I don't know if this is possible. I would like to send an email 3 days before the date in Column F to an email address that has been mapped according to the initials in column D with the text that reads "Task is coming due, please check Project Management spreadsheet for details". If there is no date in column F, it will send text "Estimated completion date required on a task. Please see Project Management spreadsheet for details". I need it to be sent from a certain email address as well. ProjectManagement.xlsx

    Can anyone provide code that will perform these functions? I've attached the spreadsheet in question.

    Thank You!

  2. #2
    Registered User
    Join Date
    09-03-2013
    Location
    Birmingham, AL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Mapping email addresses, then send and email according to 3 days prior to task date

    Bump..hoping someone can help me with this. Thank You!

+ 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. Automatically Send Email when an task is expiring
    By richard@magnumpower in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2013, 07:21 PM
  2. sending an email 7 days prior to a due date
    By tgazzi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2013, 12:28 AM
  3. excel code that will send mail to 2 email ID before 30 days of visa date expiry
    By rinadimayuga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2012, 04:24 AM
  4. macro to automatically send email to two addresses
    By shears in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2007, 05:52 PM
  5. [SOLVED] send email with email addresses in a range of cells
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2005, 05:05 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