Mail Merge With Attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale - 12 May 2008 21:30 GMT

I have read the many posts on the site about this but I am having trouble
making it work. I can get it to send the e-mail but it does not attach the
documents. I run the macro after I have merged the e-mail to a new document
and I am prompted for the directory document but it still doesn't work. any
ideas as to why?

thanks!

Reply to this Message

Doug Robbins - Word MVP - 13 May 2008 06:18 GMT

In what way doesn't it work? Are the messages sent but without the
attachments? or is nothing sent at all?

Note that the path\filenames for the attachments in the directory document
must match exactly the actual path and file name of the file that is to be
attached. Just one space more or less 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

>I have read the many posts on the site about this but I am having trouble
> making it work. I can get it to send the e-mail but it does not attach
[quoted text clipped - 6 lines]
>
> thanks!

Reply to this Message

Dale - 13 May 2008 16:31 GMT

The e-mail is sent but the attachment is not there, do I need to hyperlink
the attachments also or? I know the paths themselves are correct......
I'm bringing the path in from an excel data source, could it be a formatting
issue?

> In what way doesn't it work? Are the messages sent but without the
> attachments? or is nothing sent at all?
[quoted text clipped - 14 lines]
> >
> > thanks!

Reply to this Message

Doug Robbins - Word MVP - 13 May 2008 20:28 GMT

If the attachments are not there, it is almost certainly because the
path/file name in the directory type mail merge (and hence in the data
source) is not 100.0000000000% correct. 99.99999999999% will not do.

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

> The e-mail is sent but the attachment is not there, do I need to hyperlink
> the attachments also or? I know the paths themselves are correct......
[quoted text clipped - 23 lines]
>> >
>> > thanks!

Reply to this Message