Mail Merge

D

David

I am having trouble opening my data source for mail merge. There seems to be
a problem because I am using the database where the source is

objWord.MailMerge .OpenDataSource _
Name:="C:\Documents and Settings\David\Desktop\WSS.mdb", _
LinkToSource:=True, _
Connection:="table tblAccenture", _
SQLStatement:="SELECT * FROM [tblAccenture] WHERE [Relationship
Manager] = '" & rst![Relationship Manager] & "'"
' Execute the mail merge.
objWord.MailMerge.Execute

It keeps trying to open the database again, I would appreciate any help as I
am pulling my hair out with this one

Thanks in advance
David
 
Top