Change Directory for MailMerge Word Document with MS Access as DataSource RRS feed

  • Question

  • I created a MailMerge Word document whose datasource is MS Access table. I used the MailMerge wizard to do this. It works fine when I open it (we open the document from Access). The issue is when someone else opens it.

    The Word document is on team network drive but we use different drives to map to the same location:

    i.e. I map to the the datasource by "R:\\teamserver\databases\" while someone else maps to the same datasource by using "T:\\teamserver\databases\"

    So when someone else opens the document it does not connect to the datasource (the MS Access table).

    Any way to change this? VBA? I very familiar with VBA in Access not so much so in Word.

    Any help appreciated - Thank you Robert

    Friday, May 4, 2012 4:45 PM


  • You could use the UNC path instead of the driveletter.

    Regards, Hans Vogelaar

    • Marked as answer by Quist Zhang Wednesday, May 30, 2012 2:08 AM
    Friday, May 4, 2012 6:50 PM