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 / Programming / January 2005

Tip: Looking for answers? Try searching our database.

Word Field Merge with Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eduardo - 06 Jan 2005 18:14 GMT
Hello,

What procedure would I need to follow to have a field in MS Word import/fill
with values from MS Excel on a cell-by-cell basis (i.e. value from A1, A2,
A3, A4 etc.)

Your help would be greatly appreciated.

Ed
Jean-Guy Marcil - 06 Jan 2005 18:50 GMT
Eduardo was telling us:
Eduardo nous racontait que :

> Hello,
>
[quoted text clipped - 3 lines]
>
> Your help would be greatly appreciated.

A simple way:
Select the cell in Excel, Copy.
Go to Word, place the cursor, do Edit > Paste Special > With links.

Is that what you were looking for?
Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Eduardo - 06 Jan 2005 19:27 GMT
Thanks Jean for your immediate response.  Greatly appreciated it.

To further clarify, (and perhaps some background will help...)
The Excel file is my data source for mortgage #.  I am looking to "merge"
each unique mortgage # (stored in A2, A3, A4 etc, respectively) in a table in
Word, and to display  different mortgage numbers in a seperate row.

Your help in this matter is again appreciated.

Ed  

> Eduardo was telling us:
> Eduardo nous racontait que :
[quoted text clipped - 12 lines]
>
> Is that what you were looking for?
Jean-Guy Marcil - 07 Jan 2005 16:49 GMT
Eduardo was telling us:
Eduardo nous racontait que :

> Thanks Jean for your immediate response.  Greatly appreciated it.
>
[quoted text clipped - 5 lines]
>
> Your help in this matter is again appreciated.

Do a catalogue (or Directory) type of merge using ony clolumn A from Excel
as the database source.
When you create the merge document, use a once cell table to put the
mergefield.
After the merge, you should end up with a one column table, each row
containing info from each cell of the A column in Excel.

Whenever you change the database, redo the merge to have an updated version
of the informatin in the merged document. (And discard the previously merged
document, or keep it as an archive...)

If you want a truely interactive document, I think you will have to manually
insert each field as I suggested in my previous post.
Maybe someone will drop by with an easy way to do this...
One way would be to copy-paste special (with link) the whole Excel range
(A2:Axx) in Word, this will be fine as long as you do not add records in the
Excel range of cells.

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

 
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.