|
|
What you want is called a "catalog" merge in Word versions through Word
2000, "directory" in Word 2002 and 2003.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Village Idiot Dan" Village Idiot wrote in
message ...
My girlfriend's a teacher and you should see the gramatical beatings I
get!
Anywoo [it is a real word as I made it up myself], can anyone help pls. I
have a worksheet of, say, 30 rows of info in Excel that I need to fill in
a
single page form that is in Word. Now, IF it was a letter, i'd just mail
merge and then print out the resulting 30 page Word document. However, I
actually need to save each single page form in Word with the merged data
from
Excel. How would I do this, did anyone manage to stay awake?
Thanks in advance,
Dan
"BostonDocumentation" wrote:
Don't be such a baby. Everybody makes mistakes in typing, and there is
always
some smug passive-aggressive person out there just dying to show you up
by
pointing out your errors. Just ignore them.
Your question, I believe, has to do with conditional text. In other
words,
can you apply a "condition" to text that can be hidden or shown,
depending on
what you want to do with it? That way, you can have one document with
all the
information in it, and then show the information pertinent to Level 1
but not
Levels 2 and 3.
There are other packages out there that can do this, but I am having
trouble
finding out if Word can do this. Right now the only thing that I can
find
within Word is the ability to hide the font of a style (and then
everything
that uses that style disappears). This has problems, because it forces
you to
create multiple styles, each one specific to a particular Level, and
then
when you want to print that Level you have to unhide the fonts for those
styles.
But if your document uses minimal styles, say, 10 or less, this might be
the
best option for you.
"piddilin" wrote:
You're right about setting up a table would be too messy. The Mail
Merge idea goes way back to when I worked for a Congressman and we'd merge
different paragraphs depending on the person's opinion (and that's a fact).
Sor'ry you'are so easily offend'ed by my apostro'phe, I didn't know I would
be judged on my gram'mar. Also sorry you assume I'm not qualified to teach
Word; obviously you are a better judge than I am. Thanks, since I am very
new to newsgroups, for letting me know that I can expect to be judged on my
overall knowledge by €śthinking outside the box€ť. Next time don't bother
responding to my questions, if you please.
"Jezebel" wrote:
If your topics can each fit in a table row, you could have a column
for the
hand-out number (1, 2 or 3), and a column for the title. To create
your
master document, sort by title. To create the individual hand-outs
sort by
hand-out number and title. A bit messy, but presumably you don't
need to
update the whole shebang very often.
Intrigued to know how you could even think of using mailmerge for
this...the
mind boggles, indeed.
What exactly is it that you teach? (Not the use of apostrophes or MS
Word,
one hopes.)
"piddilin" wrote in message
...
I teach three levels of Word and each level has it's own printed
handout
of topics in alphabetical order. How might I create a document
containing
all three levels (topics combined in alphabetical order)? I have the
reverse
situation for Excel where I have one main document containing all
three
levels and would like to separate it out into three separate
handouts. Add
to that the fact that I only want to make changes once, not have to
make a
correction in both sets (main and level). I've thought of linking
but I
need to print the handouts, I've thought of Mail Merge but it
boggles the
mind, I've looked at Master Documents and that's more of a table of
contents/index. Got any suggestions?
|