Mailing Labels

M

Matthew

I am making mailing labels; I would like to skip the line "address2" if
there is no data on it. If there is data, I obviousally want to show it.

How is this done?

Matthew
 
P

PC Datasheet

Include Address2 in the query your labels are based on and include a textbox for
Address2 on your label. Go to design view for your label, select the Address2
textbox, open properties, go to the Format tab and set the can chrink property
to Yes. When you do this, the Address2 textbox will hrink to zero height when
their is no value for Address2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create custom labels from an csv file + Need items numerically counted out 0
ASK Field Formatting 1
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Blank Page After Envelope-Label Wizard 5
Duplicate Mail Merge Record Every Time 5
How to getting text labels to show up in scatter chart. 0
A way to mail merge from excel into a word label template? 0
Program buttons to create a word document 0

Top