how do you tie excel formlas to word?

[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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[hrokeh]

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

 

[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_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>