View Single Post
Old 23-11-2005, 06:09 PM   #2 (permalink)
us-media
www.us-media.co.uk
 
Join Date: Mar 2004
Location: West Midlands
Posts: 13
Do this all the time

Easiest and quickest way, is to use Access to launch a Word template (.dot) containing a Word macro that will update one or more Word bookmarks (or form fields for that matter) with data from a mail merge source (either a database table or from a temporary text file (written by the database to say, the root of the c:\ drive)

Other way of doing it is to use DAO to connect to the database directly from Word

In Word 2000 hit ALT+F11 > Tools > References and make sure DAO... is ticked

Rob.
__________________
Regards,
Us Media

Visit our website http://www.us-media.co.uk
us-media is offline   Reply With Quote