H
Hera
I have to publish a weekly bulletin that includes a list
of about 100 names, give or take. It is currently visually
presented as three columns of about 35 names each, as
parallel balanced newspaper columns. There's not much
movement in the name list, say about 5-10% in a given
week. Our editor is currently keeping this in a table
frame but it's not in any sort order and is a mess to
update and keep visually pleasing.
I set up an Excel sheet for her and imported the last and
first names into two columns, and then for printing I
concatenated those two fields into one full-name field.
I've tried bringing that data into the Pub template for
her bulletin and it seems the catalog merge is the best
option, but what that does is create 100 individual text
frames for each name! If she wants to relocate or resize
them, arggghh!
I was hoping for 3 auto-flowing text columns, or auto-
creation of a table, or SOMEthing. Obviously, I'm much
better with Excel than with Publisher. <g>
Is there a need to accomplish this in some sort of semi-
automated fasion, so that she can keep work in Excel to
keep the alpha list current, then update the Publisher
document to adjust the overall layout if the number of
names differs too greatly?
Many thanks,
Hera
of about 100 names, give or take. It is currently visually
presented as three columns of about 35 names each, as
parallel balanced newspaper columns. There's not much
movement in the name list, say about 5-10% in a given
week. Our editor is currently keeping this in a table
frame but it's not in any sort order and is a mess to
update and keep visually pleasing.
I set up an Excel sheet for her and imported the last and
first names into two columns, and then for printing I
concatenated those two fields into one full-name field.
I've tried bringing that data into the Pub template for
her bulletin and it seems the catalog merge is the best
option, but what that does is create 100 individual text
frames for each name! If she wants to relocate or resize
them, arggghh!
I was hoping for 3 auto-flowing text columns, or auto-
creation of a table, or SOMEthing. Obviously, I'm much
better with Excel than with Publisher. <g>
Is there a need to accomplish this in some sort of semi-
automated fasion, so that she can keep work in Excel to
keep the alpha list current, then update the Publisher
document to adjust the overall layout if the number of
names differs too greatly?
Many thanks,
Hera