View Single Post
  #2   Report Post  
Monika Krug
 
Posts: n/a
Default

Assuming all the data of the member (like address, city)
is identically copied at the partner, do it like this:

firstname {NEXT} firstname lastname
address
city, state zip

So it uses the first name of the member, goes to the next
record, uses the first name, last name, address etc. of
the partner.

Do not type the { and }. Press Strg+F9 to create a field,
this shows as {}, then type NEXT in between. With Alt+F9
you can toggle between showing and hiding field code.

Alternatively, if you have the merge toolbar switched on,
click on Insert Word Field and select Next Record. When
Field codes are toggled off, this will show as Next
Record, when they are toggled on, it will show as {NEXT}.

Monika.

-----Original 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.


.