NewDeal Hot Tip 1306
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.
Last Modified 2 Mar 1999
©2000 NewDeal Inc. All rights reserved
Eine Seite zurück |