How do you add attachments in Word for mail merge emails?

E

Eric Linkugel

I am trying to use Word to send emails as a mail merge, and using contacts
from an Excel file. I am not quite sure how to send any document as an
attachment as you would in Outlook. For example, if I want to add a PDF file
as an attachment to the email, how do you do this in the word mail merge
setting?
 
G

Graham Mayor

Eric said:
I am trying to use Word to send emails as a mail merge, and using
contacts from an Excel file. I am not quite sure how to send any
document as an attachment as you would in Outlook. For example, if I
want to add a PDF file as an attachment to the email, how do you do
this in the word mail merge setting?

See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
E

Eric Linkugel

Thanks for the reply. Unfortunately I experienced the same error message that
another user did when running the listed macro. It doesn't follow through. I
created the catalogue, and followed the directions, but the macro seems to
cause a runtime error every time. The instructions might need a little
clarifying. I may be running the macro from the wrong program, but I tried
running it from both the Outlook macro command and the Word macro command.
Both gave me errors. Are there some steps missing from the instructions to
make it more clear? Have you been able to get this to work? Thanks,
-Eric
 
G

Graham Mayor

This is a Word macro (not Outlook). What is the flagged error line when you
debug the code?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
E

Eric Linkugel

The error says: "Compile error: user-defined type not defined"
The section of code that is highlighted is

"Dim oOutlookApp as Outlook.Application"
 
G

Graham Mayor

You appear to have omitted the 'Preparations'

"To run the macro in this procedure it is necessary to set a reference to
the Microsoft Office Outlook Object Library. You do this from within the
Visual Basic Editor, by selecting References from the Tool menu and then
checking the item Microsoft Office Outlook ##.0 Object Library (where ## is
the Outlook version number)."

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
E

Eric Linkugel

Thanks for the reply again Graham. Actually I looked into the references and
this was already checked, and towards the top.
-Eric
 
G

Graham Mayor

Doug is away at the moment, but I have cross posted this message to his
private e-mail address. If he is able to receive mail at present he will not
doubt get back to you. If you mail me via my web site link, I will post a
GIF of the references I have checked here in case there is some conflict.
The macro works fine for me.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top