D deekras Registered User. Local time Today, 12:56 Joined Jun 14, 2000 Messages 169 Oct 30, 2001 #1 I receive a file every morning with addresses. the state is written out, not in the state postal abbreviations. i am looking for a macro to change the state from "Virginia" to "VA". any suggestions?
I receive a file every morning with addresses. the state is written out, not in the state postal abbreviations. i am looking for a macro to change the state from "Virginia" to "VA". any suggestions?
R Rich_Lovina Registered User. Local time Today, 23:56 Joined Feb 27, 2002 Messages 224 Oct 30, 2001 #2 Create an update query for each statename you wish to shorten, and then run each query through a macro called say ShortState.
Create an update query for each statename you wish to shorten, and then run each query through a macro called say ShortState.
D deekras Registered User. Local time Today, 12:56 Joined Jun 14, 2000 Messages 169 Oct 30, 2001 #3 thanks! that makes sense, but i was hoping to get a quicker way, in 1 macro. but this will work.
