Hi,
this is my problem, i need to put many addresses taken from a list (example excel) on the same page of a model. Those addresses are combined diffrently, i tried to insert merge field but this way only repeats the same address from the list.
So what i need to do is a model of document like below:



Dear xxx, street x

Dear yyy, street y

bla,bla,bla......bla:

Dear zzz, street z

Dear yyy, street y

where the name and the street address are taken from the same list (for example an excel list)
Thank you for any reply, sorry for my bad English,

Pat, from Italy.

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

A Word mailmerge can only use a single data source. In the case of Excel, that means a single contiguous range on a single worksheet in a single workbook.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]