Results 1 to 4 of 4

Thread: Automatic email triggers to 10 people when condition in cell is met

  1. #1

    Automatic email triggers to 10 people when condition in cell is met



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi everyone,
    I have sheet1 which has many data in it.
    The column12 is conditionally formatted to indicate the status. It is automatically populated with word 'overdue' when a condition is met.
    It works fine.

    I want now to have a VBA code to simply send email to specified group of 10 people automatically, with contents of that entire row ( column 1 to 12) attached or copied in email.
    It sounds beyond me as I am very new in this field and learning.
    The dummy sheet attached explains well. There are two questions in it. One on sheet1 and one on sheet2.
    Sheet2 question pertains to transfer of data from one page to another which is another subject. I will deal with it in another post. If you want to help on that as well, then I will be thankful.

    Can any one help please??
    Attached Files Attached Files

  2. #2
    Acolyte Charles's Avatar
    Join Date
    Feb 2013
    Location
    Biloxi
    Posts
    34
    Articles
    0
    Falcon,

    When do you want to run the code for Email?
    Do you want to check the "Over Due" column When you open the workbook?
    Also you will need to determine if the mail was sent.
    What would you use to determine this?

  3. #3
    Acolyte Charles's Avatar
    Join Date
    Feb 2013
    Location
    Biloxi
    Posts
    34
    Articles
    0
    Hi,

    See if this site helps. If you require more help let us know.

    http://www.rondebruin.nl/mail/folder2/mail4.htm

  4. #4
    Hi,
    I want the auto-email sent when column 12 ( that is 'L') becomes populated with word 'Overudue' in sheet1 or sheet2. ( Populating this column is done with a formula).
    Is it possible?
    I will also check the site you have advised.
    Thanks my friend.

Posting Permissions

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