Mail Merge - Two Data Sources

  Sir Radfordin 17:21 27 Aug 03
Locked

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?

Thanks...

  Sir Radfordin 19:14 27 Aug 03

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

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…