Can anyone tell me if there is a way (and how to do it) to create a spread
sheet in Excel and then have the information in the cells merged / imported
into a
Word template at different places? In other words, 'cell A1' in the spread
sheet would go to one place in the Word template while 'cell B1' would go to
another place in the same template. (Or, maybe there is a way to create a
table in Word to do the same thing.)

Thanks,

gman

As long as all the data comes from a single row in Excel, you can use Word
mail merge. If you are producing multiple documents from your Excel sheet,
where the data for each document comes from each row in the sheet, you can
also use mail merge. However, if you want to plug info. from (say) cells A2,
C9, and F37 into your Word document, you need to use a different approach.

For mail merge, what you need to do is create an Excel sheet where the first
row contains a name for each column, and dthe data is in rows 2, 3 etc. Then
you use Word|Tools|Letters and Mailings|Mail Merge and follow the wizard.
It's probably easier if you try that and ask for more help if you need it.

To use the other approach, create your document, then for each place where
you need some information from the Excel sheet, you can either
a. use Word Insert|File to select the spreadsheet, but instead of inserting
the whole sheet, use the Bookmark button in the file open dialog to specify
the cells to insert (you either need A23 type notation or R2C1:R3C4 type
notation). Then click on the drop-down arrow on the Insert button and pick
Insert and Link. You may then be asked to choose the file format - look for
an Excel option. If it isn't there, you do not have the necessary Excel
converter and this method will not work)
b. open your Excel sheet in Excel, select the cell(s) you need, Edit|Copy,
then Edit|Paste Special in Word to insert the data in the format you need,
making sure you insert a link. You should end up with a { LINK } field (use
Alt-F9 to have a look). Once you have inserted one, in my experience it
should be possible to copy the field and change the link details - however,
I believe in principle you are supposed to insert each link separately.

Peter Jamieson

"gman" wrote in message
...
Can anyone tell me if there is a way (and how to do it) to create a spread
sheet in Excel and then have the information in the cells merged /
imported
into a
Word template at different places? In other words, 'cell A1' in the
spread
sheet would go to one place in the Word template while 'cell B1' would go
to
another place in the same template. (Or, maybe there is a way to create a
table in Word to do the same thing.)

Thanks,

gman