Selecting Fields for a Report

  • Thread starter Thread starter BruceF
  • Start date Start date
B

BruceF

I'm creating a "mail merge" type of report that will allow secretaries to
print labels. One example will print a student's name, their homeroom
teacher, and room number. Another example will print the parent's name,
address, city, state, and zip. I want the secretaries to pick the fields they
need for the labels. I have a form created with 4 lines with 3 combo boxes in
each (12 total). It's sort of like a "label template". Each value in the
combo box is from a table called PossibleFields that has the name of each
field available such as Last Name, First Name, Birthdate, GuardianName,
Homeroom Teacher, Room Number, etc. They can choose any field from any combo
box. The label will look like the fields chosen from the combo boxes.

Is this possible? Is there a better way?
 
I suggest preplaning and create a template for them so they only pick which
template to use and then select names.

Have you tried from the other side - Word Mail-Merge? Open a blank Word
document, click on menu TOOLS - Letters and Mailings - Mail Merge. It opens
an additional window on the right and has step-by-step instructions and
choices. You can also backup in the process. Works fine for me.
 
Back
Top