Mail Merge to E-mail with Attachments - NEED HELP Please.... Abhishek Dadu 12/28/2008 11:37:01 AM Hello, I have tried to follow the steps mentioned by you, in the link below, verbattim: http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm But, still I am quite UNABLE to send the "mail merge with attachment" successfully (tried both with 1 attachment & 2 attachment) . I am not getting any error BUT the VB script continues to show the output as: "0 messages sent" & there is no activity in my Outlook 2007 mailbox. Please Note: [I have tried the basic mail merge without the attachment with MS Word 2007, and it works just fine with Outlook 2007.] I have a requirement to send 2 attachments to my recepients. Have done the following: 1) Created the VB scriot and assigned it as a macro in Word 2007 2) Downloaded and installed the utility - Express Click Yes 1.2 3) Used the same data source for email addresses, attachments and other contact details. 4) Attached is the Word 07 document created - with the MACRO along with it. 5) Matched the diredtory path of the attachment, and tested it too to ensure its correct. Will really appreciate any help extended. Many Thanks, Abhishek.

Re: Mail Merge to E-mail with Attachments - NEED HELP Please.... "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/28/2008 12:55:05 PM When you perform the step that merges to a new document, how many Word sections does the new document have? Have you definitely selected the new document before running the macro that sends the new e-mails? -- Peter Jamieson http://tips.pjmsn.me.uk "Abhishek Dadu" <Abhishek Dadu[ at ]discussions.microsoft.com> wrote in message news:8B3B0030-C62E-4773-884D-21D8F87969EF[ at ]microsoft.com... [Quoted Text] > Hello, > > I have tried to follow the steps mentioned by you, in the link below, > verbattim: > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm > > But, still I am quite UNABLE to send the "mail merge with attachment" > successfully (tried both with 1 attachment & 2 attachment) . I am not > getting any error BUT the VB script continues to show the output as: "0 > messages sent" & there is no activity in my Outlook 2007 mailbox. > Please Note: [I have tried the basic mail merge without the attachment > with > MS Word 2007, and it works just fine with Outlook 2007.] > > I have a requirement to send 2 attachments to my recepients. Have done the > following: > > 1) Created the VB scriot and assigned it as a macro in Word 2007 > 2) Downloaded and installed the utility - Express Click Yes 1.2 > 3) Used the same data source for email addresses, attachments and other > contact details. > 4) Attached is the Word 07 document created - with the MACRO along with > it. > 5) Matched the diredtory path of the attachment, and tested it too to > ensure > its correct. > > Will really appreciate any help extended. > > Many Thanks, > Abhishek.