Hello,

I have written following code for mail merge.Even though it is not
giving any errors,It is not updating the "final.rtf".Can you suggest me
what is wrong here.

      Word.Application wrdApp;

       Word.Document oDataDoc;

       Word.MailMerge wrdMailMerge;

       Object oMissing = System.Type.Missing;

       Object oFalse = false;

       Object oTrue = true;

       Object oName = Server.MapPath("Mail.doc"); //source file

       Object oFileName = Server.MapPath("Final.rtf"); //distination
file

       Object oFileFormat = Word.WdSaveFormat.wdFormatRTF;

       wrdApp = new Word.ApplicationClass();

       wrdApp.Visible = true;

       wrdApp.WindowState = Word.WdWindowState.wdWindowStateMaximize;

       oDataDoc = wrdApp.Documents.Add(ref oName, ref oFalse, ref
oMissing, ref oMissing);

       oDataDoc.Activate();

      wrdMailMerge = oDataDoc.MailMerge;

       //wrdMailMerge.HighlightMergeFields = false;

       //wrdMailMerge.ViewMailMergeFieldCodes = 0; //this is for
showing the data instead of fieldnames

      Object oConnection = "DSN=Test"; //The DSN connection name

       Object oQuery = "SELECT FirstName FROM MailMerge"; // The query
to get data from the DSN

       //Object oSubType = Word.WdMergeSubType.wdMergeSubTypeWord;

        wrdMailMerge.OpenDataSource("", ref oFileFormat, ref oMissing,
ref oMissing, ref oTrue,
           ref oMissing, ref oMissing, ref oMissing, ref oFalse,
           ref oMissing, ref oMissing, ref oConnection, ref oQuery,
ref oMissing);

       wrdMailMerge.SuppressBlankLines = true;

       // Save document

       oDataDoc.SaveAs(ref oFileName, ref oFileFormat, ref oMissing,
ref oMissing, ref oTrue, ref oMissing, ref oMissing, ref oMissing, ref
oMissing, ref oMissing, ref oMissing);

       oDataDoc.Saved = true;

       wrdMailMerge = null;

       oDataDoc = null;

       wrdApp = null;

Regards,
Jagan Mohan Varma Pinnmaraju