Hi, I am setting up an automatic mailmerge macro in Excel. The Excel
worksheet is maintained by several people in our HR dept., and several of the
fields have dropdown/list boxes that are tied to tables. For example,
Sheet1$ is for tracking terminated employees and has a field named 'Reason
for Leaving', which uses a table called TermReason to populate the dropdown
box with the reason for termination; a field named 'Division', which uses a
table called Div to populate the dropdown box with the department; and a
field named 'Full Time/Part Time' tied to a table called FTPT to populate
the dropdown with employment status.
I am trying to select all the fields in the Sheet1$ worksheet automatically
without having the Select Table Dialog Box appear, but it keeps showing up
with the names of the tables for the embedded dropdown boxes. I have tried
using named ranges and SQLStatement select criteria, but have not been
successful. Any help with this would be appreciated.