MailingLabel ( fname ; lname ; company ; addr1 ; addr2 ; city ; state ; pcode )

Outputs clean mailing label format from address info

Average rating: 4.7 (23 votes) Log in to vote

Jim Mitchell - Show more from this author
https://jimmitchell.org

Sample input:

MailingLabel ( "John" ; "Doe" ; "Acme Widgets" ; "123 Main" ; "" ; "Anytown" ; "CA" ; "92000" )

Sample output:

John Doe
Acme Widgets
123 Main St
Anytown, CA 92000

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let ( 
[
	n	= Substitute ( fname & " " & lname ; "¶" ; "") ;
	c	= Substitute ( company ; "¶" ; "") ;
	a1	= Substitute ( addr1 ; "¶" ; "") ;
	a2	= Substitute ( addr2 ; "¶" ; "") ;
	csp	= Substitute ( city & Case ( not IsEmpty ( city ) ; ", " ) 
			& state & Case ( not IsEmpty ( state ) ; "  " ) 
			& pcode ; "¶" ; "") 
] ;

	List ( n; c; a1; a2; csp )

)

A simple mailing label for use on invoices or other letterhead that removes any stray pilcrow characters, and concatenates city, state and postal code on one line.

Using the list() function, any var that is empty will not be included in the output, thus preventing a blank line from printing in the label.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

MailingLabel ( fname ; lname ; company ; addr1 ; addr2 ; city ; state ; pcode )

Comments

Support this website.

Support this website.