If I'm trying to merge a document from Access 2000 and Access 2000 only holds (x) amount of fields. But
the mail merge document requires more fields than access can hold in one table. How can I merge data needed from more than one table
in Word. If anyone has information that can point me into the right direction let me know.thanks JonathanMSN Photos is the easiest
way to share and print your photos: Click Here

Query the data from the tables as a join for a recordset and retrieve it
with getrows(). This allows you to build all the data into the one recordset
and retrieve the fieldName/value pairs from an array for each row.

tom mallard
seattle

-----Original Message-----
From: Jonathan Marshall [mailto:jdmarsh2g@h...]
Sent: Thursday, September 19, 2002 10:00 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Mail Merge


If I'm trying to merge a document from Access 2000 and Access 2000 only
holds (x) amount of fields. But the mail merge document requires more fields
than access can hold in one table. How can I merge data needed from more
than one table in Word. If anyone has information that can point me into the
right direction let me know.thanks JonathanMSN Photos is the easiest way to
share and print your photos: Click Here


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20