Reply
 
Thread Tools Display Modes
  #1   Report Post  
Village Idiot Dan
 
Posts: n/a
Default Create multiple documents from one and vice versa

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?



  #2   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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?




  #3   Report Post  
Village Idiot Dan
 
Posts: n/a
Default

Got it - thanks, saw catalog but didn't know what it did. 4 minutes til
hometime but will have a look first thing tomorrow! Dan

"Suzanne S. Barnhill" wrote:

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?





  #4   Report Post  
Graham Mayor
 
Posts: n/a
Default

Hmmm! I suspect that individual form letter may be closer to what is
required, in which case see
http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Suzanne S. Barnhill wrote:
What you want is called a "catalog" merge in Word versions through
Word 2000, "directory" in Word 2002 and 2003.


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



  #5   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Perhaps I misread this, but I thought he had 30 records he needed to merge
to a single page.

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

"Graham Mayor" wrote in message
...
Hmmm! I suspect that individual form letter may be closer to what is
required, in which case see
http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Suzanne S. Barnhill wrote:
What you want is called a "catalog" merge in Word versions through
Word 2000, "directory" in Word 2002 and 2003.


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






  #6   Report Post  
Graham Mayor
 
Posts: n/a
Default

I can see where you are coming from, but I thought he wanted 30 forms from
30 records?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Suzanne S. Barnhill wrote:
Perhaps I misread this, but I thought he had 30 records he needed to
merge to a single page.


"Graham Mayor" wrote in message
...
Hmmm! I suspect that individual form letter may be closer to what is
required, in which case see
http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Suzanne S. Barnhill wrote:
What you want is called a "catalog" merge in Word versions through
Word 2000, "directory" in Word 2002 and 2003.


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



  #7   Report Post  
Hood
 
Posts: n/a
Default Create multiple documents from one and vice versa

I can't find anything about this in Word 2003, did you say to search on
"directory" merge ??
Ta

"Suzanne S. Barnhill" wrote:

Perhaps I misread this, but I thought he had 30 records he needed to merge
to a single page.

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

"Graham Mayor" wrote in message
...
Hmmm! I suspect that individual form letter may be closer to what is
required, in which case see
http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Suzanne S. Barnhill wrote:
What you want is called a "catalog" merge in Word versions through
Word 2000, "directory" in Word 2002 and 2003.


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





  #8   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default Create multiple documents from one and vice versa

Yes. If you search for "directory merge" in Word 2003, one of the hits will
be "Create a directory of names, addresses, and other information." This
explains how to do it. Both "directory" and "catalog" (in earlier versions)
refer to common uses of this type of merge (any merge where you need to
insert data from numerous records continuously, rather than one per page as
in form letters, envelopes, labels, etc.), but of course it can be used for
any type of merge with this requirement. Note, however, that any static text
you put on the page will be repeated for each record, so any titles or
headings that apply to the entire document need to be either placed in a
First Page Header or added after the merge is complete.

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

"Hood" wrote in message
news
I can't find anything about this in Word 2003, did you say to search on
"directory" merge ??
Ta

"Suzanne S. Barnhill" wrote:

Perhaps I misread this, but I thought he had 30 records he needed to

merge
to a single page.

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

"Graham Mayor" wrote in message
...
Hmmm! I suspect that individual form letter may be closer to what is
required, in which case see
http://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Suzanne S. Barnhill wrote:
What you want is called a "catalog" merge in Word versions through
Word 2000, "directory" in Word 2002 and 2003.


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





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:39 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"