Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

What does an exported address file contain?

The data file for exported addresses contains field names that you can use in a form letter. For example, the First Name field inserts the first name of each person when you print copies of the letter.

These are the available fields:

  • Salutation The person's title (Mr., Ms., Dr., and so on).

  • First Name The person's first name.

  • M.I. The person's middle initial.

  • Last Name The person's last name.

  • Company Name The name of the person's company. Applies to customers and vendors only.

  • City The city name in the address. For a customer, the city name comes from the customer's billing address.

  • State The state in the address. For a customer, the state comes from the customer's billing address.

  • Zip The zip code in the address. For a customer, the zip code comes from the customer's billing address.

  • Country The name of the country listed for your company's legal address.

  • Contact The name of your main contact person with a customer or vendor.

  • Alt Contact The name of an alternate contact person with a customer or vendor.

  • Address A line in the person's or company's address. QuickBooks provides a separate field—Address 1 through Address 5—for each line in the address. For a customer, the address lines come from the customer's billing address.

  • Shipping Address A line in the customer's shipping address. QuickBooks provides a separate field—Shipping Address 1 through Shipping Address 5—for each line in the address.

  • Shipping City The city in the customer's shipping address.

  • Shipping State The state in the customer's shipping address.

  • Shipping Zip The zip code in the customer's shipping address.

  • Shipping Country If applicable, the country in the customer's shipping address.

A note about addresses

Some of the fields let you use parts of an address instead of the entire address. For example, you can use the City field to mention a person's city within a sentence. QuickBooks also provides fields for placing the full block address at the beginning of a letter.

KB ID# H_CUST_MAILMERGE_ADDRESS_CONTAINS
12/2/2016 4:21:07 PM
PPRDQSSWS406 9138 Pro 2017 4a1557