Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 627
  • Last Modified:

Clarify file types

TEMPLATE_FILENAME points to a file that already exists and has been set up as a mail merge document, correct? What kind of file is FILE_NAME and what is contained in that file?
//This is the code previously posted
   //Open Microsoft Word
            Microsoft.Office.Interop.Word.ApplicationClass wordapp = new Microsoft.Office.Interop.Word.ApplicationClass();
            wordapp.Visible = false;
 
            object filename = TEMPLATE_FILENAME;
            object objTrue = true;
            object objFalse = false;
            object objMiss = Type.Missing;
            Microsoft.Office.Interop.Word.Document myMergeDocument;
 
            //Open the Template file
            myMergeDocument = wordapp.Documents.Open(ref filename, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss, ref objMiss);
            myMergeDocument.Select();
 
            //Open the data source
            object format = Microsoft.Office.Interop.Word.WdOpenFormat.wdOpenFormatText;
            myMergeDocument.MailMerge.OpenDataSource(FILE_NAME, ref format, ref objFalse, ref objMiss, ref objTrue, ref objFalse,ref objMiss,ref objMiss,ref objMiss,ref objMiss,ref objMiss,ref objMiss,ref objMiss,ref objMiss,ref objMiss,ref objMiss);
            
            //Perform the Mail Merge!!!
 
            if (DIRECT_PRINT)
                myMergeDocument.MailMerge.Destination = Microsoft.Office.Interop.Word.WdMailMergeDestination.wdSendToPrinter;
            else
                myMergeDocument.MailMerge.Destination = Microsoft.Office.Interop.Word.WdMailMergeDestination.wdSendToNewDocument;
 
            myMergeDocument.MailMerge.SuppressBlankLines = true;
            myMergeDocument.MailMerge.DataSource.FirstRecord = (int)Microsoft.Office.Interop.Word.WdMailMergeDefaultRecord.wdDefaultFirstRecord;
            myMergeDocument.MailMerge.DataSource.LastRecord = (int)Microsoft.Office.Interop.Word.WdMailMergeDefaultRecord.wdDefaultLastRecord;
            myMergeDocument.MailMerge.Execute(ref objFalse);
 
            
            
            //Close the template document.
            myMergeDocument.Close();
 
            //Print the derived document.
                       
            wordapp.Visible = true;
            wordapp.ShowMe();
            return;

Open in new window

0
NBHmember
Asked:
NBHmember
1 Solution
 
WeiXiCommented:
> TEMPLATE_FILENAME points to a file that already exists and has been set up
> as a mail merge document, correct?

Yes, correct.

> What kind of file is FILE_NAME and what is contained in that file?

That file contains the data source for the mail merge. If, for example, you are creating standard circular letters, it would contain the names and addresses of the recipients.

The format of that file can vary, MS-Word supports quite a range. Popular examples include MS-Excel, MS-Access, or CSV. I guess XML should be supported as well, but I am not sure about it.

This is the file you open from MS-Word, when you click on the "open datasource" icon in the "mail merge" tool-bar.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now