Duplicate record on each sheet

[Andy Holman]

I have a spreadsheet with 100 unique names. I.e:
A
B
C...

When I create labels, I have a page with a table, and each
table contains the address fields I want to print.
Besides the first record, each other cell of the table
also has a "next record" callout in it.

The problem is that sheet 1 is okay, but sheet 2 starts
all of the addresses again beginning with the 2nd record
in the spreadsheet.
So sheet one would start with "A, B, C..." and sheet 2
starts with "B, C, D...".

HELP!

 

[Doug Robbins - Word MVP]

You need to start this as a label type mailmerge. Sounds like to you
started with a form letter and tried to turn it into a label.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP