Hello Mr.Excel members. I have a small project for church. I need to send out emails to our entire ward. I'd like to automate this as much as possible. My list is comprised of three columns with Name: Last/First/Middle, Email Address, Mailing Address, beginning A2 and concluding C143. Format looks as such: List of Emails Stroud, Harold Douglas yellowpaddler@aol.com 24560 Rosebay Terrace Stroud, Rebecca Stevenson rn21@aol.com 24560 Rosebay Terrace I would like to extract the first name from the list, excluding last and middle names, e.g., begin the email with Dear Harold, Dear Rebecca and then populate address field of the email w/ the corresponding email address. Could someone with the knowledge and experience assist me please? Thanks, Doug

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to send out bulk emails from PDF export?

Thread starter DougStroud
Start date Jan 3, 2021

DougStroud

Well-known Member

Jan 3, 2021

Hello Mr.Excel members. I have a small project for church. I need to send out emails to our entire ward. I'd like to automate this as much as possible.

My list is comprised of three columns with Name: Last/First/Middle, Email Address, Mailing Address, beginning A2 and concluding C143.
Format looks as such:
List of Emails

Stroud, Harold Douglas	yellowpaddler@aol.com	24560 Rosebay Terrace
Stroud, Rebecca Stevenson	rn21@aol.com	24560 Rosebay Terrace

I would like to extract the first name from the list, excluding last and middle names, e.g., begin the email with Dear Harold, Dear Rebecca and then populate address field of the email w/ the corresponding email address.

Could someone with the knowledge and experience assist me please?

Thanks,

Doug

Last edited: Jan 3, 2021