Welcome to Forums Sign in | Join | Help | Forums
in Search


Exporting international addresses for mailings

Last post 09-24-2003 8:13 AM by Barbara McIntyre. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-23-2003 6:56 AM

    Exporting international addresses for mailings

    How do the rest of you deal with sending address data to mailing houses?

    Following the instructions of my predecesor, I exported Address Line 1, 2, ..., Town, County, Postcode, Country as a CSV file - this was fine for UK addresses, but having now configured the International address formats, I can't find a way of exporting them in such a way the mailing house could just put the lines of the address (what ever they comprise of) onto a mailing.

    Am I missing something obvious, or does no-one use the International formats?? Tongue Tied
    Filed under:
  • 09-23-2003 3:35 PM In reply to

    Exporting international addresses for mailings

    Have not used myself; but I remember from training. Go to the BB web site under Support>Knowledgebase>Open Solution ID and enter BB55941 for the article on how to do through configuration by the Administrator. Best to go to the Universal Postal Union link in article and go to Resources> >Addressing>Postal addressing system in member countries to determine the correct (sample) format. Be sure country is populated in Bio1 of Constituent Record. Follow Configuration instructions in the KB article. Has to be done for each country that has unique formatting. Then the mail functions should be standard like for the domestic US. Hope this helps.
  • 09-24-2003 8:13 AM In reply to

    Exporting international addresses for mailings

    We spent considerable time setting up all our international addresses according to the preference of the country and post office. Each one may be different as to where the postal code appears (before or after the city), etc. Exporting just the fields doesn't keep the format you have chosen. The only thing that does is the Address Block. However, when sending this information to the mail house, it is one long field. If your mail house doesn't have a problem with that, fine. But ours didn't want to work with that. Our mail house also wasn't processing foreign addresses correctly. They would leave off the 3rd address line, which some addresses had, or leave off the postal code - thus mail was being returned to us. We've decided to process foreign ones on our own so we know they are done right. Barbara McIntyre Philadelphia Biblical University 200 Manor Ave Langhorne PA 19047 215-702-4394 [Email Removed]
Page 1 of 1 (3 items)