Ensure that each label cell except the first label cell in the table in the
Word Mail Merge Main Document has a <<Next record>> field at the top. By a
label cell I mean a cell in the table that contains the mergefields for a
label (in some layouts, there are "spacer cells" that should not contain
anything).
There are various ways to do that but in this case it may be easiest to
a. clcik Alt-F9 to reveal the field codes (so they look like { MERGEFIELD
myfield }
b. put the insertion point at the beginning of the second label cell
c. use ctrl-F9 to insert a pair of the special field code braces {}
d. inside the braces, type NEXT
e. select the { NEXT } field, and copy and paste it into label cells 3, 4,
5 and 6 (or however many there are)
Peter Jamieson
"Lisa G" <Lisa G[ at ]discussions.microsoft.com> wrote in message
news:EB4AFB6C-E6B9-4E9A-855E-1C3B2350AD4A[ at ]microsoft.com...
[Quoted Text] >I am merging an excel spreadsheet into an existing label template. There
>are
> 6 labels up on a page. I get the same 6 names on the entire page instead
> of
> 6 different names per page....any help? thanks
|