Configuring labels in a mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ally at Anglo - 26 May 2004 20:41 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 27 May 2004 07:10 GMT

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.

Signature

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.

Reply to this Message