How do I create a school directory in Publisher 2000?

At the moment I have no way to get at them. They're all archived on zip
discs and I loaned that machine to my niece for a week. I have the
discs...she has the drive :-)


--

Rob Giordano
Microsoft MVP - FrontPage





"TerriN" wrote in message
...
| Sounds like exactly what I would like to do the same. Could you email me a
| page from both Publisher and excel to see what the end result was? I am
| starting from scratch so any help would be a big help. So if I understand
you
| type the info in Excel and then just pasted it in publisher???? In a
booklet
| format?
| --
| Terri N.
|
|
| "Rob Giordano (Crash)" wrote:
|
| I set it up landscape on 8.5 x 11 but I kept my columns as name,
address,
| grade, phone, email in tables on each facing page so I didn't have to
try to
| cross the gutter. I think you're doing it differently from what I'm
reading.
| I found Excel to be the easiest to set the tables up, because I could
| search/replace, alphabetize and do some conditional formating .
|
| I did this 4 years running for my daughter's middle school. The worst
part
| was getting the info from the teachers (computer dummies compared to the
| kids!) I had to create all the ads as well because it seems no one
| understands what camera-ready means. It was fun but frustrating at the
same
| time.
|
| The covers were spot color so that I did as separate pub doc. Everything
| inside was b&w.
|
| --
|
| Rob Giordano
| Microsoft MVP - FrontPage
|
|
|
|
|
| "TerriN" wrote in message
| ...
| |I am looking to do the directory in landscape orientation, with one
listing
| | after the other like a personal telephone book. Any suggestion to what
| label
| | to use for this? Is this something that can be done? The final
directory
| | will be in a booklet format and stapled in the center. Did you put all
the
| | data in excel then import/merge into publisher?
| | --
| | Terri N.
| |
| |
| | "TerriN" wrote:
| |
| | I would like to do this as well but I have Publisher 2002. I
understand
| about
| | entering all the data in Excel but then how do you set up Publisher
in a
| | booklet format to look like a directory. Can someone explain that to
me
| step
| | by step. I am a bit confused.Could you email me a sample page
perhaps so
| I
| | understand the formatting you used. I have tried this and the same
entry
| | appears over and over again even though I have let say 20 entries.
| PLease
| | advise.
| | --
| | Terri N.
| |
| |
| | "me04984" wrote:
| |
| | Did you do the labels in Word first and them transfer them into
| PUblisher?
| | Or can you make a directory with labels right in Publisher?
| |
| | "Rob Giordano (Crash)" wrote:
| |
| | It worked for me. There's probably several other ways to do it,
but
| given
| | all the junk the teachers gave me...Word files, Wordperfect,
Excel,
| straight
| | text, handwritten scraps of paper...blah blah blah. Starting off
| fixing all
| | that junk made sense to me in Excel.
| |
| | Set it up as a booklet in Pub and bring in each class's table of
| names, the
| | use pub to make everythang pretty.
| |
| | I probably did 8 like that and it worked fine. I could slap the
| teachers
| | though for not following my instructions.
| |
| |
| | "melamb" wrote in message
| | ...
| | | Thanks for your help! It sure would be nice to keep it all in
| | Publisher--not
| | | sure it can be done, especially since I want it to print as a
| booklet. I
| | | can't set them up as labels, as was suggested by someone else,
and
| still
| | | print a booklet. Your suggestion seems to be the only way to
get
| it done
| | and
| | | I really appreciate your help!
| | |
| | | "Rob Giordano (Crash)" wrote:
| | |
| | | I got roped into doing several school directories. The way I
did
| them
| | was
| | | first in Excel so I could alphabetize them and also search
for
| dupes.
| | Then
| | | put the tables into Pub. and did all the pretty stuff in
Pub.
| Works
| | great,
| | | the only hard part was getting the information from the
school &
| | | teachers...THAT nearly drove me nutso.
| | |
| | |
| | |
| | | "melamb" wrote in message
| | | ...
| | | |I am trying to create a school directory listing all
families
| in our
| | | school,
| | | | sort of like an address book. I would like to use the
mail
| merge
| | feature,
| | | | but can't figure out how to make the merge work. Every
time I
| merge
| | | (whether
| | | | in the preview or actual printing) it prints the first
listing
| in the
| | | | database over and over, so that the first family is the
only
| family in
| | the
| | | | directory and none of the other families are included.
The
| second
| | copy
| | | | contains only the family listed second in my database, and
so
| on.
| | Please
| | | | help!
| | |
| | |
| | |
| |
| |
| |
|
|
|

