Email merge with attachment

K

Kaylen

I have been trying to figure out how to follow the directions given at the
site:
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

I get to the part of making the table. I was able to paste and save the
macro into VBA. Now I am stuck figuring out to make this mail merge with
attachment work.
I have a document I want to send out as the email message along with a
attachment which I know the path and file name. What should I do with the
table and where do I run the macro so that the document I have can be sent to
the email addresses from the table along with the attachments from the
attachment row of the table. I think I'm half way there. I'm just missing
something. Can anyone please guide me through? I hate to quite half way.
Thanks so much!
 
D

Doug Robbins - Word MVP

The instructions in that article detail all of the steps that are required,
and they must all be followed. There are no shortcuts.

Basically, you must create and EXECUTE to mail merges, BOTH OF WHICH MUST
USE THE SAME DATA SOURCE. The first one is the catalog/directory type mail
merge which is the one in the main document of which you setup the table
with the mailmerge field that contains the email addresses in the first cell
and, in your case as it sounds like you are sending the same file to each
person, the path and filename of that file in the second cell like the
second example in the article. You must execute that merge to a new
document and the document produced by that merge will contain a table with a
row of data for each record in the data source. In the first column will be
the email addresses and in the second column of the table the path/filename
of the attachment will be repeated over and over.

You must then save and close that file. Below, I will refer to this as
DOCUMENT A

Next, you create a letter type mail merge main document using the SAME data
source. This document will for the text of the email messages. When you
have this document set up, you MUST EXECUTE the merge to a new document.
Then with the document created by executing that merge as active document,
you then run the macro. When you do that, it will display a File>Open
dialog in which you must select DOCUMENT A. After you do that, the rest of
the code in the macro will run.

--
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, originally posted via msnews.microsoft.com
 

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