PDA

View Full Version : VBA select/send email based off criteria



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

asantos2017
09-12-2017, 08:02 AM
Hello broman, any success with this one?
I've got caught up in the same situation.

mdmackillop
09-12-2017, 08:35 AM
Looks very similar to this (http://www.vbaexpress.com/forum/showthread.php?60662-Help-on-filtering-an-excel-based-Column-C-and-send-email-for-every-filtered-item).