Results 1 to 3 of 3

Thread: sending e mails from excel via outlook at diferent stages depending on cell data

  1. #1
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12

    sending e mails from excel via outlook at diferent stages depending on cell data

    Hi
    I have attached a trial wb.

    I have a code that will send an email depending on a date in column f.
    It sends it to the email in the code.

    What i am trying to acheive is that when column f date is today it will send an email to the persons email responsible in the row or from a list.if the operator enters a yes in column g no more emails until the date in column h is reached to continue all year. But if the cell in column g remains blank another overdue email would be sent until yes is enterd.

    Each row could have a different email

    And there would be at least 7 sheets for diferent sites

    Is this possible ???

    Any help would be appreciated

    Peter
    Attached Files Attached Files

  2. #2

  3. #3
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12
    Hi

    I have added a code that allows column g only to be updated so the emailer need only look at this column



    dont know if this makes the process easier??


    Peter
    Attached Files Attached Files
    Last edited by peter renton; 01-11-2014 at 12:19 AM. Reason: wrong file added

Similar Threads

  1. Replies: 26
    Last Post: 10-22-2019, 02:39 PM
  2. Send Multiple Outlook Mails Using The Same Template
    By forums1167 in forum Excel Help
    Replies: 1
    Last Post: 07-20-2013, 03:13 PM
  3. Replies: 6
    Last Post: 05-25-2013, 07:36 PM
  4. Replies: 7
    Last Post: 08-08-2012, 10:24 AM
  5. Replies: 3
    Last Post: 02-20-2012, 12:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •