How do you mail merge data from linked tables in Access to Microsoft Word 2000?

Question

I can't figure out how to mail merge data from multiple tables in Access to Word. I have a database with 3 linked tables. My table relationships are Customers-Orders-Parts. When I merge
into Word I can only merge the Name and Address from the Customers table but not the corresponding parts from the linked tables. So what I end up with is a document with only the customers name and address but without their corresponding orders. So how do I merge data from the linked tables. For example if Joe Blow ordered Brake Pads and a Power Drill, I want my word document to include his name and his orders. But word only lets me merge data from one table. to get the corresponding orders in the document I have to enter them manually. This is time consuming and inefficient. I know there's got to be a better way. Is this possible to do in word, does anyone know a better way that it can be done. Any advice would be greatly appreciated.

Answer 1

Hi,



This can be done by creating a query in Microsoft Access that includes all of the required fields that you will need to display in the Microsoft Word mail merge document.



You will need to include all of the related tables in the query, and select the appropriate fields that contain the data. Once you have verified your results in the query data sheet, you can either:



Select the query in the database window and choose to "Merge It with Microsoft Office Word" from the Access menus



or



From Word, start the Mail Merge wizard, and as you work through to select Select Recipients, Browse for the database and you will then be presented with the list of tables/queries available to use in the merge.

Answer 2

Access Merge Tables

Answer 3

For a start Access and Word are not good for this. You would be better off with a serious database like mysql and using web based data control fthrough php.

Answer 4

Without knowing for sure, I suspect you need a query set up on the database that retrieve the values you want, then run it from Word.



Sorry I can't be more specific, but I'm guessing.

Answer 5

These are the locations in your Master document representing the exact position where merge data from your Access File will be placed. That is, Field Names in your Access File will be merged to create as many duplicate copies of the Master as number of records in the Access File, replacing those locations marked with <> for instance with content of matching field "Name" in your Access File, and so on for all such marked locations in the Word Master document. good luck