Share via

Word 2016 Mail Merge problem accessing database

Anonymous
2021-05-04T15:31:31+00:00

Hi,

I am trying to complete a mail merge and each time I get to the 'select recipients' step, I choose my Excel workbook (as I have done for years) but instead of getting a series of 'tabs' to choose from, I get this this 'select table' popup. Any ideas?

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
    2021-05-05T00:01:34+00:00

    In Word, go to FIle>Options>Advanced>General and uncheck the box for "Confirm file format conversion on open"  When you do that, the data source should be connected by use of the OLE DB DataBase Files method of connection and you will see the following dialog from which you can select the sheet that contains the data

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-05-04T16:12:49+00:00

    Hello,

    My name is Charles Kenyon and I am an Independent Advisor in this forum . This forum is a user-to-user support forum. I am a fellow user with decades of experience using Microsoft Word. I have written extensively on using Word and have help articles on the Microsoft site.

    Is this a problem with one mail merge or all or something in between?

    You may want to review How to Troubleshoot Problems that Occur When You Start Word

    https://support.microsoft.com/help/921541/how-t...

    Does it happen if you open Word in Safe mode?

    https://support.office.com/article/Open-Office-...

    Safe mode is not a way to regularly use Word, but it is a valuable diagnostic step. If your problem goes away when you use Safe mode, we can walk you through other steps that may help eliminate the problem. Please write back.

    If it works in Safe mode, you may want to look at the following while waiting for more information from me or here on the forum.

    http://www.addbalance.com/word/addins.htm

    This link is to a page on my website. It is safe. I am providing it because I think it contains information that will help you. However, as an Independent Advisor I am required to add the following when posting here with a link to any non-Microsoft site:

    Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    I hope this information helps.

    Please let me know if you have any more questions or require further help.

    You can ask for more help by replying to this post (Reply button below).

    Stay well

    Was this answer helpful?

    0 comments