VFP / Word publipostage

[JPG77]

Hi,
Does somebody know how to change, from a VFP aplication, the name of the file (.DBF or .TXT) linked to a Word document. It seems that this name is "somewhere" in the .DOC

Do you think the solution might be with low level instruction for making the changes ?

Thanks by advance
Jean-Paul

 

[Mike Gagnon]

JPG77

But can you explain this "the name of the file (.DBF or .TXT) linked to a Word document."? Do you mean to change the name of the .dbf file that is asociated with a Word document when you do a mail merge?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[JPG77]

Yes Mike.
We have a "formatted" ie MyLetter.DOT (Word) with text and fields that receive informations from VFP file (ie MyData.DBF)
After the mail merge, Word save the name "MyData.dbf" and the path into the .DOT for an ulterior use.
Now, in our VFP application, we execute a SELECT SQL and put the answers into a .DBF with a RAND name for example _1234567.DBF (With the same structure as MyData.DBF).

Finally, we want to open MyLetter.Dot and merge automaticaly with _1234567 (without change manually the data sources) in order to create a specific letter.

(All the data are on a server, and 2 or more users are able to execute these operations simultaneous. That's why we have to put the result of the SQL in different filename and not in the "MyData.DBF&quot

So the problem is : Open a .dot and merge it automaticcaly with a .DBF that have a different file name than the initial one but the same structure.

And excuse me for my poor english ...
Thanks for your first prompt answer.
Jean-Paul

 

[JPG77]

For Mike,

I resolve my problem with the VFP mailmerge class.
Regards,
JpG