VBA - Updating Sheets and Sending Email to Multiple Recipients

[jamesmev]

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....

 

[KOKOSEK]

All these data are in the same column? Row by row?

 

[jamesmev]

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

 

[KOKOSEK]

Check this thread:

Send multiple mails with required body of the mail, Attachment, Subject of the mail to specific mail address