>>>>Hi,
>>>>
>>>>The file on URL https://www.levelextreme.com/Home/ShowHeader?Activator=23&ID=7734 is mutulated, anybody to upload the procedure here? I need to make instantly a working MailMerge with MSWord, MSExcel with VFPdata
>>>>Thanks
>>>>Koen
>>>
>>>Use OLE/ActiveX Automation. Go into Word and Excel and begin recording a macro, perform the replace on the $NAME, $ADDRESS, $SALUTATION, or whatever other fields you have in your biolerplate template. Then take that code and put it into VFP and automate it.
>>>
>>>Doesn't work instantly, but 30 minutes will get you going.
>>Rick,
>>Thanks, but 30 minutes is a showstopper for me.
>>I will dive into the procedures made by Vilhelm.
>>Stay healthy,
>>Koen
>
>If you can't get it working the way you want I'll code it for you. Let me know.
>
>Take care.
Rick,
That is a generous offer. Meanwhile I do think I misinterpreted your 30 minutes, I do now believe the 30 minutes are for coding the end result and not, as I first understood, the procedure will take 30 minutes to complete.
If Cetin's class not available, I will first try to do my thing with one of Vilhelm's classes.
It is not only the import of an Excel file into VFP it is also to find, for me, the best Emailing portal, I used to work with VFPWinsock untill Google changed policy which made it impossible to mail with my Gmail account. There is a rather good working Emailprocedure in Foxypreviewer and with aid of some code from Dough Henning I believe I can finish the job.
In case I encounter unsolvable problems I will call on you.
Stay healthy,
Koen