D
DebbieC
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.
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.