Creating mail merge application using Word

Question

Hi,

We are in the process in developing a coldfusion web
application that enables user to upload Word document and a data
source for mail merge.

After spending few hours googling, we are still unable to
find a definite solution. Does anyone give us a pointer on how we
might be able to achieve this? Can coldfusion maybe by using Java
be able to access Microsoft's Office objects?

Your help will be truly appreciated.

Anonymous · Accepted Answer

Use the <cfobject> tag of coldfusion to create the below objects of word application (you should have Microsoft word installed in your cf server).
Word.Application
Word.Document
Word.MailMerge

Then you can follow the same steps how you do a VB program to create the Word MailMerge in ColdFusion. A sample vb code is give below,

Dim oWordApp As New Word.Application
Dim WrdDoc As Word.Document
Dim wrdMailMerge As Word.MailMerge

Set WrdDoc = oWordApp.Documents.Open("template path", ReadOnly:=True)
Set wrdMailMerge = WrdDoc.MailMerge
wrdMailMerge.OpenDataSource Name:="file path", Format:="format", ConfirmConversions:=True
wrdMailMerge.Destination = wdSendToNewDocument
wrdMailMerge.Execute
oWordApp.ActiveDocument.SaveAs FileName:="full path & name", FileFormat:="format"

Set oWordApp = Nothing

Anonymous · Answer

Thanks for your help, I will try to implement yoursuggestion.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded