Thanks, I have seen some things on writing to the custom properties of the word doc, I haven't really had much success with adapting any of the samples, though I have not been able to spend the time needed these past few weeks on getting this right. Ideally I want to have several options once a user has completed basic vendor/purchase data for them to be able to open up a purchase or contract form with that basic data completed. I'm almost leaning towards converting the word docs to access forms, I converted one and it works pretty well. Are you saying you want the data source to be automatically linked when a new user/system opens one of the merge templates? I don't think I had a good understanding when I first replied. Is your mail merge doc connected directly to the access database or via ODBC? Here is a fascinating discussion of ODBC/dsn_less connections, with sample database and many good links including the 2nd below: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=402012&page =&view=&sb=5&o=&fpart=all&vc=1 http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForMySQL We also purchased several licenses and are testing ActiveDocs ( http://www.keylogix.com/), it has a data manager that handles the data sources. They also have a set up where you can put your forms on your web server or theirs and the users access the forms through the web. They are linked to your main data source, and the user goes through the queries to gather their data, then once they finish the merge, it opens a word document. hth, Cathy "Ray Blake" <ray@xxxxxxxxx> To: <mso@xxxxxxxxxxxxx> Sent by: mso-bounce@freelist cc: s.org 08/17/2004 01:33 AM Subject: [mso] Re: Access 2002: Relative Table Links? Please respond to mso ..... Thanks, Cathy, I'm running similar code now. There are 2 easy ways to move data from the form to the doc - one way for up to a dozen or so fields and another for more. First, for a small number of fields, I would use code behind the form to write values to custom properties of the Word doc, which would contain fields which disply the appropriate custom properties in the appropriate places. With more fields than that, I'd normally do a mail merge. I'd use a maketable query, using a criterion to restrict it to the current record selected on the form ('ID=frmMain!ID') and I'd have the DOT file linked to the output table of this query as the merge recordsource. And here is my issue, because I'd like to be able to automate that linking from the Word end. It's easy to do from the Access end a number of ways - I put the DOTs in the user's default template path, for example, and that's where my Access code looks for them. But I still find myslef manually linking the templates whenever I install a system with this architecture, and I'd like a reliable way of getting Word to do this itself, or getting Access to manipulate the DOTs appropriately. Ray ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 www.grbps.com ----------------------------------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ------------------------------------------------------------------------------------------------------- ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************