>>Out of curiosity, when the connection is being made to the datasource, that is being done thru an ODBC type connection setup in the ODBC Data source manager right? If it is what is the path of that data source set to? Is the path different then the path that is being set? I guess what I am trying to ask is the mail merge looking at the original datasource of the ODBC connect?
>>
>>Scott
>>
>>>I have a client who is now using Word 2003
>>>to run VFP automated Mail Merges. They manually
>>>connect the Mail Merge Data Source to the Word DOC and
>>>save that connection. Next, they use VFP to call up
>>>Word 2003, hand it the letter name, and tell Word to merge.
>>>They are finding that Word 2003 forgets its Data Source
>>>(an Excel Spreadsheet) and they have to go back into the
>>>letter and reconnect to the XLS.
>>>
>>>How can they fix this?
>>>Thanks!
>>>Terry
>
>Hi Scott,
> Here is the method we use to connect MS Word to its
>Data Source: (We do not use the ODBC type connection.)
>
> (b.) Open MS WORD
> (c.) Open one of the "DOC" files .
> (Example "DOC" file: FORM_LETTER1A.DOC)
> A message will appear saying:
> "This MS Word DOC does not have a DATA SOURCE..."
> Just click on the OK button and continue.
> (d.) If you have MS Word 97 or 2000:
> Click on TOOLS, MAIL MERGE*, GET DATA, OPEN DATA SOURCE.
> (*Note, you may have to click OPTIONS after MAIL MERGE
> in MS Word 2000).
> Click on the down-arrow(drop-box) of "FILES OF TYPE"
> and select "MS EXCEL SPREADSHEET" "*.XLS".
> Click on the down-arrow (drop-box) of "LOOK IN" and
> path your way to the x:\NTAS folder.
> Double-click on the matching "XLS" file (in this case
> it is FORM_LETTER1A.XLS).
> Click OK on "ENTIRE SPREADSHEET".
> Click the "CLOSE" button on the "MAIL MERGE HELPER"
> window.
> (e.) If you have MS Word 2002 (Office XP):
> Click on TOOLS, LETTERS AND MAILINGS, MAIL MERGE WIZARD.
> Under "USE AN EXISTING LIST", click "BROWSE".
> Click on the down-arrow (drop-box) of "LOOK IN" and
> path your way to the x:\NTAS folder.
> Double-click on the matching "XLS" file (in this case it
> is FORM_LETTER1A.XLS). Click the "OK" button on the
> "SELECT TABLE" window. Click the "OK" button on the
> "MAIL MERGE RECIPIENTS" window.
> (f.) Click on "FILE" and "SAVE" to save the changes to this
> "DOC" file.


Thanks for the info.

Scott