Does Word have a syntax that allows to do this

Not really.

oder is there another way to
do it?

If /all/ your records are in pairs and Word reads them in correct sequence
(which is not guaranteed unless you specify a sequence in an Access query
and use that as the data source), you may be able to do soemthing. In the
simplest possible case where all the data except firstname is duppicated,
you might be able to use

firstnameNext record & fristname+1 lastname
address
city, state zip

If the data isn't duplicated, you could try something like

{ SET fn1 { MERGEFIELD firstname }
}{ SET ln1 { MERGEFIELD lastname }
}{ SET ad1 { MERGEFIELD address }
}{ SET ci1 { MERGEFIELD city }
}{ SET st1 { MERGEFIELD state }
}{ SET zi1 { MERGEFIELD zip }
}{ SET otherfield1 { MERGEFIELD otherfield }
} etc. then

{ NEXT }{ REF fn1 } & { MERGEFIELD firstname } { REF ln1 }
{ REF ad1 }
{ REF ci1 }, { REF st1 } { REF zi1 }

where all the {} are the special field braces you can insert using ctrl-F9.

However, if the situation is more complicatedd some records are paired and
some are not, I think you will have difficulty using { NEXT } to get the
result you want. Personally, I would consider pre-processing the Access data
in some way to create the records I really need for the merge.

Peter Jamieson





"Frank Spade" wrote in message
...
I have an access table with records of members and their partners. They are
next to each other in the table.

I want to print one address lable for each pair (to save postage) in the
form

firstname & fristname+1 lastname
address
city, state zip
skip 1 record

where firstname+1 is the supposed to be the reference to the firstname
field of the next record and skip 1 record indicates that one record
is
to be skipped to point to the next pair once one label is printed.

Does Word have a syntax that allows to do this oder is there another way
to
do it?

Thank you for any helpful advice.