I have been using the code below to mail merge data in my Access 2007 database to a word 2007 documnet for a few years now without any issue. A few of uor computers now have Windows 7 and whenever the mailmerge runs it says it cannot find the temp table in Access holding the data and brings up a data source selection box which does not show the data base. The Mail merge is started in Access and has work great in XP. Any Ideas as to why this would be happening.


' MsgBox strCriteria
Set objWord = GetObject(strFilePath, "Word.document")
objWord.MailMerge.Execute
objWord.Application.Visible = True

objWord.Close

Access is open during the mail merge process.


Steve

Steve,

Merging with an Access table has many issue. For instance Word has to open another instance of Access to perform the merge. This cause Access to get loaded twice.

I have found it best to avoid ever letting Word use an Access database as a merge source. Instead I export the data from Access to a Word merge document. Have Word use this as the merge source. I have not ever had any issue with this method with any Word, Access and Windows version combination.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

This has help greatly.

You're welcome.

Good luck with your project.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015