How do I create a school directory in Publisher 2000?

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!

You can setup your page as if they were labels. Determine how many names you
want per page. In page setup. Assume each directory setting is 6.5 wide and 2
inches in height. Select custom in the page setup, type the numbers. There will
be one long label on your screen. Do the merge. When you go to print, adjust the
margins and gaps. If you use the sample numbers, you will type .5 top, 1 inch
side, zero gaps. This will put 5 directory listings per sheet.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/p...649111033.aspx

"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!

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!

Ok, except that I wanted it to print out as a booklet, so that the pages
would layout correctly and it could be stapled together. Is there a way to
do this?

"Mary Sauer" wrote:

You can setup your page as if they were labels. Determine how many names you
want per page. In page setup. Assume each directory setting is 6.5 wide and 2
inches in height. Select custom in the page setup, type the numbers. There will
be one long label on your screen. Do the merge. When you go to print, adjust the
margins and gaps. If you use the sample numbers, you will type .5 top, 1 inch
side, zero gaps. This will put 5 directory listings per sheet.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/p...649111033.aspx

"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!

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!

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!
|
|
|

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!
|
|
|

No, I created the listings in Excel as much as I could then brought the
tables into my Publisher design (Word tables don't cut it for me).


--

Rob Giordano
Microsoft MVP - FrontPage





"me04984" wrote in message
...
| 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!
| |
| |
| |
|
|
|

Lets say you have Name, address, phone #, email in columns in Excel. How do
you then get them into a format in Publisher where the name is the first
line, address on 2nd, phone on 3rd and email on 4th line? If you have a
thousand to do and don't want to copy and paste?

"Rob Giordano (Crash)" wrote:

No, I created the listings in Excel as much as I could then brought the
tables into my Publisher design (Word tables don't cut it for me).


--

Rob Giordano
Microsoft MVP - FrontPage





"me04984" wrote in message
...
| 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!
| |
| |
| |
|
|
|

In page setup, click special size, leave the 8.5 and type however large you
want the entry for your directory. Assuming you have an one inch margin all
around, divide the remaining space into one inch spaces. When you go to print
adjust the gaps by clicking the custom options.
This will take some tweaking but it works okay.

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

"me04984" wrote in message
...
Lets say you have Name, address, phone #, email in columns in Excel. How do
you then get them into a format in Publisher where the name is the first
line, address on 2nd, phone on 3rd and email on 4th line? If you have a
thousand to do and don't want to copy and paste?

"Rob Giordano (Crash)" wrote:

No, I created the listings in Excel as much as I could then brought the
tables into my Publisher design (Word tables don't cut it for me).


--

Rob Giordano
Microsoft MVP - FrontPage





"me04984" wrote in message
...
| 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!
| |
| |
| |
|
|
|