Hi

I often use MS Word's Mail Merge feature for form letters etc. However, I was wondering if it could be used to produce invoices. The only challenge is how to get it to include multiple items in the Invoice Body. Does anyone know if this is possible? I have read through the Word Help etc. but have not come across any ideas about how to handle 1 to many relationships in mail merge.

I have used a technique where I embed special tags in the invoice body which I find and replace with the data. After I replace them I paste them back into the document so I can repeat the find and replace for each record. The only issue with this procedure is that users change the tags or misspell them when they edit the document and the process then fails. I thought if it was a standard mail merge I could simple create the data sources on the fly and have Word do the merging. In this way the user could use the standard MS Word Mail Merge wizard to insert the fields and thus avoid spelling errors etc.

Thanks,
Simon