Hi Terry,
Rather than manually connecting the data source, could they use something like:
ActiveDocument.MailMerge.DataSource.Name = "C:\MyFolder\MySpreadsheet.xls"
from the VFP side after handing it the letter name and before merging?
(not sure of the exact syntax of the command, but that's close)
>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
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?