A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merge, Excel and Word template



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2005, 09:04 PM
gman
external usenet poster
 
Posts: n/a
Default 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  
Old April 21st, 2005, 08:26 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create & merge specific data base & master documents? maggiev New Users 2 January 13th, 2005 12:30 AM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 6th, 2005 12:23 AM
Merge data from Excel into different docs in one Word file sue_w1231 Mailmerge 1 November 16th, 2004 01: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 02:30 AM


All times are GMT +1. The time now is 06:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.