By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

Publisher | Modifying Catalog Merge

P: 15
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!
Nov 29 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.