Terri, You cannot merge a booklet in Publisher 2002. There are workarounds if
you are willing to do the work. I think Ron (Crash) has worked out one, I don't
quite understand what he is doing.



--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"TerriN" wrote in message
...
I am looking to do the directory in landscape orientation, with one listing
after the other like a personal telephone book. Any suggestion to what label
to use for this? Is this something that can be done? The final directory
will be in a booklet format and stapled in the center. Did you put all the
data in excel then import/merge into publisher?
--
Terri N.


"TerriN" wrote:

I would like to do this as well but I have Publisher 2002. I understand about
entering all the data in Excel but then how do you set up Publisher in a
booklet format to look like a directory. Can someone explain that to me step
by step. I am a bit confused.Could you email me a sample page perhaps so I
understand the formatting you used. I have tried this and the same entry
appears over and over again even though I have let say 20 entries. PLease
advise.
--
Terri N.


"me04984" wrote:

Did you do the labels in Word first and them transfer them into PUblisher?
Or can you make a directory with labels right in Publisher?

"Rob Giordano (Crash)" wrote:

It worked for me. There's probably several other ways to do it, but given
all the junk the teachers gave me...Word files, Wordperfect, Excel,
straight
text, handwritten scraps of paper...blah blah blah. Starting off fixing
all
that junk made sense to me in Excel.

Set it up as a booklet in Pub and bring in each class's table of names,
the
use pub to make everythang pretty.

I probably did 8 like that and it worked fine. I could slap the teachers
though for not following my instructions.


"melamb" wrote in message
...
| Thanks for your help! It sure would be nice to keep it all in
Publisher--not
| sure it can be done, especially since I want it to print as a booklet.
I
| can't set them up as labels, as was suggested by someone else, and
still
| print a booklet. Your suggestion seems to be the only way to get it
done
and
| I really appreciate your help!
|
| "Rob Giordano (Crash)" wrote:
|
| I got roped into doing several school directories. The way I did them
was
| first in Excel so I could alphabetize them and also search for dupes.
Then
| put the tables into Pub. and did all the pretty stuff in Pub. Works
great,
| the only hard part was getting the information from the school &
| teachers...THAT nearly drove me nutso.
|
|
|
| "melamb" wrote in message
| ...
| |I am trying to create a school directory listing all families in our
| school,
| | sort of like an address book. I would like to use the mail merge
feature,
| | but can't figure out how to make the merge work. Every time I
merge
| (whether
| | in the preview or actual printing) it prints the first listing in
the
| | database over and over, so that the first family is the only family
in
the
| | directory and none of the other families are included. The second
copy
| | contains only the family listed second in my database, and so on.
Please
| | help!
|
|
|

Mary, Do you know if I can do something similar I can do to achieve multiple
listing on a page like an address book? I understood you set up to make my
own label but wil that come out in booklet form so I can staple down the
middle, once folded over? Or am I asking for too much? Can you email a sample
of what you have done?
--
Terri N.


"Mary Sauer" wrote:

Terri, You cannot merge a booklet in Publisher 2002. There are workarounds if
you are willing to do the work. I think Ron (Crash) has worked out one, I don't
quite understand what he is doing.



--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"TerriN" wrote in message
...
I am looking to do the directory in landscape orientation, with one listing
after the other like a personal telephone book. Any suggestion to what label
to use for this? Is this something that can be done? The final directory
will be in a booklet format and stapled in the center. Did you put all the
data in excel then import/merge into publisher?
--
Terri N.


"TerriN" wrote:

I would like to do this as well but I have Publisher 2002. I understand about
entering all the data in Excel but then how do you set up Publisher in a
booklet format to look like a directory. Can someone explain that to me step
by step. I am a bit confused.Could you email me a sample page perhaps so I
understand the formatting you used. I have tried this and the same entry
appears over and over again even though I have let say 20 entries. PLease
advise.
--
Terri N.


"me04984" wrote:

Did you do the labels in Word first and them transfer them into PUblisher?
Or can you make a directory with labels right in Publisher?

"Rob Giordano (Crash)" wrote:

It worked for me. There's probably several other ways to do it, but given
all the junk the teachers gave me...Word files, Wordperfect, Excel,
straight
text, handwritten scraps of paper...blah blah blah. Starting off fixing
all
that junk made sense to me in Excel.

