Hi Derek,

To have both a message and an attachment, a different approach is needed. It's explained in detail here: http://word.mvps.org/faqs/mailmerge/...ttachments.htm
The instructions assume Outlook is at least installed on your system, which it usually is if you have Office installed (you don't have to be using it for email purposes, though).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for getting back to me again. I've had a look at the link and as I've never used macros before, it all looks a bit complicated to me. I'm not sure if that is going to do the job for me either.

We would be sending out 4-500 personalised invoices and it looks like I would need to have each invoice saved seperately so that I could attach it to the email. I see that it would pull the email address' from the data file but I presume I would then need to list all of the saved invoices in the data file next to the corresponding email address so that it could pull the info for the attachment from there?

Am I getting this right or would there be some way of attaching the individual pages of the original merged document that created the invoices?

It is till you get used to it.

I think that's correct, but there are other macros about the web for splitting mailmerge documents into individual files, so that part can be done quite speedily too. See, for example:
http://www.gmayor.com/individual_merge_letters.htm

With a little bit of extra coding, you could have one process execute and, when it's complete, automatically start the next one. That part would require only four lines of code.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the lastest info. I had a look at the link and there is an add-on there that allows you split the mail merge and save the individual files as predefined names if you have them set up as a data field which I have tried out and it works. This way when I create the Directory I should be able to use that field again to import the data.

I haven't tried it all from start to finish to see if I have the finished article as I ran out of time at work.

I'll run through it all on Monday and let you know how I get on.

Thanks again