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?