# Excel 2007/Email Question

**URL:** <https://boards.straightdope.com/t/excel-2007-email-question/637323>\
**Category:** Factual Questions\
**Created:** [October 10, 2012, 4:19pm UTC](https://boards.straightdope.com/t/excel-2007-email-question/637323 "2012-10-10T16:19:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SanDiegoTim](https://avatars.discourse-cdn.com/v4/letter/s/85e7bf/32.png) [@SanDiegoTim](https://boards.straightdope.com/u/SanDiegoTim)\
**Post date:** [October 10, 2012, 4:19pm UTC](https://boards.straightdope.com/t/excel-2007-email-question/637323/1 "2012-10-10T16:19:23Z")

</div>

I’ve got a roster of names (about 50) with email addresses in an Excel 2007 file. Can I send an email to all directly from Excel?

Thanks.

---

<div class="post-metadata">

**Author:** ![TroutMan](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/troutman/32/6721_2.png) [@TroutMan](https://boards.straightdope.com/u/TroutMan)\
**Post date:** [October 10, 2012, 4:43pm UTC](https://boards.straightdope.com/t/excel-2007-email-question/637323/2 "2012-10-10T16:43:15Z")

</div>

Not directly from Excel, but you can use Word mail merge to do it, with your Excel file as the data source. See here: [Microsoft Support](http://office.microsoft.com/en-us/word-help/use-mail-merge-to-distribute-merged-e-mail-messages-HP005187257.aspx)

---

<div class="post-metadata">

**Author:** ![JWT\_Kottekoe](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@JWT\_Kottekoe](https://boards.straightdope.com/u/JWT_Kottekoe)\
**Post date:** [October 11, 2012, 1:45am UTC](https://boards.straightdope.com/t/excel-2007-email-question/637323/3 "2012-10-11T01:45:17Z")

</div>

You should also be able to simply cut-and-paste the email addresses all at once into the TextBox for the To: address in your email software. I do this from time to time with Excel and Outlook.

---

<div class="post-metadata">

**Author:** ![redtail23](https://avatars.discourse-cdn.com/v4/letter/r/3e96dc/32.png) [@redtail23](https://boards.straightdope.com/u/redtail23)\
**Post date:** [October 11, 2012, 1:43pm UTC](https://boards.straightdope.com/t/excel-2007-email-question/637323/4 "2012-10-11T13:43:18Z")

</div>

Email can be sent directly from Excel using VBA code, but that’s probably more than you want to get into for a simple list.

For what you’re doing, I’d probably go with **TroutMan** ’s method.

For those interested, here’s [some](http://www.rondebruin.nl/sendmail.htm) [info](http://spreadsheetpage.com/index.php/tip/sending_personalized_email_from_excel/) on sending email from Excel.