VBA - Updating Sheets and Sending Email to Multiple Recipients

jamesmev

Board Regular
Joined
Apr 9, 2015
Messages
137
I am hoping for some help on this one. Looking for a VBA wizard to direct me .

I have an email list where the Name/Address/Birthday/Todays Date is noted.
On sheet2 I have a generic message.
I need to send an email to all of the people on the list with the generic message as a PDF.
This part is easy enough..
I need to include above the generic message that specific recipients information (Name/Address/Birthday/Today's Date).



Example:
Recipient 1:

John Doe
123 Main Street
1/1/1990
1/15/2020

Generic Message
(send email PDF)

Recipient 2
Jane Doe
234 Cross Ave
2/2/1999
1/15/2020

Generic Message
(send email PDF)

Etc....
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

KOKOSEK

Board Regular
Joined
Apr 8, 2019
Messages
208
Office Version
365, 2013
Platform
Windows
All these data are in the same column? Row by row?
 

jamesmev

Board Regular
Joined
Apr 9, 2015
Messages
137
Sheet1

Column A = Email Address
Column B = Name
Column C = Address
Column D = Birthday
Column E= Todays Date

Sheet 2:
B2 = Todays Date
B4 = Name
B5= Address
B6 =Birthday
B7 = Todays Date

B9 = Generic message
 

Watch MrExcel Video

Forum statistics

Threads
1,099,491
Messages
5,468,926
Members
406,620
Latest member
Gitani123

This Week's Hot Topics

Top