mailmerge word with foxpro and file.txt

[immovfp]

Hi,

I don't know to do a mailmerge word
programmatically with fox.

I want to use a file .txt, the most is an cursor fox
and start the mailmerge in a prg fox.

thanks

olivier

 

[Mike Gagnon]

immovfp

Which part is giving you trouble? I see this as two issues. First you would most likely have to parse your textfile into a table. Second you would loop through the records and automate the mailmerge function in word.

Mike Gagnon

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

 

[immovfp]

Hi Mike,

Can i do the mailmerge with a cursor fox, like as
select *,mavar as myfield1 from mytable into cursor mycursor

And i want open my document word with the mailmerge.


If isn't possible ,can i use a file delimited in txt.

thanks Olivier

 

[DSummZZZ]

The easiest way is to create a .DBF file with the desired structure, similar to the text file. Then, issue:

IMPORT FROM MyFile.TXT SDF

You can then use a query to select the desired records for your merge.
As for the mail merge, use the keyword search and look for 'mail merge'. There are numerous posts on that subject.


-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm