View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merging Data from a Quote Sheet to a Letter in Word

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?