Set it up as a booklet in Pub and bring in each class's table of names,
the
use pub to make everythang pretty.

I probably did 8 like that and it worked fine. I could slap the teachers
though for not following my instructions.


"melamb" wrote in message
...
| Thanks for your help! It sure would be nice to keep it all in
Publisher--not
| sure it can be done, especially since I want it to print as a booklet.
I
| can't set them up as labels, as was suggested by someone else, and
still
| print a booklet. Your suggestion seems to be the only way to get it
done
and
| I really appreciate your help!
|
| "Rob Giordano (Crash)" wrote:
|
| I got roped into doing several school directories. The way I did them
was
| first in Excel so I could alphabetize them and also search for dupes.
Then
| put the tables into Pub. and did all the pretty stuff in Pub. Works
great,
| the only hard part was getting the information from the school &
| teachers...THAT nearly drove me nutso.
|
|
|
| "melamb" wrote in message
| ...
| |I am trying to create a school directory listing all families in our
| school,
| | sort of like an address book. I would like to use the mail merge
feature,
| | but can't figure out how to make the merge work. Every time I
merge
| (whether
| | in the preview or actual printing) it prints the first listing in
the
| | database over and over, so that the first family is the only family
in
the
| | directory and none of the other families are included. The second
copy
| | contains only the family listed second in my database, and so on.
Please
| | help!
|
|
|

Massaging info in Excel first then simply plopping tables into Pub...manual
procedure...no merging.

--

Rob Giordano
Microsoft MVP - FrontPage





"Mary Sauer" wrote in message
...
| Terri, You cannot merge a booklet in Publisher 2002. There are workarounds
if
| you are willing to do the work. I think Ron (Crash) has worked out one, I
don't
| quite understand what he is doing.
|
|
|
| --
| Mary Sauer MSFT MVP
| http://office.microsoft.com/
| http://msauer.mvps.org/
| news://msnews.microsoft.com
|
| "TerriN" wrote in message
| ...
| I am looking to do the directory in landscape orientation, with one
listing
| after the other like a personal telephone book. Any suggestion to what
label
| to use for this? Is this something that can be done? The final
directory
| will be in a booklet format and stapled in the center. Did you put all
the
| data in excel then import/merge into publisher?
| --
| Terri N.
|
|
| "TerriN" wrote:
|
| I would like to do this as well but I have Publisher 2002. I understand
about
| entering all the data in Excel but then how do you set up Publisher in
a
| booklet format to look like a directory. Can someone explain that to me
step
| by step. I am a bit confused.Could you email me a sample page perhaps
so I
| understand the formatting you used. I have tried this and the same
entry
| appears over and over again even though I have let say 20 entries.
PLease
| advise.
| --
| Terri N.
|
|
| "me04984" wrote:
|
| Did you do the labels in Word first and them transfer them into
PUblisher?
| Or can you make a directory with labels right in Publisher?
|
| "Rob Giordano (Crash)" wrote:
|
| It worked for me. There's probably several other ways to do it, but
given
| all the junk the teachers gave me...Word files, Wordperfect, Excel,
| straight
| text, handwritten scraps of paper...blah blah blah. Starting off
fixing
| all
| that junk made sense to me in Excel.
|
| Set it up as a booklet in Pub and bring in each class's table of
names,
| the
| use pub to make everythang pretty.
|
| I probably did 8 like that and it worked fine. I could slap the
teachers
| though for not following my instructions.
|
|
| "melamb" wrote in message
| ...
| | Thanks for your help! It sure would be nice to keep it all in
| Publisher--not
| | sure it can be done, especially since I want it to print as a
booklet.
| I
| | can't set them up as labels, as was suggested by someone else,
and
| still
| | print a booklet. Your suggestion seems to be the only way to get
it
| done
| and
| | I really appreciate your help!
| |
| | "Rob Giordano (Crash)" wrote:
| |
| | I got roped into doing several school directories. The way I
did them
| was
| | first in Excel so I could alphabetize them and also search for
dupes.
| Then
| | put the tables into Pub. and did all the pretty stuff in Pub.
Works
| great,
| | the only hard part was getting the information from the school
&
| | teachers...THAT nearly drove me nutso.
| |
| |
| |
| | "melamb" wrote in message
| | ...
| | |I am trying to create a school directory listing all families
in our
| | school,
| | | sort of like an address book. I would like to use the mail
merge
| feature,
| | | but can't figure out how to make the merge work. Every time
I
| merge
| | (whether
| | | in the preview or actual printing) it prints the first
listing in
| the
| | | database over and over, so that the first family is the only
family
| in
| the
| | | directory and none of the other families are included. The
second
| copy
| | | contains only the family listed second in my database, and so
on.
| Please
| | | help!
| |
| |
| |
|
|
|
|
|

