Mail Merge to Email with Attachments plus varied body text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sjSQW - 18 Nov 2006 11:11 GMT

I have managed successfully to use Doug Robbins' instructions (Mail Merge to
E-mail with Attachments) for adding attachments to an email merge. However,
unless I am missing something, what is does not allow me to do is to
personalise the content of the email message in the way that Word's merge to
email function does.

i.e. For each email in a mail merge, I want to be able to choose the name of
the person to whom the email is addressed by drawing on an address database,
but I also want to send a personalised attachment for each recipient.

Is it possible to combine the functionality of both Doug Robbins' VB script
and Word's merge to email function?

Reply to this Message

Doug Robbins - Word MVP - 18 Nov 2006 15:53 GMT

It you want to create personalized attachments, see the "Individual Merge
Letters" item on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.. .

However, if it is just the content of the email message (with which the
attachments are sent) that you want to personalise, the method in the
article that you have seen does allow you to do that. It sounds like you
may have missed the step to execute the merge to a new document and then run
the macro when that document is active document.

-- .
Hope this helps.

This response prepared using a pen on a Wacom Graphire 4 tablet

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 managed successfully to use Doug Robbins' instructions (Mail Merge
>to
[quoted text clipped - 14 lines]
> script
> and Word's merge to email function?

Reply to this Message

sjSQW - 20 Nov 2006 14:34 GMT

Doug,

First, thanks for all your help with this topic - not only to me.
You're right - I had missed a step in your instructions and I have got it to
work now. The key is, as you say, to merge to a new document. But I found
that the main document type needs to be a letter in order to work (I had been
using an email type before).

And thanks for the pointer on the add-in to merge letters to separate files.
I will definitely use that one.

With kind regards,

Stuart

> It you want to create personalized attachments, see the "Individual Merge
> Letters" item on fellow MVP Graham Mayor's website at:
[quoted text clipped - 40 lines]
> > script
> > and Word's merge to email function?

Reply to this Message