Hello,
I was asked by some co-workers this week if I could help them finish up a project they were working on using Publisher. I have zero experience with the it, and was wondering if anyone here is skilled with it, and would be willing to help me help them.
The skinny is that they are creating a catalog of products for clients to order from. The item info is pulled from a Access DB. They have a catalog merge set up for that already, but one issue that they asked me about was getting category headers to display. Right now it just lists each item one after another, with no sort of separator ... Basically they want a item category header to print when the category changes (the table is sorted by category), then all of the items in that category to print after ... and so on for each category. More or less, its a report type of thing, grouped by item category.
The database is sorted by the field containing the item category ... Is there a way (through Publisher, VBA, or otherwise) to put a category heading inside the catalog merge, so that it prints the name of the category, then prints all of that category's items?
Thanks in advance!