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.

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.

Not possible without macros


--
Regards,

Peo Sjoblom



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

See reply in your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

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