Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging from one excel to multiple word docs
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Multiple Docs in Word using color-coding | Microsoft Word Help | |||
Merging multiple MS Word documents into a MS Excel Worksheet frame | Microsoft Word Help | |||
Merging excel into word docs | Microsoft Word Help | |||
Merging multiple rows in Excel to one word document. | Mailmerge | |||
Multiple docs open multiple words | New Users |