Word Field Merge with Excel

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
Thu Jan 06 12:50:10 CST 2005

Eduardo was telling us:
Eduardo nous racontait que :

> 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.

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?
--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Eduardo
Thu Jan 06 13:27:03 CST 2005

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

"Jean-Guy Marcil" wrote:

> Eduardo was telling us:
> Eduardo nous racontait que :
>
> > 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.
>
> 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?
> --
> Salut!
> _______________________________________
> Jean-Guy Marcil - Word MVP
> jmarcilREMOVE@CAPSsympatico.caTHISTOO
> Word MVP site: http://www.word.mvps.org
>
>
>
>

Jean-Guy
Fri Jan 07 10:50:07 CST 2005

Eduardo was telling us:
Eduardo nous racontait que :

> 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.
>

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.

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