Quote:
Originally Posted by DerekScambler
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.
|
It is till you get used to it.
Quote:
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?
|
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.