How do I attach documents to mail merge emails?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rod - 01 May 2006 18:14 GMT

I want to mail a document to several different people using mail merge and I
need to add attachments before the mail merge process sends the email. How
do I do this.

Reply to this Message

Doug Robbins - Word MVP - 01 May 2006 18:26 GMT

See the article "Mail Merge to E-mail with Attachments" at

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I want to mail a document to several different people using mail merge and
>I
> need to add attachments before the mail merge process sends the email.
> How
> do I do this.

Reply to this Message

Gail - 01 Aug 2006 12:38 GMT

Hi Doug

Sorry to once again barge in, but I do not seem to be able to start a new
thread. I am still having problems with mail merge to e-mail with
attachments. This is what I'm doing ... perhaps you can let me know where I'm
going wrong:

I have my letter in word (Let 1) and my data source in excel (data 1)

In Word I have a new doc, I then mail merge – chose directory – used the
current doc – selected recipients – included attachments – executed the mail
merge to a new doc – saved it (gail1) and closed it.

I then. opened the letter I want to send out by email with the attachments,
mailmerge – email message – current doc – selected my data source (data 1) –
included my address block and greeting line – preview email messaging –
executed the mail merge to a new doc – made sure that Microsoft Office
Outlook 11.0 Object Library is selected – ran the macro (which I had copied
and pasted).

The following error message: “Compile error: user-defined type not defined”
appears and the line “Dim oOutlookApp As Outlook.Application” in the macro is
highlighted.

Please help.

Signature

GVP

> See the article "Mail Merge to E-mail with Attachments" at
>
[quoted text clipped - 5 lines]
> > How
> > do I do this.

Reply to this Message

Doug Robbins - Word MVP - 01 Aug 2006 18:13 GMT

I don't really know what is causing the reference to be ignored. It is the
first time that I have heard of it happening. In the References dialog in
the Visual Basic Editor, when the Microsoft Office Outlook 11.0 Object
Library is selected, what appears in the lower section of the dialog where
the location of the file is shown?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi Doug
>
[quoted text clipped - 39 lines]
>> > How
>> > do I do this.

Reply to this Message