[darren via OfficeKB.com]

Hi Peter

ACC2003 opens the Word2003 doc along the lines of

strConnection = "DSN=MS Access Database;DBQ=" & CurrentProject.FullName & "
;FIL=MS Access;"

objWord.MailMerge.OpenDataSource _
Name:=CurrentProject.FullName, _
LinkToSource:=True, _
Connection:=strConnection, _
ReadOnly:=True, _
SQLStatement:="SELECT * FROM [" & strTbl & "]"

The merge itself all works fine. Just when a 2007 user then goes 'merge to
new document' that it hangs. Manage to test on another 2007 machine after
original post and it worked fine so now seems to be something specific to
that user.

Thanks for your assistance.

Peter Jamieson wrote:
Can you tell how Word is trying to connect to Access? Is it DDE? If so,
which version of Access?

--
Darren

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200906/1