Thomas

I forgot to say, press CTRL+F9 to get the curly brackets for the Mergefield
field code. If you press ALT+F9 you'll see your merge field codes and can
copy the relevant one exactly into the select statement. Don't forget to
leave the apostrophes around the field code in the WHERE part or it won't
work.

Andrea Jones
www.allaboutoffice.co.uk

"Thomas Staudte" wrote:

Hi Andrea and Doug,

thanks a lot for the pointer, I'm pretty sure I'll get this to work from
here!

Best regards and greetings from Germany

Thomas Staudte


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"

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