Basically this is the way you have to do it in Publisher 2002. Open the Office
Clipboard (edit menu), you can collect 24 items.

Do your merge using any label setup, preview each entry, copy the entry and
paste the text to a pre-created table in another instance of Publisher that you
have setup for a booklet directory. You can collect 24 entries at a time. It
sounds complicated, but it isn't. Publisher 2003 and 07 have a catalogue merge
that can make directories in minutes.


--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Rob Giordano (Crash)" wrote in message
...
Massaging info in Excel first then simply plopping tables into Pub...manual
procedure...no merging.

--

Rob Giordano
Microsoft MVP - FrontPage





"Mary Sauer" wrote in message
...
| Terri, You cannot merge a booklet in Publisher 2002. There are workarounds
if
| you are willing to do the work. I think Ron (Crash) has worked out one, I
don't
| quite understand what he is doing.
|
|
|
| --
| Mary Sauer MSFT MVP
| http://office.microsoft.com/
| http://msauer.mvps.org/
| news://msnews.microsoft.com
|
| "TerriN" wrote in message
| ...
| I am looking to do the directory in landscape orientation, with one
listing
| after the other like a personal telephone book. Any suggestion to what
label
| to use for this? Is this something that can be done? The final
directory
| will be in a booklet format and stapled in the center. Did you put all
the
| data in excel then import/merge into publisher?
| --
| Terri N.
|
|
| "TerriN" wrote:
|
| I would like to do this as well but I have Publisher 2002. I understand
about
| entering all the data in Excel but then how do you set up Publisher in
a
| booklet format to look like a directory. Can someone explain that to me
step
| by step. I am a bit confused.Could you email me a sample page perhaps
so I
| understand the formatting you used. I have tried this and the same
entry
| appears over and over again even though I have let say 20 entries.
PLease
| advise.
| --
| Terri N.
|
|
| "me04984" wrote:
|
| Did you do the labels in Word first and them transfer them into
PUblisher?
| Or can you make a directory with labels right in Publisher?
|
| "Rob Giordano (Crash)" wrote:
|
| It worked for me. There's probably several other ways to do it, but
given
| all the junk the teachers gave me...Word files, Wordperfect, Excel,
| straight
| text, handwritten scraps of paper...blah blah blah. Starting off
fixing
| all
| that junk made sense to me in Excel.
|
| Set it up as a booklet in Pub and bring in each class's table of
names,
| the
| use pub to make everythang pretty.
|
| I probably did 8 like that and it worked fine. I could slap the
teachers
| though for not following my instructions.
|
|
| "melamb" wrote in message
| ...
| | Thanks for your help! It sure would be nice to keep it all in
| Publisher--not
| | sure it can be done, especially since I want it to print as a
booklet.
| I
| | can't set them up as labels, as was suggested by someone else,
and
| still
| | print a booklet. Your suggestion seems to be the only way to get
it
| done
| and
| | I really appreciate your help!
| |
| | "Rob Giordano (Crash)" wrote:
| |
| | I got roped into doing several school directories. The way I
did them
| was
| | first in Excel so I could alphabetize them and also search for
dupes.
| Then
| | put the tables into Pub. and did all the pretty stuff in Pub.
Works
| great,
| | the only hard part was getting the information from the school
&
| | teachers...THAT nearly drove me nutso.
| |
| |
| |
| | "melamb" wrote in message
| | ...
| | |I am trying to create a school directory listing all families
in our
| | school,
| | | sort of like an address book. I would like to use the mail
merge
| feature,
| | | but can't figure out how to make the merge work. Every time
I
| merge
| | (whether
| | | in the preview or actual printing) it prints the first
listing in
| the
| | | database over and over, so that the first family is the only
family
| in
| the
| | | directory and none of the other families are included. The
second
| copy
| | | contains only the family listed second in my database, and so
on.
| Please
| | | help!
| |
| |
| |
|
|
|
|
|

Mary, Hi, i followed your directions from 9/28/06 regarding the school
directory and changing the custom page - which is what I am looking to do -
is there anyway to do this in landscape form so I can get names on both side
of the landscaped booklet folded in half. It worked perfect and your hint
that is prints differently then previews was extremely helpful. But I want to
have labels in landscape format with names appearing on both the left and
right side of the page, is there a way to do this? Thanks.

