Mail Merge using WordHelper

raiees

Hi All,

I am using the WordHelper 'DotNet' for mail merging. when I open the merged file I get the following error.

Opening this Document will run the following SQL Command:
SELECT * FROm 'C/Users/A/***.HTM'
Data from your database will be placed in the document. Do you want to continue?

Once I say 'No', it open the document with all merged field.

I am not able to finalising the document.

I am using following code


WordApplication := WordApplication.ApplicationClass;
WordApplication.Visible(ShowDocument);

WordDocument := WordHelper.CallOpen(WordApplication,MainFileName,FALSE,FALSE);
WordDocument.MailMerge.MainDocumentType := 0;
ParamInt := 7; // 7 = HTML
WordHelper.CallMailMergeOpenDataSource(WordDocument,MergeFileName,ParamInt);

ParamInt := 9999998; // 9999998 = wdToggle
WordDocument.MailMerge.ViewMailMergeFieldCodes(ParamInt);
WordDocument.MailMerge.Destination := 0;
WordHelper.CallMailMergeExecute(WordDocument);

WordHelper.CallSaveAs(WordDocument,NewMainFileName);

WordHelper.CallClose(WordDocument,true);

CLEAR(WordMergefile);
CLEAR(WordDocument);
WordHelper.CallQuit(WordApplication,false);
CLEAR(WordApplication);


DeleteFile(MergeFileName);

Any idea what I am missing ?

Thanks
Raiees

NaCoder

Hi,

I have the same Problem. Know anybody how I can remove this VBA or save without this sql statement?

NaCoder

up... I found no solution with property to set it.