Brian Dunning's FileMaker Custom Functions

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   Jim Mitchell
https://jimmitchell.org

Share on Facebook Share on Twitter

  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)

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

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.