R
Rob Giordano \(Crash\)
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
| 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
| >
| >
| >
| >
| >
| > | > |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.
| > | > > >
| > | > > >
| > | > > > | > | > > > | 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.
| > | > > > | >
| > | > > > | >
| > | > > > | >
| > | > > > | > | > | > > > | > |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!
| > | > > > | >
| > | > > > | >
| > | > > > | >
| > | > > >
| > | > > >
| > | > > >
| >
| >
| >
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
| 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
| >
| >
| >
| >
| >
| > | > |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.
| > | > > >
| > | > > >
| > | > > > | > | > > > | 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.
| > | > > > | >
| > | > > > | >
| > | > > > | >
| > | > > > | > | > | > > > | > |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
| > 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!
| > | > > > | >
| > | > > > | >
| > | > > > | >
| > | > > >
| > | > > >
| > | > > >
| >
| >
| >