mail merge locking

J

judith

I am trying to mail merge from Access. The first merge works fine but if i go
out to run a further merge it opens word but fails to link back to the
database table. I am using


objWordDoc.Documents.Add templateName


' Set the mail merge data source .
ActiveDocument.MailMerge.OpenDataSource _
Name:=wordLinkBase, _
LinkToSource:=True, _
Connection:="TABLE " & tableName, _
SQLStatement:="SELECT * FROM [" & tableName & "]"

' Execute the mail merge.

Set closeFileName = ActiveDocument
ActiveDocument.MailMerge.Execute
closeFileName.Close wdDoNotSaveChanges



Using Access XP but with 2000 format

Any suggestions please
 
Top