Mail Merge - Two Data Sources

  Sir Radfordin 17:21 27 Aug 2003

I've created a database that has several tables. One is Orders and another is Order lines. There are several other relationships.

I've set up a form for the orders with a subform for order details. There is then a button that runs VBA code to output details to two excel spreadsheets. The first has Order information (name/address/orderid) the other has Order details infomation (product/orderid).

What I then want to do is mail merge this into a Word document. However when I try it wants to create a new document for each orderline and no use the same Order (name/address) for each orderline.

Hopefully that is making sense!

How can I set Word up so I can merge from two excel files? Or is there a better way to do this?


  Sir Radfordin 19:14 27 Aug 2003

Come on it can't be 'that' hard...can it?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)