Q: Word mail merge from Visual FoxPro

[Bob Morris]

I'm doing a migration from FoxPro DOS to Visual FoxPro
for a client. There are thousands of documents in the
system which I've converted to Word docs from FoxPro
report form format.

We want to access these Word docs via FoxPro and do a
mailmerge.

My question:

How do I call a Word mail merge document from Visual
FoxPro, passing it the data I want it to print?

 

[Word Heretic]

G'day "Bob Morris" <[email protected]>,

link to word libs, establish a word app & document object, use its
child methods

I'm doing a migration from FoxPro DOS to Visual FoxPro
for a client. There are thousands of documents in the
system which I've converted to Word docs from FoxPro
report form format.

We want to access these Word docs via FoxPro and do a
mailmerge.

My question:

How do I call a Word mail merge document from Visual
FoxPro, passing it the data I want it to print?

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

Replies offlist may require payment.

 

[Cindy M -WordMVP-]

Hi Bob,

Basically, you start by recording a macro in the Word UI,
performing the actions you need. Then you take that result
and check out the Word VBA Help for the information on the
objects, their properties and methods. You then "translate"
this into VFP-speak. You'll find any number of VFP MVPs in
a VFP newsgroup that have some experience with this if
you're new to automating an Office application from the VFP
interface.

Also, Tamar Granor wrote an excellent book on automating
Office applications. I recommend it to ANY programmer who
needs to automate an Office application with which he is
not familiar. She really researched the object models. It's
published by Hentzenwerke Publishing.

I'm doing a migration from FoxPro DOS to Visual FoxPro
for a client. There are thousands of documents in the
system which I've converted to Word docs from FoxPro
report form format.

We want to access these Word docs via FoxPro and do a
mailmerge.

My question:

How do I call a Word mail merge document from Visual
FoxPro, passing it the data I want it to print?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail