[Fuzzy]

i have 70 word docs.....and the data which has to be merged is in one excel
in 70 different rows..
is there any function that i can use where system will automatically check
for col A, and if the cell reference in col A matches the reference in the
word document, it will merge the remaining columns of the same reference.

for eg:
excel sheet contains
Col A Col B Col C
101 house 1,984
102 office 2,532
103 shop 2,100
104 house 1,984
105 house 1,984

i have different word documents which has reference of col A.
system should check the reference in the word - if its 101, then col B and
col C of 101 should be merged to this document.
it should then automatically open second word document. if its 102, then col
B and col C of 102 should be merged to this document...

can this be done?

[Doug Robbins - Word MVP]

That is not possible with mail merge. It could be done using VBA with a
combination and modification of the methods in the articles

"Find & ReplaceAll on a batch of documents in the same folder" at:

http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm

"Access a database and insert into a Word document the data that you find
there" at:

http://www.word.mvps.org/FAQs/InterD...DataFromDB.htm

"Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterD...XLFromWord.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Fuzzy" wrote in message
...
i have 70 word docs.....and the data which has to be merged is in one excel
in 70 different rows..
is there any function that i can use where system will automatically check
for col A, and if the cell reference in col A matches the reference in the
word document, it will merge the remaining columns of the same reference.

for eg:
excel sheet contains
Col A Col B Col C
101 house 1,984
102 office 2,532
103 shop 2,100
104 house 1,984
105 house 1,984

i have different word documents which has reference of col A.
system should check the reference in the word - if its 101, then col B and
col C of 101 should be merged to this document.
it should then automatically open second word document. if its 102, then
col
B and col C of 102 should be merged to this document...

can this be done?