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