See "ParseAddress" query in WIPNCOA.zip
See "ParseAddress" query in WIPNCOA.zip
I said it was untested. The compiler gives an obvious error about what is wrong with the statement.
Resolved with help by theDBguy who originated the VBA
see ExtractData module and ParseAddress query.
NCOA.zip