Use Case

How to Build a Local Business Mailing List for Direct Mail

Export Bing Maps listings by category and area to Excel or CSV, split the Address column into street, city, state and ZIP, remove rows without a full street address, then run the list through CASS-certified address software before printing. Address mail to the business, or to a role such as Owner, since listings don't name people.

Quick Answer: Export Bing Maps listings by category and area to Excel or CSV, split the Address column into street, city, state and ZIP, remove rows without a full street address, then run the list through CASS-certified address software before printing. Address mail to the business, or to a role such as Owner, since listings don't name people.

Why maps data suits mail

Every listing is a place, and most have a street address. That's the one contact field direct mail needs. You don't need the Premium email feature for this, so the free plan's 10 leads a day of listing data covers a test mailing.

Split the Address column

The export has one Address column, for example: 1000 E 5th St Ste 110, Austin, TX 78702.

  1. In Excel, use Data > Text to Columns, split by comma. You get street, city, and "TX 78702".
  2. Split the last column by space to get state and ZIP.
  3. Check rows where the split produced too many or too few columns, such as addresses with an extra comma.

Drop rows you can't mail

  • No street address: businesses that serve customers at their location may show only a city. Drop them or find the address on their website.
  • Duplicates: dedupe on ID, then on the full address plus name. Several businesses can share a building, so don't dedupe on address alone.
  • Location pages of chains: decide whether to mail each branch or the head office.

Standardize before you print

USPS publishes guidance on getting and maintaining address lists for business mail. CASS-certified software standardizes addresses and adds ZIP+4 codes, which you'll need if you want automation postage rates. Many mail houses and print vendors run this for you.

Rules for postal marketing

  • US: CAN-SPAM covers commercial email, not postal mail. Keep a suppression list anyway and honor requests to stop mailing.
  • UK: postal marketing to individuals, including sole traders, falls under UK GDPR rather than the electronic marketing rules, so you need a lawful basis and must honor objections.

Premium has no daily cap if you mail a whole city.

Frequently Asked Questions

Does the export include contact names for mail?

No. Listings name the business, so address mail to the business or a role such as Owner.

Do I need Premium for direct mail?

No. Addresses are listing data. Premium only adds daily volume plus emails and social profiles.

Does CAN-SPAM apply to postcards?

No. CAN-SPAM covers commercial email. Other rules may apply, so keep a do-not-mail list.