Sorry folks for posting the thread twice but I'm need to desprate help...

I'm able to successfully to perform mail merge but only one record at a time. In our org. we send thank-you letters out to our clients whose info. are stored in SQL DB.

Once a template is been created and all the bookmarks are inserted. I would like to perfom a mail merge using the template and info from the database, produce the thank-you letters.

Currently what I'm doing is,

Start Word application
Open Word template
Insert Text at specified bookmark
Print the document
Close word application
And repeat steps again until I print all the letters out for all the clients.

Instead what I would like to do is,
Create a word document of say 50 pages (if 50 clients retreived from db) and then send to print job.

Here is my code

'Loop the dataset
For Each oRow In dsMailList.Tables("Results").Rows

'Start Word and open the document template.
oWord = CreateObject("Word.Application")
oWord.Visible = True
oDoc = oWord.Documents.Add(strtemplate)

' Location of Word template; could be on a shared LAN
strtemplate = fname

oDoc = oWord.Documents.Add(strtemplate)

'Loop the Select Label List to get the values
For i = 0 To chkMailList.CheckedItems.Count - 1

strTest = oRow(chkMailList.CheckedItems(i))

strField = chkMailList.CheckedItems(i)

'strField = oWord.ActiveDocument.Bookmarks.Item(counter)

oWord.ActiveDocument.Bookmarks.Item(strField).Select()
oWord.Selection.TypeText(CStr(strTest))

Next i
oWord.PrintOut(False)

'oWord.PrintOut(Background:True)

CType(oWord, Word._Application).Quit(0)
Next

---------------------------------------------------------------------------------

Don't get confused with my inner loop becuse I give user an option what fields to select and bring corresponding data from the db. So inner loop is basically looping for checkedlist box.

Secondly, I heard something about DDE, to pass data using DDE for Windows Application, please shed some light on it if possible.

I'm sorry for this long content, any help would be really appreciative.

Thanks