OpenDataSource each time document is opened

[Brenda]

I have Word Mail Merge documents that are shared by 250 users, but they each
have their own data source. In my software they select a client, select a
letter, and then press a button to launch Word Mail Merge and the code
performs the merge to new document. It use to be that the datasource was
always at c:\rt_lettr.dbf - but that is no longer an option. So the data
source has moved on existing documents, and the datasource path must now
include the user name. So I want each time that the document is opened to
point to the current datasource to use.

FYI - This is an attempt at a work around on a problem stated in a previous
post about not having the ability to use the Open Data Sources.

 

[Doug Robbins - Word MVP]

You should be able to use an auto-open macro in the template from which the
mail merge main document is created that will determine the path the the
datasource and attach it to the document.

See the article "How to get the username of the current user" at:

http://www.word.mvps.org/FAQs/MacrosVBA/GetCurUserName.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP