Look into the use of the { NEXT } field.



http://office.microsoft.com/en-us/wo...in=HA102110133

Mail Merge

Hi,
is it possible to do a merge field on the same word model document with each addresses taken from different excel file or same excel file but from different sheets, an example, in the same word document:

address 1 (take form file 1.xls or sheet1 of 1.xls)

address 2 (take from file 2.xls or sheet2 of 1.xls)

address 3 (take from file 3.xls or sheet3 of 1.xls)

thank you for any reply,

Patrick from Italy