Word Mail Merge fails to see MS Access data source

transfertextWe have an Access database that has been used for years as a data source for merging Word documents.? A button in the Access app would run a MakeTable query and then launch Word, which would open a document that looked to the table as a data source.

Two weeks ago, the mail merge documents began refusing to see the data source.? I read all of the tips about using Internet Explorer’s security settings to put the network path in the Intranet or Trusted Sites zones.? That actually helped on some machines, but not most.

My solution was to use the VBA (Visual Basic for Applications) function “TransferText” to export the table to a text file on the local hard drive.? I then reconfigured all of the merge documents to look to that local file.? The basic instructions can be found here.

Leave a Reply

Your email address will not be published. Required fields are marked *