NewDeal Hot Tip 1306
NewFileFirst 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 labelmailing 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.
Last Modified 2 Mar 1999