C# Word 2003 Mailmerge by DSN

Introduction

Well most of u guys already know the basic stuff, so i go from the 'Start Word Application Class'. This code will start Word 2003, create a mailmerge document and will merge the data recieved from a DSN source to this document

The start

Create a Word template (.dot) file with mergefields like i did. Or use a .doc file, whatever you want. My mergefields are called 'bedrijfsnaam','adres' and so on. Its dutch so forget about the names :)

Now create the reference to Office Word 2003 v11.0 object. Now I have the code below to make things easyer.

using Word = Microsoft.Office.Interop.Word;

Now create a User-DSN with the name 'dsn_data'. Thats what i dit so you'll be able to find the name back in the code. This connection can be to any datasource you want.

The real thing

Now lets create the code for our application Create the definitions:

Word.Application wrdApp;

Word.Document oDataDoc;

Word.MailMerge wrdMailMerge;

Object oMissing = System.Type.Missing;

Object oFalse = false;

Object oTrue = true;

Object oName = Environment.CurrentDirectory + @"\template.dot";

Object oFileName = Environment.CurrentDirectory + @"\saved.rtf";

Object oFileFormat = Word.WdSaveFormat.wdFormatRTF;

// Starting the Word Application

wrdApp = new Word.ApplicationClass();

wrdApp.Visible = true;

wrdApp.WindowState = Word.WdWindowState.wdWindowStateMaximize;