email merge from excel data source

S

sierralightfoot

I've read lots of posts but can not get clear understanding:
I want to respond/send to an email using an email list from excel.
Do I have to:
1 import the list to an outlook contact folder first?
2 go through word mail merge?
3 I prefer a direct merge from excel to outlook/send
 
R

Roady [MVP]

Option 2 it is. You can select Excel as a data source when doing a mail
merge and choose Outlook as the output.
 
R

Roady [MVP]

No, as you cannot type a message in Excel and Outlook has no "mass document
creation" features. Word is the glue here.

If you need to do this repeatedly, you can consider importing the Excel list
and managing the contacts from thereon from within Outlook. You can then use
an addin to automatically generate personalized emails. This way, you'll
only be working with Outlook instead of 3 separate programs. Below you'll
find 2 addins which can do this;

http://addins.howto-outlook.com/sperry_sendindividually
If you decide to order use BH93RF24 to get a discount

http://addins.howto-outlook.com/mapilab_sendpersonally
If you decide to order use 4PM76A8 to get a discount



-----
 
R

Russ Valentine [MVP-Outlook]

That's up to you. You have yet to clarify whether you really need to do a
mail merge or just send a message to multiple recipients. The former
obviously requires Word and always has. The latter would not.
 
Top