Solved

Basic Word Mail Merge functionality with C#.NET  - given Data File and Merge Doc

Posted on 2008-06-09
4
1,512 Views
Last Modified: 2013-12-17
Hello Experts,

I'm working with MS Office 2003 and visual studio 2005

I have experience with C# .NET and web applications, but I have not yet worked with Microsoft Office .. . until now.  I'm trying to understand how to automate a mail merge and am looking for a little guidance.

I have a simple Windows Application with a button. Given a data source file and and merge document, I would like to perform a merge with the OnClick event.

My merge document is a *.doc.
My data source is a *.xls.


I am hoping there is a method that takes 2 arguments: one for data source file, one for merge document.  Does this exist?  I'm having trouble understanding the documentation that I have found.  It seems all the examples create a data source file from scratch and I'm not understanding the call that actually merges the data.

Can someone point me in the right direction?

Thanks.

0
Comment
Question by:soapygus
  • 2
  • 2
4 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 21747414
Mail Merge uses a document to hold the pattern for the result documents. It is quite  easy to set it up manually using the Mail merge wizard which is built in to the Word user interface (Tools/Letters and Mailings). This requires that the datasource be specified and then the merge fields be placed where needed. The merge fields point to data source fields by name. If the main document, as it is called, is saved, the datasource link is saved with it.

Programatically you can use the OpenDataSource method to link a particular data source to the document. Hopefully it will have the same field names as the datasource that document was designed for.

A document object has a Mailmerge Property which holds the Datasource object and has an Execute method to actually run the merge.

I don't use C#, but if you can understand VB, the Help in Word's VBA editor should be able to help you more.
0
 

Author Comment

by:soapygus
ID: 21750633
Thanks GrahamSkan,

I've got it working with one small problem.  My OnClick event is referencing the correct files (template.doc, and datafile.xls); however, when it executes the merge I get a prompt asking me to "Select Table." My xls only has one worksheet so the worksheet is selected and a checkbox is checked that indicate that the first row is my header row.

I click "Ok" and the merge executes perfectly.

I just need to figure out how to specify the header row is my first record in the XLS.

Here's the code I've been working with.
            // Create an instance of Word  and make it visible.
            wrdApp = new Word.Application();
            wrdApp.Visible = true;
            Word.Document myMergeDocument;

            string strFileName = "c:\\template.doc";
            string strDataFile = "c:\\datafile.xls";

            object filename = strFileName;
            object objTrue = true;
            object objFalse = false;
            object objMiss = Type.Missing;


            //Open merge document
            myMergeDocument = wrdApp.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 source = strDataFile;
            object format = Word.WdOpenFormat.wdOpenFormatAuto;
            myMergeDocument.MailMerge.OpenDataSource(strDataFile, 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 Merge
            myMergeDocument.MailMerge.Destination = Word.WdMailMergeDestination.wdSendToNewDocument;

           
            myMergeDocument.MailMerge.SuppressBlankLines = true;
            myMergeDocument.MailMerge.DataSource.FirstRecord = (int)Word.WdMailMergeDefaultRecord.wdDefaultFirstRecord;
            myMergeDocument.MailMerge.DataSource.LastRecord = (int)Word.WdMailMergeDefaultRecord.wdDefaultLastRecord;
            myMergeDocument.MailMerge.Execute(ref objFalse);
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 21753094
Try putting

"SELECT * FROM `Sheet1$`"

as the 13th parameter in the OpenDataSource statement
0
 

Author Closing Comment

by:soapygus
ID: 31465563
Thank you!
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now