View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andrea Jones
 
Posts: n/a
Default Embed tables from Access dynamically into Word mail merge letters?

Have a look at http://www.allaboutoffice.co.uk/worddatabase.htm , you can use
a database field to create your table of related items (pick any account
field to start with and change it later to link to your MERGEFIELD). If you
look at the bottom of the page I have directed you to there are instructions
about how to link the table created using the database field to records in
your mailmerge data source.

Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com


"Thomas Staudte" wrote:

Hi NG,

I have two Access tables, one containing customer names, the other one items
each customer has purchased. The tables are linked properly with an ID. The
task is now that a mail merge letters shall be sent to each customer that
includes a table of all item the customer has purchased.

Mail merge letters, Access queries, etc. are no problem, but how do I create
such a linked table in a Word mail merge letter? Is that possible at all?

Thank you for any hints.

Thomas Staudte