Kbase P99176: Starting the MailMerge using 4GL automation objects fails to locate attached data source documents
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/20/2009 |
|
Status: Verified
SYMPTOM(s):
Problems starting the mail merge using Progress 4GL automation objects
Opening the main MailMerge document from the Windows icon displays the prompt
Opening this will run the following SQL command:
SELECT * FROM your datasource
Data from your database will be placed in the document. Do you want to continue?
Note If you click Yes, the mail merge main document opens with the data source attached.
If you click No, the mail merge main document opens without the data source attached.
FACT(s) (Environment):
Microsoft Office Word being used to create main MailMerge document
Using Microsoft Office Word 2003 with the Progress 4GL automation objects
DataSource document and HeaderSource documents referenced in the main MailMerge document
Progress 9.x
OpenEdge 10.x
CAUSE:
This is a Microsoft Office issue known in MS Word 2002 SP3 and MS Word 2003
FIX:
When Microsoft Word is being automated and is presented with a document containing a link to a mailmerge data source, instead of prompting the user with the SQL security question (which you see after double click on the MS Word document) when displayalerts is set to ?none? (the default state) it silently answers ?No? to this question.
More information on this functionality including a way to revert to the previous functionality via a system registry change can be found in the Microsoft KnowledgeBase article:- http://support.microsoft.com/default.aspx?scid=kb;en-us;825765