Hi Aaron,

Not possible without macros.
With macros; look at Ron de Bruin's add-in:

http://www.rondebruin.nl/mail/add-in.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aaron" wrote in message ...
|I have a column that contains different email addresses. the next column has
| a value, say sales$. I would like to send a form email for each email
| address.
|
| the email would go
|
| Dear <name
|
| Your sales quota for July is <sales$, and blah blah blah.