Thank you, Macropod.
Do you know what SQL statements I would add to open up a window that displays all the queries/tables in a particular database? Leaving that statement blank seems to accomplish this, but does not seem to solve my problem.
I've tried toggling several settings to get the window that asks you to manually confirm the file connection so I can select DDE (which is what happens when the 'Confirm File Conversation..' advanced option is checked).
Essentially I'm wanting the window that opens that is done automatically when you follow the steps in this post:
https://www.msofficeforums.com/mail-...ps-tricks.html (under Mail Merge Data Format Problems).