View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default use excel to send email without macro

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/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

Aaron wrote:

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.


--

Dave Peterson