[Doug Robbins - Word MVP]

You should probably take a look at the following series of articles, the
last in particular:

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Elly" wrote in message
...
Wow Peter, you really know your stuff.

It's a little task I've been given as the IT geek within our company.

Basically, I have a spreadsheet which guys fill in (as a quote to another
company) I then need various pieces of information i.e. customers name and
address, cost etc. to then be automatically tranferred to a letter in a
word
document. My issue is that new quote sheets will be raised (from the
standard) and I don't think that with a new quote sheet the info can be
transferred without redirecting word to look in the right place. Of
course I
could be completely wrong so therefore bow down to your infinite wisdom.

Thanks

Elly

"Peter Jamieson" wrote:

Are you trying to get information from specific cells? (the sort of thing
you might do using copy/paste from Excel into Word?)

Or are you trying to get information from a table within Excel (Where you
might be mailmerging from Excel to Word?)

If it's "specific cells", then yes, if the cell locations move around,
you
wil have difficulty extracting the information unless you are able to
ensure
that the relevant cells are always identified using the same Range names
in
Excel. The trouble is that whoever prepared the Excel sheet in Excel
would
have to know how to do that.

If it's "table and mailmerge", then you should be OK as long as the
column
names do not change, and even then it's a question of re-linking to the
Excel sheet and altering your Word document to match.

If you are trying to automate this kind of stuff it's important to ensure
that whatever you implement puts the values you want to re-use in known
places where other applications always know how to get them - i.e. some
overall system design is needed.

Peter Jamieson
"Elly" wrote in message
...
I'm trying to lift information from a quote sheet in Excel to appear in
a
letter in word - is this possible given that the sheet would change
with
every new quote?