Mail Merge using ActiveX in MS Word

[FightOnSCTrojan]

Labview Gurus:

Anyone of you tried using a popular feature of MS Word � Mail Merge?
Pretty much what I am trying to do is for a word template to read from Excel and load data onto the pre-defined fields. I could do it manually, but when it comes the time calling LabVIEW Activex to perform the same task, it failed.
Any thoughts/Inputs/Recommendations?

USCTrojan

p.s. I know that this Report Generation Toolkit might help, but the funding for the project is tight, so that will not be an option at this time.

[FightOnSCTrojan]

After some trial and error, I am now able to answer my own question.

After calling setting up the correct property (Mailmerge.DataSource) and methods (in my case FirstRecord and LastRecord), what threw me off was that I actually had to wire the property to a method called �Execute�, the method that starts the MailMerge. After this method, you can wire the diagram as you normally would (Save and Quit Application), along with close application object.

I hope this helps for anyone who plans to use MailMerge in the future!

USCTrojan