View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Fuzzy Fuzzy is offline
external usenet poster
 
Posts: 4
Default Merging from one excel to multiple word docs

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?