mail merge letters

[Guest]

Using Office/Access 2000, can one letter contain fields from 2 tables in the
same database?

 

[John Nurick]

Hi,

Mailmerge basically creates one letter from each record in the source
data. So if you can create a query that joins the two tables and returns
one record for each letter, it's simply a matter of using that query as
the data source for the merge document.

If you've got hierarchical data (e.g. an invoice with a variable number
of line items), mailmerge is less suitable.

 

[Guest]

Thank you for your help. I am very new to Data base creating so I will now
learn more about creating a query and how to use it as a data source. It is
like learning a nw language.

 

[John Nurick]

It is like learning a nw language.

In a sense it is - a language that involves not so much new words as a
new grammar.