Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automating a mail merge
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01193945
Message ID:
01194339
Views:
25
Thanks for your reply. I don't think this article is saying that OpenDataSource is necessary, I think it is just saying that it may be getting used incorrectly and thereby causes a similar issue (select data source vs. a dialog asking permission to query the data source, which is what I was getting). I now use cusWord without the OpenDataSource call when the version is 10 or 11 with no problem (I avoid the dialog that asks permission to run the query and the documents print just fine).

I would like to hear about the bookmark technique, but it is not urgent, so take your time.

>Actually, it is still necessary. What you are describing here is an entirely different issue
> and is explained in the KB:
>
>PSS ID Number: 279462
>
>Article Last Modified on 10/29/2003
>
>
>--------------------------------------------------------------------------------
>The information in this article applies to:
>
>Microsoft Word 2002
>
>--------------------------------------------------------------------------------
>
>This article was previously published under Q279462
>
>SYMPTOMS
>When you call the OpenDataSource method while automating Word 2002, the Select Data Source dialog box appears. If Word is not visible, it may appear to have stopped responding.
>
>CAUSE
>When you call OpenDataSource, the Select Data Source dialog box typically appears if you have not provided enough information to connect to the data source. By default, Word 2002 attempts to connect to the data source by using the Office DataSource Object (ODSO). ODSO requires the complete path and file name to either a database or an Office DataSource Connection (.odc) file for the Name argument. If you provide the Name argument with an empty string, the Select Data Source dialog box appears.
>
>RESOLUTION
>To avoid the dialog box to select a data source, do one of the following:
>Supply the Name argument of OpenDataSource with the full path to a file-based database, such as a Microsoft Access database, a Microsoft Excel workbook, or a text file.
>Supply the Name argument of OpenDataSource with the full path to an .odc file.
>Supply the SubType argument of OpenDataSource with wdMergeSubTypeWord2000 to emulate Word 2000 behavior.
>
>It seems you're implying that the bookmarking technique is a replacement for the mailmerge. I wouldn't think of bookmarks for mailmerges, but I'm not doing a ton of mailmerging, so I wouldn't call myself an expert on this. Maybe you could fill me in on this technique in more detail?
>
>If you can wait untilk either later in the day or tomorrow. I am up to my eyeballs right now and the explanation could get lengthy < s >.
>
>And no, I am not saying that it is a substitute for mailmerge. It is just a different technique that works better in some situations.
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform