Office 2003 - WinXP

I have an access database that sends data to a word template. When i
click on the button to merge it take longer than it seems it should. i
see a few so called alerts at the bottom of the screen..

"starting microsoft access"
"waiting for microsoft acces to accept dde commands"
"initializing dde link with microsoft access"

then it does the merge. bleow is the code. can somene tell me how to
do this in a more efficient manner???

oDoc.MailMerge.OpenDataSource _
Name:="C:\re\support.mdb", _
Connection:="TABLE tblSUPPORT", _
SQLStatement:="SELECT * From tblSUPPORT", _
Subtype:=wdMergeSubTypeWord2000

With oDoc.MailMerge
.Destination = wdSendToNewDocument
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = True

With .DataSource
.FirstRecord = Forms!frmSupport.CurrentRecord
.LastRecord = Forms!frmSupport.CurrentRecord
End With

.Execute Pause:=True

End With


--
oakleyp2Posted from - http://www.officehelp.in