VBA select/send email based off criteriaDon't know how to accomplish this as i've never coding in e-mails for outlook
I have cell below A-AA where the word "column" begins on row 4
For columns T-Z, if any cell is highlights in that certain row as RGB(252,213,180), then draft e-mail that corresponds to column L's row
The data will change week over week but the worksheet will stay the same
Email would be something like
from : supplychain
to : corresponding cell
subject : forecast change
body : Hi, there is a forecast change, please take a look at your highlighted changed.
In the body or attachment I would like to show only that corresponding row...that way the other suppliers don't see eachothers data.
Hope that makes sense. I have included the worksheet as well attached.
Anything to help would be great!
WEEKLY FORECASTED NEEDS New Items Added to Grid Highlighted in This Color PRODUCT INFORMATION WAREHOUSE INFORMATION Concept Promo Name Start Date End Date Duration of Promo (in Days) Obosolete/Reduced Item Check In Date Category Product Item Number Case Size Column Column Column Column Column Column Column Column Column Column Column Column Column Column Column Column Column zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 22 20 76 34 39 22 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 26 23 88 40 45 26 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 166 49 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 13 12 46 21 24 14 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 15 13 50 22 26 15 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 48 43 75 85 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 18 16 28 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 61 32 18 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 174 154 595 268 306 175 zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz zzz xyz@asdfs.com zzz zzz zzz zzz zzz zzz zzz 15 96 44 363 558
Reply With Quote