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

Falcon

New member
Joined
Mar 25, 2013
Messages
9
Reaction score
0
Points
0
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??
 

Attachments

  • Dummy.xlsx
    21.6 KB · Views: 34
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?
 
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.
 
Back
Top