Deleting all Country Fields for all Contacts

M

MXCagg

Hello and thank you inadvance.
Everytime I try to perform a mail merge with Word and use address fields,
the Country is inserted instead of the zip code even though I check "do not
insert country." I use Outlook 2007.

I would like to delete all of the data in the Country fields for all of my
contacts as I do not have anyone outside of the United States.
 
D

Diane Poremsky [MVP]

It may get added back - I'd export contacts to excel format and see what
field the country is in and if the zip code fields are all populated. I'd
also review the merge fields and use the individual fields (called street,
city, state, zip), not the 'mailing address' block.

you would either need to do the export to excel, delete the field, delete
the contacts, import or do it with VBA. See outlookcode.com for code
samples.


--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
M

MXCagg

Thank you. I tried to add the fields seperateley and it still does not work.
some addresses do not have the zip code and the ones that do also include
the country. this is so frustrating, i never put the country in any of my
contacts information and Outlook just assumes that I want to use it so
everyone defaults to United States of America. I have to go in and manually
delete the country from 3 seperate address fields. This is turning what
could be a productive mail merge in to a complete hassle. And computers are
supposed to make things easier? Hah.

Diane Poremsky said:
It may get added back - I'd export contacts to excel format and see what
field the country is in and if the zip code fields are all populated. I'd
also review the merge fields and use the individual fields (called street,
city, state, zip), not the 'mailing address' block.

you would either need to do the export to excel, delete the field, delete
the contacts, import or do it with VBA. See outlookcode.com for code
samples.


--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


MXCagg said:
Hello and thank you inadvance.
Everytime I try to perform a mail merge with Word and use address fields,
the Country is inserted instead of the zip code even though I check "do
not
insert country." I use Outlook 2007.

I would like to delete all of the data in the Country fields for all of my
contacts as I do not have anyone outside of the United States.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top