Configuring labels in a mail merge

[Ally at Anglo]

Using Word XP and Avery label 5164 (3.33" x 4") 6 per page . I need to use the top half of the label for our company return address and I need to print a mail merge'd customer address in the bottom half. Here's the problem: sometimes I have less than a multiple of 6 and end up with labels with the return address (top portion) already printed. Now I want to use those labels to print just the customer addresses in the bottom portion. How can I set up the merge form so the customer's address will print in the bottom portion of the label? I have tried to split the label "cells" and put the merge information in the bottom, but when I "update all labels" it puts the merge data in each sub-divided cell. In effect giving me 12 labels instead of the 6 I need.

 

[Doug Robbins - Word MVP]

Use an If ... then ... Else field to check for the existence of data in one
of the mergefields that will always have data and only have the company
return address included, if there is any data.

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

Using Word XP and Avery label 5164 (3.33" x 4") 6 per page . I need to use

the top half of the label for our company return address and I need to print
a mail merge'd customer address in the bottom half. Here's the problem:
sometimes I have less than a multiple of 6 and end up with labels with the
return address (top portion) already printed. Now I want to use those labels
to print just the customer addresses in the bottom portion. How can I set
up the merge form so the customer's address will print in the bottom portion
of the label? I have tried to split the label "cells" and put the merge
information in the bottom, but when I "update all labels" it puts the merge
data in each sub-divided cell. In effect giving me 12 labels instead of the
6 I need.