[RESOLVED] Mail Merge in vb.net

[newbie8899]

Hi, all, need your help. I have a very urgent problem to be solved.

i have collect a set of data from the db using vb.net and save it to a text file.

I also have a template ms word document.

What i would like to do is I want to merge the data in the text file to ms word template using vb.net script. will it be possible? if yes, then how should i do it?

Please, it is urgent. Thanks a lot.

[RobDog888]

Yes, its possible but have you setup your template word doc as a mailmerge document?

[newbie8899]

Hi, RobDog888,

Yes, i have already setup the template as a mailmerge document.

[RobDog888]

Ok, next you will want to add a reference to MS Word xx.0 Object Library and automate it using the Word Object Model.

Then you will create the application instance, open the doc, and execute the MailMerge method.

[RobDog888]

Sorry, but that is for if you need to modify the data source or assign it dynamically. To just execute the merge you only need to open the document for printing etc.

System.Diagnostics.Process.Start("C:\Test.doc")

[newbie8899]

RobDog888,
let's say i generate the data then send it to a text file, later i open the template through vb.net, after that i want the vb.net side to do the mail merge from the data in the text file to word doc template. If like this i have to use the 1st method u suggested?

[RobDog888]

If you keep the file name the same that you used to cinfigure the MM document then just simply starting the process is all thats needed. If you want to sort, change datasource locations, modify the mailerge in any way then you will need to use the WOM to do it.

[newbie8899]

RobDog888,
It sounds like so easy to u..hahha.. so admire..

can you please explain in details? ee.. the best step by step, can?

I really need your help.

Thank you so much

[RobDog888]

Step 1.

Public Class Form1

	Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
		Dim oPSI As New System.Diagnostics.ProcessStartInfo
		oPSI.FileName = "C:\MyTest.doc"
		oPSI.UseShellExecute = True
		oPSI.CreateNoWindow = True
		oPSI.WindowStyle = ProcessWindowStyle.Hidden
		oPSI.Verb = "print"
		System.Diagnostics.Process.Start(oPSI)
	End Sub

End Class

Step 2. Click the Yes button to run the query on your text file.

Step 3. retrieve printed pages from printer.

References: My Office Dev. FAQs
http://vbforums.com/showthread.php?t=402094
http://vbforums.com/showthread.php?t=402097

[newbie8899]

Thankkkssssssss a lot.