Multi mail merges to word from the same workbook

[teebird]

Hi Everyone

I have 3 sheets in the same workbook and I have set up 3 word documents that I want to mail merge from each sheet. But I keep getting errors. Is what I am trying to do possible in Excell/Word or do I have to create a seperate workbook for eash mail merge list in excel.

Thanks for the help.

Tee

 

[Jack in the UK]

Hi Mate Dreamboat is ourresident WordExpert sure she will guide you or others will, i dont merge tghis way no reason bar i hate Word, i fine i can di more faster and better via VBA, 3 sheets no problems, i save each excel files as each document from each of 3 templates,,, to a dir all in one on 3 dir whatever i need, also each doc has unique name like 1 Jck doc Mr X, 2 Jack Doc Mr y, 1 Jack Doc Mr Y and so on..

Run passed http://www.thewordexpert.com or if ive got her ulr incrooect profile dreamboat...