Email merge

[Gene Augustin]

I have a newsletter that I want to send to a couple of hundred email
addresses. If I use the Word Data Merge Manager, I can get all of the email
addresses in an excel file to create an email for each of the desired
recipients. However, the document (that has pictures) shows up as a blank
document in the email. If I select html or attachment I still get an empty
email with a bunch of attachments.

I tried opening the document as read only and doing the merge from it, but
the recipient gets an editable document, which I don't want to happen.

I have acrobat pro. I save the Word Document as a pdf, but can't get it to
be the main part of the email although if I just drag it into a normal email
it shows up as the email page.

Is there a way to do this with word or excel?

 

[CyberTaz]

First of all, you make absolutely no mention of which versions of the
programs you're working with and without that information it's impossible to
offer anything specific. There are differences between versions.

Second, your mention of Data Merge Manager suggests you're using a Windows
version of Office whereas this is the group for Excel on the Mac.

Finally, it's actually a mail merge issue which would be more effectively
handled by a Word group rather than an excel group. You may find some useful
information here: <http://gmayor.com/graphics_on_labels.htm> but if you are
using a PC you'll do best to pursue this further in one of the Win Word
groups that deals with mail merge. You'll find the groups at:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Good Luck |:>)
Bob Jones
[MVP] Office:Mac

 

[Mungo]

Further to Bob's reply, I have done this in the past, but you have to be careful of what mail program you are using. I had to change to Entourage. I was running Office 2004 (for Mac).