Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

Merge, Excel and Word template

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gman - 20 Apr 2005 21:04 GMT
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
Peter Jamieson - 21 Apr 2005 08:26 GMT
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 A2:D3 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

> 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 /
[quoted text clipped - 10 lines]
>
> gman
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.