Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
More on Word Automation
Message
From
03/03/2000 10:29:41
John White
Micro-Oriented Software Techniques, Inc.
Phoenix, Arizona, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
More on Word Automation
Miscellaneous
Thread ID:
00341254
Message ID:
00341254
Views:
49
Hi,

I've downloaded the various files and samples from the library. I have an automation going with Word 97 and Word 2000. There are a few things I'd like to find out about though...

Here's my situation. I am creating mail-merged personalized letters *with* signatures. There are numerous letters and numerous representatives, each with their own signature. I am storing the word document for each letter in a table identified by a "Letter Code" in a Memo (binary) field and a General field (more on this later). I am storing the signatures (.TIF files) in a table identified by a "Requester Code" also in a Memo and General field.

As people are working on the phone, they type in name & address information, select a letter from a combo and save it. When the batch printing process begins, it sorts the letters by Letter Code and Requester Code. For each distinct Letter/Requester combination, I extract the Word document to LETTER.DOC and the signature to LETTER.TIF. I then do the following....

loWord.Documents.Open(Sys(5)+Curdir()+"LETTER.DOC")
loWord.ActiveDocument.MailMerge.Execute
loWord.ActiveDocument.Close(0)

Ok, on to the questions {g}

1) How do I set the destination of the mailmerge (to ensure its always "Printer")
2) How do I suppress the printer confirmation... they do not want to hit "Ok" a couple hundred times
3) How do I display/edit the Word document I have stored in the Letters table?
4) How do I display/edit the signature graphic (.TIF format) in the Requester table?

5) Is there an easier way to do this? LOL

Thanks in advance,
...John White [MOST]
John White [MOST]
Next
Reply
Map
View

Click here to load this message in the networking platform