[hrokeh]

Can someone tell me if it is possible to have excel formulas "talk" to a word
document? I work in a law office and I want to be able to have one excel
spreadsheet "talk" to 2 different word docs. What I'm trying to do is this-
instead of retyping the same information when I'm making new file labels and
index cards, I'd like to enter the information once in a spreadsheet or word
doc and have it copy over to labels and index cards, so all I have to do is
print. I've been using the insert field in word to copy information, but it
doesn't work between two word documents. I've also tried it by mail merging,
but it is not time-efficient. Anyone know of an easy way to do this? I'd
appreciate any help or suggestions. Thanks!

[Graham Mayor]

For file labels and index cards mail merge is the only practical solution.
Once you have created the main merge document it can be saved for next time
and merged with a new set of data.

As for copying data between two documents, investigate the includetext
field, and for inserting Excel formulae investigate pasting links.

--

Graham Mayor - Word MVP

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



hrokeh wrote:
Can someone tell me if it is possible to have excel formulas "talk"
to a word document? I work in a law office and I want to be able to
have one excel spreadsheet "talk" to 2 different word docs. What I'm
trying to do is this- instead of retyping the same information when
I'm making new file labels and index cards, I'd like to enter the
information once in a spreadsheet or word doc and have it copy over
to labels and index cards, so all I have to do is print. I've been
using the insert field in word to copy information, but it doesn't
work between two word documents. I've also tried it by mail merging,
but it is not time-efficient. Anyone know of an easy way to do this?
I'd appreciate any help or suggestions. Thanks!

[hrokeh]

Thank you for responding- do you know anything about macros? Would those work
in this case?

"Graham Mayor" wrote:

For file labels and index cards mail merge is the only practical solution.
Once you have created the main merge document it can be saved for next time
and merged with a new set of data.

As for copying data between two documents, investigate the includetext
field, and for inserting Excel formulae investigate pasting links.

--

Graham Mayor - Word MVP

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



hrokeh wrote:
Can someone tell me if it is possible to have excel formulas "talk"
to a word document? I work in a law office and I want to be able to
have one excel spreadsheet "talk" to 2 different word docs. What I'm
trying to do is this- instead of retyping the same information when
I'm making new file labels and index cards, I'd like to enter the
information once in a spreadsheet or word doc and have it copy over
to labels and index cards, so all I have to do is print. I've been
using the insert field in word to copy information, but it doesn't
work between two word documents. I've also tried it by mail merging,
but it is not time-efficient. Anyone know of an easy way to do this?
I'd appreciate any help or suggestions. Thanks!

[Graham Mayor]

It's not a macro you want - it's a document template (or templates)
incorporating one or more of the features I have suggested. For file labels
and index cards, unless there is something you are not telling us, mail
merge is the way forward. Once you have that merge document set up, printing
is simply a matter of merging to the printer i.e. the one button click you
asked for. See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

--

Graham Mayor - Word MVP

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



hrokeh wrote:
Thank you for responding- do you know anything about macros? Would
those work in this case?

"Graham Mayor" wrote:

For file labels and index cards mail merge is the only practical
solution. Once you have created the main merge document it can be
saved for next time and merged with a new set of data.

As for copying data between two documents, investigate the
includetext field, and for inserting Excel formulae investigate
pasting links.

--

Graham Mayor - Word MVP

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



hrokeh wrote:
Can someone tell me if it is possible to have excel formulas "talk"
to a word document? I work in a law office and I want to be able to
have one excel spreadsheet "talk" to 2 different word docs. What
I'm trying to do is this- instead of retyping the same information
when I'm making new file labels and index cards, I'd like to enter
the information once in a spreadsheet or word doc and have it copy
over to labels and index cards, so all I have to do is print. I've
been using the insert field in word to copy information, but it
doesn't work between two word documents. I've also tried it by
mail merging, but it is not time-efficient. Anyone know of an easy
way to do this? I'd appreciate any help or suggestions. Thanks!