broman5000
01-23-2017, 12:18 PM
Don'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
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
xyz@asdfs.com
zzz
zzz
zzz
zzz
zzz
zzz
zzz
74
37
88
72
113
26
52
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
xyz@asdfs.com
zzz
zzz
zzz
zzz
zzz
zzz
zzz
326
165
387
318
495
114
230
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
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
xyz@asdfs.com
zzz
zzz
zzz
zzz
zzz
zzz
zzz
74
37
88
72
113
26
52
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
zzz
xyz@asdfs.com
zzz
zzz
zzz
zzz
zzz
zzz
zzz
326
165
387
318
495
114
230