use excel to send email without macro
 

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.

use excel to send email without macro
 

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.

use excel to send email without macro
 

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.

use excel to send email without macro
 

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.

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