use excel to send email without macro

[Guest]

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.

 

[Niek Otten]

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

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

 

[Peo Sjoblom]

Not possible without macros

 

[Ron de Bruin]

See reply in your other thread

 

[Dave Peterson]

How about keeping your data in Excel and using MSWord's Mail Merge capability.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

And if your data has zipcodes/numbers and you want to keep a nice format:

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.