If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge, Excel and Word template
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create & merge specific data base & master documents? | maggiev | New Users | 2 | January 12th, 2005 11:30 PM |
Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |
Merge data from Excel into different docs in one Word file | sue_w1231 | Mailmerge | 1 | November 16th, 2004 12:55 AM |
Word mail merge with Excel data | Peter Jamieson | Mailmerge | 1 | April 26th, 2004 07:30 PM |
Excel merge files that work like Word merge files | Rick | Worksheet Functions | 2 | October 30th, 2003 01:30 AM |