RE: Need to do a mailmerge from SQL2K from VB.NET

Tech-Archive recommends: Fix windows errors by optimizing your registry



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.

.



Relevant Pages

  • Re: How to forcibly kill the word session?
    ... actually we are trying to cater to the generic scenario when word ... In a normal scenario,after doing a mailmerge, the ... Thus, i need a generic solution wherein, if the word hangs or is in a ... > be a nifty piece of programming. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Visual Basic text box
    ... If you're programming this in Visual Basic, then you need to address your ... Without knowing the internals of your ... file which the mailmerge uses. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Need An Idea For Teaching VBA
    ... But you omitted the answer to a key question: what is the focus of interest and the experience and age group of the students? ... > programming problem of some sort that could be used in the class. ... "VBA programming" is huge topic. ... They can use Record Macro to learn how to delete things and pull up data. ...
    (microsoft.public.excel.misc)