Mail Merge to Email with Attachments. Help with D. Robbins' artic

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

K. Walker - 28 Jun 2007 19:56 GMT

I have reviewed the different responses to the issue of including attachments
in a mail merge and have tried the steps in Doug Robbins’ article. I never
get the table mentioned in the article. These are the steps I’ve taken:

1. In VBA, I chose Tools > References... Then I clicked Microsoft Outlook
12.0 Object Library. I went back to make sure there was still a check mark
and of course there was.

2. Then I started my merge document and choose "Directory" as the type. I
continued creating the merge document as usual and never saw the table, even
after merging to the directory document.

If I understand correctly I don't run the Macro until after step two. I
never get to this step because I never get the table. What am I doing wrong?
I've tried it with Office 2002 and 2007.

Reply to this Message

Peter Jamieson - 29 Jun 2007 06:53 GMT

> 2. Then I started my merge document and choose "Directory" as the type. I
> continued creating the merge document as usual and never saw the table,
> even
> after merging to the directory document.

Suppose you want the same attachment for each merge. Then in your mail merge
main document in the "Setup" phase, you need to create a one-row, two column
table (i.e. so you have two cells).

In the first cell, put the mergefield that gets the e-mail address from the
data source.

In the second cell, put the pathname of the attachment.

Don't put anything else in the mail merge main document (no extra paragraph
marks before or after the table).

Do the merge, and you should end up with a table.

Your case may be more complicated if you have variable attachments or more
attachments per merge, but that's the general idea.

Peter Jamieson

>I have reviewed the different responses to the issue of including
>attachments
[quoted text clipped - 16 lines]
> wrong?
> I've tried it with Office 2002 and 2007.

Reply to this Message

Doug Robbins - Word MVP - 29 Jun 2007 09:28 GMT

And another piece of advice, you must follow the instructions exactly if you
want to achieve the desired result. Also, the filepath\name(s) that you
either have in your data source or enter directly in the the Directory type
mail merge main document if it is a fixed attachment MUST be match exactly
that of the file(s) that you want to attach. Just one extra space will
prevent the file from being attached.

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

>> 2. Then I started my merge document and choose "Directory" as the type.
>> I
[quoted text clipped - 42 lines]
>> wrong?
>> I've tried it with Office 2002 and 2007.

Reply to this Message

Rate this thread: