Discussion Locked

Merging 1 Word doc with 2 Access tables

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have a little invoicing program that saves its data in 2 Access tables (Clients & Invoice details). Is it possible to make Word to merge an Invoice Template (1 page) taking the client data from one table and the invoice details from anothertable.

Thanks

5 replies

by peyison

One way to do this is to create a Query in your Access database that links the two tables, and then use the new Query as the source for your mail merge in Word.

Let me know if you need help creating the Query.

Hope this helps

by sgon

Well the problem is that I need to merge in one document (Invoice), data from 1 record from the Clients table and many records from the Invoice Details table (One record per product ordered).

Thanks for your time.

by yatst

Go to the mail merge wizard. For data source use MS Query. This sill allow you to create a query from the two tables for filling in your template.

This discussion is closed to new replies.