K
Kory Hagler
I am trying to merge about 300 photos in .jpg format along with the names
that go with them into a Word table. The photos are named with numbers that
correspond to Student ID's at an elementary school. The data source is an
Excel file with the following info:
Grade (K-6)
Teacher (2 teachers per grade)
Student's First Name
Student's Last Name
name of the image file
In the yearbook, we want to have the 8.5x11 booklet set up like this:
I need the morning Kindergarten teacher and kids on one page, the afternoon
Kindergarten teacher and kids on the next page, then the 1st graders from
teacher X on next page and then the 1st graders from teacher Y on another
page all the way through 6th grade (each grade has 2 different classrooms).
I was trying to do this in Microsoft Publisher v2002, but not having any
luck. I think Word 2002 has a better Merge feature.
Here is what I posted in the Publisher newsgroup so that you have some
background info:
=====================================
The Principal of my children's grade school has asked me to put together
a
yearbook/annual for the K-6th grades. Does anyone have experience doing
this using Microsoft Publisher? I've got versions 2000 and 2002 but didn't
find any kind of ready-made templates that I could customize. The booklet
will be 48 pages, printed back-to-back with black ink and saddlestitched. I
will be doing all the layout and then taking the file to the commercial
printer to print out and assemble the booklets.
This past summer, I created a children's theater program that had
pictures
of the kids along with their name and character they played under their
picture; it also had advertisements from local businesses. Biographies were
also included in another section of the program. I've made tables in Word
and inserted pictures in the cells and that turned out very nice. When I
tried using tables in Publisher 2000, I wasn't able to get as specific as
to the size of the cells like I could in Word. What I ended up doing for
the theater program was creating the majority of it in Publisher and then
linking Word files that had the photos, names & characters (set up like a
contact sheet or index print).
Anyway, what would you suggest as the way to go about setting up this
project? There are over 300 kids and faculty to work with. I'm beginning
to wonder why I said 'Yes'.
===================================
Thanks for any direction you can give me.
Kory
that go with them into a Word table. The photos are named with numbers that
correspond to Student ID's at an elementary school. The data source is an
Excel file with the following info:
Grade (K-6)
Teacher (2 teachers per grade)
Student's First Name
Student's Last Name
name of the image file
In the yearbook, we want to have the 8.5x11 booklet set up like this:
I need the morning Kindergarten teacher and kids on one page, the afternoon
Kindergarten teacher and kids on the next page, then the 1st graders from
teacher X on next page and then the 1st graders from teacher Y on another
page all the way through 6th grade (each grade has 2 different classrooms).
I was trying to do this in Microsoft Publisher v2002, but not having any
luck. I think Word 2002 has a better Merge feature.
Here is what I posted in the Publisher newsgroup so that you have some
background info:
=====================================
The Principal of my children's grade school has asked me to put together
a
yearbook/annual for the K-6th grades. Does anyone have experience doing
this using Microsoft Publisher? I've got versions 2000 and 2002 but didn't
find any kind of ready-made templates that I could customize. The booklet
will be 48 pages, printed back-to-back with black ink and saddlestitched. I
will be doing all the layout and then taking the file to the commercial
printer to print out and assemble the booklets.
This past summer, I created a children's theater program that had
pictures
of the kids along with their name and character they played under their
picture; it also had advertisements from local businesses. Biographies were
also included in another section of the program. I've made tables in Word
and inserted pictures in the cells and that turned out very nice. When I
tried using tables in Publisher 2000, I wasn't able to get as specific as
to the size of the cells like I could in Word. What I ended up doing for
the theater program was creating the majority of it in Publisher and then
linking Word files that had the photos, names & characters (set up like a
contact sheet or index print).
Anyway, what would you suggest as the way to go about setting up this
project? There are over 300 kids and faculty to work with. I'm beginning
to wonder why I said 'Yes'.
===================================
Thanks for any direction you can give me.
Kory
