Catalog Merge - Conditional Formatting, vertical order & grouping

[Melanie Martin]

I'm working on two directories for a local charity and am trying to do it all
in Publisher 2003 with and Excel database. I'm hitting three problems:
1. I can't seem to get it to not print a blank line when I do not have that
line's data (i.e. address2 line). I've tried to use the conditional
formatting coding I've used in other MS products but Publisher doens't seem
to recognize it.

2. I need it to print in vertical order, but the default is horizontal. How
do I change this setting?

3. One of the things I'm doing is a book of animal names that needs to be
presented grouped by location then by species. I don't see any way to group
my catalog results the way you can do it in MS Access. Any ideas? I'd like
to do it Publisher because we're doing it as a booklet.

Thanks for any help/advice you can provide!
Melanie Martin

 

[Mary Sauer]

1. File, print merge, uncheck *Don't print lines that contain only empty
fields*.
2. You will have to create your database differently if you want it to sort
vertically. There is an example here, just left of the eagle.
http://msauer.mvps.org/more_graphics.htm
3. This is more difficult. You could put a dummy name before the next section.
Create a word that would follow alphabetically. Or in step five, create a new
publication and manually create a section heading. All the entries are nothing
more than text boxes, they can be moved about.