query on mail merge

[Tharabai]

Hello... I need to send the details as an attachment (excel file) using mail merge. if so, please let me know how to incorporate this pls...

Can this be done as I have never used the mail merge with attachment.

[gmayor]

Word does not provide the facility out of the box to merge as attachments. You can do it with VBA, but it is quite complex, and to save re-inventing the wheel, take a look at http://www.gmayor.com/ManyToOne.htm In one to one mode the add-in will enable mail merge with the document as an attachment (in document or PDF format), or a personalised e-mail with a common attachment, or attachment(s) listed in the data source, or a combination of those.

Note that the process is not 'mail merge' and requires the data to be in an Excel worksheet.

The add-in, as the web page address implies, will also do many to one merges, with all these options