International address formatting in Donor Stewardship reports

Follow

1. Review the Donor Stewardship Report for any donors with international addresses.

2. Cut and paste the international addresses onto a new Excel spreadsheet.

3. Identify the countries you need to send letters to and visit the following website: http://www.upu.int/en/activities/addressing/postal-addressing-systems-in-member-countries.html

4. Search for the first country by using the drop-down and clicking “Display” at the top of the page:

5. A new window will open with the approved format:

6. Review format. Then copy and paste fields from the Excel file to the appropriate location on the Word document.

7. Repeat steps 3-6 as needed to obtain the correct mail format for donors with international addresses.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk