It would really help Joe AverageUser if the article to which you made
reference gave an example of just where you would insert the { MERGEFIELD
Player } into

"SELECT Date, Player, Goals FROM C:\\Documents and Settings\\Allabout\\My
Documents\\Excel\\goals.xls WHERE ((Player = 'Henry')) OR ((Player =
'Nistelrooy')) ORDER BY Player, Date"

--
Regards.

Doug Robbins - Word MVP

"Andrea Jones" wrote in message
...
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