>With much help from UT participants (thanks guys) I have developed an approach to VFP-Word automation which works fine. (I use a one row FoxPro table as a standard data source to the merge document and fill the table with data just before the merge.)
>
>I have Office 97 Professional Edition installed on my computer. In the install sequence there is a place to check Data Access options and I picked dBase/FoxPro tables among others.
>
>But when I went to install the system on my clients comptuter, mail merge would not recognize a DBF table as a data source. I tried reinstalling her standalone Word program and I couldn't find anything about Data Access options. I also tried installing Office 97 Small Business Edition with similar results. Finally I installed my copy of Office 97 Professional which works.
>
>So is there anyway to access a FoxPro table as a mail merge data source without telling the client they have to buy Office 97 Prof. Ed. for every workstation?
>
>Peter Robinson
Have you tried COPY TO My2xTable TYPE FOX2X and then attaching to that table?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer