I don't know why, but do want to note that the address display for Contacts in Outlook has all of the address fields grouped in a "Home Address" "Business Address" and "Other Address"
It may be storing the information as street, city, province, postal code, etc, but I don't think so. I think that the mail merge function is parsing those details out of the larger single address field.
The records where the postal code appears like you second example, how does the address appear in that Contact in Outlook?
-steve
_________________
stephen boots Microsoft MVP 2004 - 2020
"Life's always an adventure with computers!"