Need to do a mailmerge from SQL2K from VB.NET

[DEWright_CA]

I am looking for suggestions on places to look to support this scenario!

I have a app developed in VB.Net, I have a dataset/recordset of fields that
I need to insert into a Word2K3 Templated ala Access/MailMerge.

Where should I start?

Thanks;

 

[Peter Huang [MSFT]]

Hi

When you are programming again Word, we are using Word's Object
Modal(Automation). Actually we can record Macro to know how to do mailmerge
programmingly.
1. Click Tools/Macro/Record New Record
2. Do the mailmerge via UI
3. Press Alt+F11 to open the VBA IDE
4. check the Macro autogenerated about how to do mailmerge in program

Here is a link about how to automation Word in VB.NET
303294 How To Use Automation to Get and to Set Office Document Properties
with
http://support.microsoft.com/?id=303294

Also to interactive database in VB.NET, we use ADO.NET.
Here is a start about how to use ADO.NET
Overview of ADO.NET
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconoverviewofadonet.asp
ADO.NET Sample Application
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconsampleapplication.asp

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.