VB.NET and Mail Merge

Hello,

I wish to link my vb.net web application to word 2003 mail-merge function.

What i specifically wish to do is have a form with some static textboxes and some dropdown lists. Then have a button called create label. When the user clicks this, the method links to a word template with mail merge fields and those fields are populated with the information on the web-form to create a label.

Can this be done and how?

Your help is much appreciated!

Yes, but you will need to have Word on your server and mailmerges with templates are tricky. You can use Bookmarks in your template and then just populate them but since your talking a mailmerge are you wanting to populate several documents at once?

This should give you a basic idea (at least get you on the right track). Write your merge data to a temporary .csv file to use as the data source, and then wipe it when you are done with it. Code is VBA/VB6, and I'll leave you to do the .NET version. sTemplate is the path to the template document, sTempfile is the temp data source.:

VB Code:

Dim oWord As Word.Application, oOut As Word.Document, oMerge As Word.MailMerge, oResult as Word.Document
    
    Set oWord = New Word.Application
    Set oOut = oWord.Documents.Add(sTemplate, False, wdNewBlankDocument, False)
    Set oMerge = oOut.MailMerge
                                                                    
    With oMerge
        Call .OpenDataSource(sTempfile)
        .Destination = wdSendToNewDocument
        .Execute
    End With
 
    Set oResult = oWord.ActiveDocument      'This is your merged document.
    'Close and release ref'd objects.

in response to robdog888, i am oly merging to one word document when the submit button is clicked. So one label is created at a time and thus no need for loops or anything.

Does that make it any simpler?

Yes, so using something like what comintern posted should be good just convert to .net.

i have no experience of vb6 and have just started with vb.net. Are the syntax's and structures the same. Can anyone help me further with the conversion.

Thanks in advance!