Word Mail Merge Automation using ASP.Net

sbhatia · June 22nd, 2005, 01:56 AM

Hi,

I am trying to automate word mail merge and redirecting the output to the printer. Since I am making use of ASP.Net as technology, so word application is not visible to me. But when print command fires from the code, a print dialog box opens up in the background, which makes the system to hang. Please do the needful.

Dim wrdSelection As Word.Selection
        Dim wrdMailMerge As Word.MailMerge
        Dim wrdMergeFields As Word.MailMergeFields

        Dim StrToAdd As String

        ' Create an instance of Word and make it visible.
        wrdApp = CreateObject("Word.Application")
        wrdApp.Visible = True
        wrdApp.DisplayAlerts = 0

        ' Add a new document.

        wrdDoc = wrdApp.Documents.Open("ThankYou.doc")
        wrdDoc.Select()

        wrdSelection = wrdApp.Selection()
        wrdMailMerge = wrdDoc.MailMerge()

        ' Create MailMerge Data file.
        CreateMailMergeDataFile()

        Dim strPrinterName As String
        Dim objDialog As Object
        strPrinterName = wrdApp.ActivePrinter

        wrdApp.ActivePrinter = "Dummy"
        wrdMailMerge.SuppressBlankLines = True

        wrdMailMerge.Destination = Word.WdMailMergeDestination.wdSendToPrinter

        wrdMailMerge.Execute(False)
        wrdApp.ActivePrinter = strPrinterName

        ' Release References.
        wrdSelection = Nothing
        wrdMailMerge = Nothing
        wrdMergeFields = Nothing
        wrdDoc = Nothing
        wrdApp = Nothing

nullstr · April 28th, 2006, 10:41 PM

Hi

Did you solve this problem in the end? I'd be interested to know the solution.

Cheers

n

aditya_raj · December 17th, 2007, 02:13 AM

Hi i want to do the mail merge using a mSword template and CSV file and save the resulting document as PDF.How can i do that .Please advice me .

Thanks.

RedDotVasilyev · November 29th, 2013, 07:18 AM

Hi, I also encountered some issues when I used a .NET word interop in ASP.NET app.
I found that it is not supported: MS support page (Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications on server side), but they provide some alternatives to server-side automation.
You could try this alternative VB.NET Word component to achieve mail merge in .NET from the server side, here is a small example:

Code:

' Load DOC document.
Dim document = DocumentModel.Load("ThankYou.doc")

' Execute mail merge.
document.MailMerge.Execute(dataSource)

Also you could easily print Word with .NET without PrintDialog popping out, just use this:

Code:

document.Print()

Additionally, aditya_raj you can also check this out because I found its mail merge process to be very flexible and customizable.
You could for example read CSV file into a DataTable and then use it as an data source for a mail merge execution, after which you could convert Word file to a PDF in .NET like the following:

Code:

document.Save("Document.pdf")