Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: solomon sackey
  Where is solomon sackey?
 texas
 Texas - United States
 solomon sackey
 Tags
Subject: RE: data merding vfp & ms. word processor
Thread ID: 155287 Message ID: 155290 # Views: 3 # Ratings: 0
Version: Visual FoxPro 6 Category: Reports and Printers
Date: Saturday, December 29, 2007 6:19:12 AM         
   


> Dear Expert,
>
> I;m generating a number of reports with various formats in ms word processor.
> The data is coming from vfp.
>
> How do i implement this combination using this feature of merger in an executable generated application, taking into cognisance the word processor part?
>
> Is it possible to use say acrobat to do same?
>
> Pls provide me with a step by step approach.
>
> Thanks
>
> Happy ne year to all foxite members.

Solomon,

I believe what you are looking for is something called "Mail Merge." Begin by looking this up in Word help. Basically, you can create a DSN to your VFP tables (and in VFP 6, you could even use the ODBC drivers.) Once you have your data source, you can then add merge fields to your document and then run the mail merge.

You can automate this through VFP if you wish to, but I have never found the need. My Mail Merge users know how to create a mail merge document and can do so as required. I don't have to program it. If you do wish to automate the process, I recommend that you read Marcia's excellent article on Office Automation here:

http://www.tightlinecomputers.com/Downloads.htm

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

data merding vfp & ms. word processor Posted by solomon sackey @ 12/29/2007 3:17:13 AM
RE: data merding vfp & ms. word processor Posted by Ken Murphy @ 12/29/2007 6:19:12 AM
RE: data merding vfp & ms. word processor Posted by Boudewijn Lutgerink @ 1/2/2008 9:35:14 AM