mail merge letters

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

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.


On Sat, 27 Nov 2004 06:45:01 -0800, "The Deane Team"
wrote:

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

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" wrote:

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.


On Sat, 27 Nov 2004 06:45:01 -0800, "The Deane Team"
wrote:

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

On Sun, 28 Nov 2004 03:19:01 -0800, "The Deane Team"
wrote:

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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.