--
Terri N.


"Mary Sauer" wrote:

Basically this is the way you have to do it in Publisher 2002. Open the Office
Clipboard (edit menu), you can collect 24 items.

Do your merge using any label setup, preview each entry, copy the entry and
paste the text to a pre-created table in another instance of Publisher that you
have setup for a booklet directory. You can collect 24 entries at a time. It
sounds complicated, but it isn't. Publisher 2003 and 07 have a catalogue merge
that can make directories in minutes.


--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Rob Giordano (Crash)" wrote in message
...
Massaging info in Excel first then simply plopping tables into Pub...manual
procedure...no merging.

--

Rob Giordano
Microsoft MVP - FrontPage





"Mary Sauer" wrote in message
...
| Terri, You cannot merge a booklet in Publisher 2002. There are workarounds
if
| you are willing to do the work. I think Ron (Crash) has worked out one, I
don't
| quite understand what he is doing.
|
|
|
| --
| Mary Sauer MSFT MVP
| http://office.microsoft.com/
| http://msauer.mvps.org/
| news://msnews.microsoft.com
|
| "TerriN" wrote in message
| ...
| I am looking to do the directory in landscape orientation, with one
listing
| after the other like a personal telephone book. Any suggestion to what
label
| to use for this? Is this something that can be done? The final
directory
| will be in a booklet format and stapled in the center. Did you put all
the
| data in excel then import/merge into publisher?
| --
| Terri N.
|
|
| "TerriN" wrote:
|
| I would like to do this as well but I have Publisher 2002. I understand
about
| entering all the data in Excel but then how do you set up Publisher in
a
| booklet format to look like a directory. Can someone explain that to me
step
| by step. I am a bit confused.Could you email me a sample page perhaps
so I
| understand the formatting you used. I have tried this and the same
entry
| appears over and over again even though I have let say 20 entries.
PLease
| advise.
| --
| Terri N.
|
|
| "me04984" wrote:
|
| Did you do the labels in Word first and them transfer them into
PUblisher?
| Or can you make a directory with labels right in Publisher?
|
| "Rob Giordano (Crash)" wrote:
|
| It worked for me. There's probably several other ways to do it, but
given
| all the junk the teachers gave me...Word files, Wordperfect, Excel,
| straight
| text, handwritten scraps of paper...blah blah blah. Starting off
fixing
| all
| that junk made sense to me in Excel.
|
| Set it up as a booklet in Pub and bring in each class's table of
names,
| the
| use pub to make everythang pretty.
|
| I probably did 8 like that and it worked fine. I could slap the
teachers
| though for not following my instructions.
|
|
| "melamb" wrote in message
| ...
| | Thanks for your help! It sure would be nice to keep it all in
| Publisher--not
| | sure it can be done, especially since I want it to print as a
booklet.
| I
| | can't set them up as labels, as was suggested by someone else,
and
| still
| | print a booklet. Your suggestion seems to be the only way to get
it
| done
| and
| | I really appreciate your help!
| |
| | "Rob Giordano (Crash)" wrote:
| |
| | I got roped into doing several school directories. The way I
did them
| was
| | first in Excel so I could alphabetize them and also search for
dupes.
| Then
| | put the tables into Pub. and did all the pretty stuff in Pub.
Works
| great,
| | the only hard part was getting the information from the school
&
| | teachers...THAT nearly drove me nutso.
| |
| |
| |
| | "melamb" wrote in message
| | ...
| | |I am trying to create a school directory listing all families
in our
| | school,
| | | sort of like an address book. I would like to use the mail
merge
| feature,
| | | but can't figure out how to make the merge work. Every time
I
| merge
| | (whether
| | | in the preview or actual printing) it prints the first
listing in
| the
| | | database over and over, so that the first family is the only
family
| in
| the
| | | directory and none of the other families are included. The
second
| copy
| | | contains only the family listed second in my database, and so
on.
| Please
| | | help!
| |
| |
| |
|
|
|
|
|

Terri,
It is about the same as setting up a portrait page. The problem is Publisher
wants to print across rather than down. In other words the data will be like
this when you print.

a a a
a b b
c c d

when you really want it to look like this in a directory

a e
a e
a f
b
c
d

