How can our Marketing department print mailing labels from the contact information?

Environment:

Analytics, Exporting address data

Resolution:

It is not possible to directly output address data into a format that can be directly printed to mailing labels. However, you can create a custom report to export contact or organization addresses with each address in a single row. You can then convert the format into mailing labels in another application.

Create a custom report that includes output columns for the contact or organization name, address, city, state, and zip code. With contact records, the address fields are in the Contacts table. For organization records, you must join the Organization Addresses table to the Organization table so that you can include a filter to specify which type of address (Billing or Shipping) to use.

When you generate the report, export the data to Excel or in a .csv format. From Excel or other spreadsheet program, you should be able to do a mail merge to format the addresses into a mailing label format.