View Single Post
 
Old 01-23-2012, 05:43 AM
MartinD_UK MartinD_UK is offline Windows XP Office 2007
Novice
 
Join Date: Jan 2012
Posts: 6
MartinD_UK is on a distinguished road
Default

Hi Paul

Yes, the process does indeed produce e-mails with attachments - as I stated in my second post, above.

What it does not do is produce emails with *merged* attachments.

If I execute to a new document a mail merge, using as the merge document the document I want to attach, and then run the macro (using the directory file I've created as described under 'Setup' in the information to which you linked); it uses the text of the document as the text of the body of the email - which is not what I want. (As described in my third post, above.)

If, in the alternative, I execute to a new document a mail merge, using as a merge document the text I want to put in the body of the email, and then run the macro (again, using the directory file I've created as described under 'Setup'); it does exactly what I want in the body of the email, and it attaches the document I want to attach - but it does not merge that document: it attaches it as a raw mail merge document with all the field codes etc in it. This is also not what I want. (As described in my second post, above.)

What I actually want, as I stated in my first, second and third posts above, and which I might as well repeat now, is to send a *merged* Word document *as an attachment* to multiple e-mail addresses, *and, in addition to the **merged** attachment,* to put some text in the body of the e-mail.

Please can I ask that you read my post - carefully - before posting another reply.

If you humour me and make a working assumption (just for a few minutes) that I'm not stupid, then when you read what I've written you may find that you've actually slightly missed the exact point of what I'm asking.

If it would help, is there a facility on this forum for uploading example files, to illustrate what I mean?

Thank you,

Martin
Reply With Quote