How many pages will you have? How many names? You may have to do your directory
on single sheets and staple together rather than a folded directory. If you had
2003 Publisher it would be so much easier for you.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"TerriN" wrote in message
...
Mary, Hi, i followed your directions from 9/28/06 regarding the school
directory and changing the custom page - which is what I am looking to do -
is there anyway to do this in landscape form so I can get names on both side
of the landscaped booklet folded in half. It worked perfect and your hint
that is prints differently then previews was extremely helpful. But I want to
have labels in landscape format with names appearing on both the left and
right side of the page, is there a way to do this? Thanks.

--
Terri N.


"Mary Sauer" wrote:

Basically this is the way you have to do it in Publisher 2002. Open the
Office
Clipboard (edit menu), you can collect 24 items.

Do your merge using any label setup, preview each entry, copy the entry and
paste the text to a pre-created table in another instance of Publisher that
you
have setup for a booklet directory. You can collect 24 entries at a time. It
sounds complicated, but it isn't. Publisher 2003 and 07 have a catalogue
merge
that can make directories in minutes.


--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Rob Giordano (Crash)" wrote in message
...
Massaging info in Excel first then simply plopping tables into Pub...manual
procedure...no merging.

--

Rob Giordano
Microsoft MVP - FrontPage





"Mary Sauer" wrote in message
...
| Terri, You cannot merge a booklet in Publisher 2002. There are
workarounds
if
| you are willing to do the work. I think Ron (Crash) has worked out one, I
don't
| quite understand what he is doing.
|
|
|
| --
| Mary Sauer MSFT MVP
| http://office.microsoft.com/
| http://msauer.mvps.org/
| news://msnews.microsoft.com
|
| "TerriN" wrote in message
| ...
| I am looking to do the directory in landscape orientation, with one
listing
| after the other like a personal telephone book. Any suggestion to what
label
| to use for this? Is this something that can be done? The final
directory
| will be in a booklet format and stapled in the center. Did you put all
the
| data in excel then import/merge into publisher?
| --
| Terri N.
|
|
| "TerriN" wrote:
|
| I would like to do this as well but I have Publisher 2002. I
understand
about
| entering all the data in Excel but then how do you set up Publisher in
a
| booklet format to look like a directory. Can someone explain that to
me
step
| by step. I am a bit confused.Could you email me a sample page perhaps
so I
| understand the formatting you used. I have tried this and the same
entry
| appears over and over again even though I have let say 20 entries.
PLease
| advise.
| --
| Terri N.
|
|
| "me04984" wrote:
|
| Did you do the labels in Word first and them transfer them into
PUblisher?
| Or can you make a directory with labels right in Publisher?
|
| "Rob Giordano (Crash)" wrote:
|
| It worked for me. There's probably several other ways to do it,
but
given
| all the junk the teachers gave me...Word files, Wordperfect,
Excel,
| straight
| text, handwritten scraps of paper...blah blah blah. Starting off
fixing
| all
| that junk made sense to me in Excel.
|
| Set it up as a booklet in Pub and bring in each class's table of
names,
| the
| use pub to make everythang pretty.
|
| I probably did 8 like that and it worked fine. I could slap the
teachers
| though for not following my instructions.
|
|
| "melamb" wrote in message
| ...
| | Thanks for your help! It sure would be nice to keep it all in
| Publisher--not
| | sure it can be done, especially since I want it to print as a
booklet.
| I
| | can't set them up as labels, as was suggested by someone else,
and
| still
| | print a booklet. Your suggestion seems to be the only way to
get
it
| done
| and
| | I really appreciate your help!
| |
| | "Rob Giordano (Crash)" wrote:
| |
| | I got roped into doing several school directories. The way I
did them
| was
| | first in Excel so I could alphabetize them and also search for
dupes.
| Then
| | put the tables into Pub. and did all the pretty stuff in Pub.
Works
| great,
| | the only hard part was getting the information from the school
&
| | teachers...THAT nearly drove me nutso.
| |
| |
| |
| | "melamb" wrote in message
| | ...
| | |I am trying to create a school directory listing all families
in our
| | school,
| | | sort of like an address book. I would like to use the mail
merge
| feature,
| | | but can't figure out how to make the merge work. Every time
I
| merge
| | (whether
| | | in the preview or actual printing) it prints the first
listing in
| the
| | | database over and over, so that the first family is the only
family
| in
| the
| | | directory and none of the other families are included. The
second
| copy
| | | contains only the family listed second in my database, and
so
on.
| Please
| | | help!
| |
| |
| |
|
|
|
|
|