J
James
All,
I am looking for a macro that sends an email to two recipients based on the
cell values in a range. I have a table of 150 rows where a cell value can
fall below 0 (or conditional formatting turns it red), and for each row where
the value is less than 0 (or is red), send an email with a subject heading
which includes the row identification.
EG.
Cell A1: 80163
Cell B1: -15
Recipients: (to) Joe Bloggs ; (cc) Fred Bloggs
Email with the subject heading "80163 - Over allocation"
Message: "80163 has been over allocated by 15 man-days"
Repeat this for all rows, therefore if B2 is (positive) 15, an email is not
sent.
If changes were made to other calculations which resulted in B1 becoming
positive, I don't want the macro to loop through the entire list again and
re-send emails. I would prefer the this re-sending loop to occur every
fortnight on a Wednesday.
Hope this makes sense!
If anyone can help with this, it would be greatly appreciated.
James
I am looking for a macro that sends an email to two recipients based on the
cell values in a range. I have a table of 150 rows where a cell value can
fall below 0 (or conditional formatting turns it red), and for each row where
the value is less than 0 (or is red), send an email with a subject heading
which includes the row identification.
EG.
Cell A1: 80163
Cell B1: -15
Recipients: (to) Joe Bloggs ; (cc) Fred Bloggs
Email with the subject heading "80163 - Over allocation"
Message: "80163 has been over allocated by 15 man-days"
Repeat this for all rows, therefore if B2 is (positive) 15, an email is not
sent.
If changes were made to other calculations which resulted in B1 becoming
positive, I don't want the macro to loop through the entire list again and
re-send emails. I would prefer the this re-sending loop to occur every
fortnight on a Wednesday.
Hope this makes sense!
If anyone can help with this, it would be greatly appreciated.
James