How do I email a mail merged document?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lindsay - 20 Oct 2004 16:39 GMT

I am trying to email a mail merged document to 130 different contacts. How
do I go about doing this? I want to be sure that each contact only receives
their letter with their info in it and not the other contacts' info. Please
help.

Reply to this Message

Doug Robbins - 21 Oct 2004 01:05 GMT

Use a modification of the method in the article "Mail Merge to E-mail with
Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

You won't need the attachments in the catalog or directory type merge
document, and comment out the lines to do with attachments in the macro.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I am trying to email a mail merged document to 130 different contacts. How
> do I go about doing this? I want to be sure that each contact only
> receives
> their letter with their info in it and not the other contacts' info.
> Please
> help.

Reply to this Message

Mark B - 17 Feb 2005 01:13 GMT

Doug, That link leads to one of the most un-well-written explanations I ever
saw.

"set a reference to the Microsoft Office Outlook Object Library from within
the Visual Basic Editor" but with no explanation of hot to get into VBE

"create a separate Catalogue" - what is a catalogue?

I really need to do what is explained in that document, but i can't
unerstand word one, and I am a computer professional. Can you lead me to
something more specific, on how to merge an email so that the merged document
goes to the specific email address within the database file along with a
specific attached file for that specific email address.

Thansk!

> Use a modification of the method in the article "Mail Merge to E-mail with
> Attachments" at
[quoted text clipped - 9 lines]
> > Please
> > help.

Reply to this Message

Doug Robbins - 17 Feb 2005 02:10 GMT

I am not a computer professional and many people who are not computer
professionals have successfully achieved what they are after by reading that
article. As a computer professional familiar with the abbreviation for the
Visual Basic Editor, one would expect that you would know what it was and
how to access it.

If you read the article you will see that is says "to create a separate
Catalogue (or in Word 2002 and later, Directory) type mail merge main
document", not just "create a separate Catalog" and then goes on to detail
how that main document should be set up.

If that is all foreign to you RTFM.

Signature

> Doug, That link leads to one of the most un-well-written explanations I
> ever
[quoted text clipped - 30 lines]
>> > Please
>> > help.

Reply to this Message

Mitch - 18 Feb 2005 18:37 GMT

Doug,

Thanks for your script, it worked in creating multiple personalized
emails
with attachments, however one problem I come up with is the letter I'm
sending
contains bulleted text and when the script runs it creates the email
w/o any bullets
and converts the font from Times NR to Arial.

I've tried various techniques to modify
the script, for example:
.BODYFormat = (i've tried RTF, Plain text and HTML which is the
default)
copy the text using .HTMLBody instead of .BODY but no sucess

I've even tried creating a docItem instead of a MailItem w/obvius
results

BTW the mailmerge function in WORD 2003 does copy the formatted text
over into Outlook, preserving the bullets and font settings

Any help you can give would be greatly appreciated, thanks

Mitch

Reply to this Message