NewDeal Hot Tip 1306

[Hot Tips for...] NewFile

NewFile Mailing Labels

Here is my solution for making a mailing label in NewFile so that it could have a 1 or 2 line address.

First go to Page Setup and set paper size to 8.5 x 11 in., then set top, bottom, left and right to 0. next set width to 2.75 and height to 1 inch.

Listed below are the fields and what the represent.

Field1 = first name
Field2 = last name
Field3 = address line 1
Field4 = address line 2
Field5 = city
Field6 = state
Field7 = zip code
Field8 = mailing label
mailing label is a computed field. Set Expression on screen to look like this.
Field1 &"_"& Field2 &"
"& IF(LENGTH(Field4 &"_")>1,Field3  &"
"& Field4,Field3) &"
"& Field5  &",_"& Field6 &"__"& Field7
_ = a space. Remember not to put a space in Field4 or it will give you a 4 line address label.

The computed field will give you either a 3 or 4 line label and can be used as a sheet of labels or reset page size for an envelope.

Return to Index

Last Modified 2 Mar 1999