ExcelBanter - How do I take cell data and automatically put it in an email?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I take cell data and automatically put it in an email? (https://www.excelbanter.com/excel-worksheet-functions/79479-how-do-i-take-cell-data-automatically-put-email.html)

How do I take cell data and automatically put it in an email?

I have an Excel spreadsheet of donations with a YTD total for each donors. I
want to send each donor an email showing this YTD total. Is there a way to
automatically prepare an email for about 100 different donors showing their
individual YTD donations as listed on my Excel spreadsheet?

How do I take cell data and automatically put it in an email?

Carmel --

I know you can use Excel to support the MailMerge utility in Word, so I
suspect you can do it in Outlook as well. I'd ask your question over there.
While waiting for an answer, I'd make sure that one of the columns has valid
e-mail addresses.

Sorry I can't be more helpful.

Peter

"carmel loughman" wrote:

I have an Excel spreadsheet of donations with a YTD total for each donors. I
want to send each donor an email showing this YTD total. Is there a way to
automatically prepare an email for about 100 different donors showing their
individual YTD donations as listed on my Excel spreadsheet?