Dear All,

Good Day,

Is anyone know how to automate Microsoft Word to send out Mail Merge using Macro to send email to Microsoft Outlook Contact. The major problem is i have a few Invoices to be send out to the same recipient in one Email. Can anyone help me ??

You may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple

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

Hi Macropod,

Thanks a lot for the link. It work great.