Merge to New Document hangs

[darren via OfficeKB.com]

Hi

I have a Word2003 mailmerge that opens from an Access database. All is fine ,
however, Word 2007 users have notified me that when they try to then 'merge
to new document' word just hangs. Word07 open the documents in compatibility
mode, is this related in anyway?

Your thoughts and suggestions please.

 

[Peter Jamieson]

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


Peter Jamieson

http://tips.pjmsn.me.uk

 

[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.