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.