State changes between abbrevation and word

Dana Burton

For our bulk mailings, we need the state to be exported as the two letter abbreviation. This shows correctly on my computer. However, on the lady's computer that this is her job, it shows as the word (Ohio instead of OH.) The partner relations manager also has it show as the word.

Now, each of us are viewing the same query that has been used for three years, and the same exports. I don't understand why we are viewing the same files differently.

This began happening to them a few months ago and the manager just told me about it today.

Does anyone have any ideas or theories on how to remedy this? TYIA!

Christine Robertson 4

@Dana Burton I know that there's a long and short code for the states and you can choose which you want to see in Export and Mail. Maybe the preferences are different?

I know that doesn't explain why it may have changed given that this Export has been used for some time, but I hope that you can just switch the format and fix it.

Joe Moretti 3

@Dana Burton That is because every user can set their views differently. In Query, go to Tools, User Options, Code Tables and you will see a place to display Code Tables as Short or Long Descriptions. BUT this will change all the code tables when you view them in Query

BUT ideally you should run your queries thru either RE MAIL or Export, where you have the options for state of using State Abbreviation or not.