Our COO has changed the settings to his contacts frequently. I understand
that if you change the setting from first (middle) last to company or last,
first, then the contacts will be displayed differently each time. However,
when you change the settings, it only applies to the new contacts you create,
it does not change the settings to the ones already there.
When he displays his contacts now they are scattered throughout in all
different order. Is there a way to make them all be the same sort without
him changing each one? Can you export to Excel, sort there and then import
them back in? I want to make sure this is done correctly because he cannot
lose all of his contacts.

Thanks for your help!

Please use the tool "ChangeNames"

http://www.marchert.de/software.html#cn

Peter

--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook


On 13 Feb., 13:43, TJAC wrote:
Our COO has changed the settings to his contacts frequently. I understand
that if you change the setting from first (middle) last to company or last,
first, then the contacts will be displayed differently each time. However,
when you change the settings, it only applies to the new contacts you create,
it does not change the settings to the ones already there.
When he displays his contacts now they are scattered throughout in all
different order. Is there a way to make them all be the same sort without
him changing each one? Can you export to Excel, sort there and then import
them back in? I want to make sure this is done correctly because he cannot
lose all of his contacts.

Thanks for your help!

This looks like it works great, except I can't get the contacts with a middle
initial to change correctly. It appears the middle initial is grouped with
the last name. I would like the last name to appear first in the display,
but it's either the first name or the middle initial that appears first.
I love this tool though!

"Peter Marchert" wrote:

Please use the tool "ChangeNames"

http://www.marchert.de/software.html#cn

Peter

--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook


On 13 Feb., 13:43, TJAC wrote:
Our COO has changed the settings to his contacts frequently. I understand
that if you change the setting from first (middle) last to company or last,
first, then the contacts will be displayed differently each time. However,
when you change the settings, it only applies to the new contacts you create,
it does not change the settings to the ones already there.
When he displays his contacts now they are scattered throughout in all
different order. Is there a way to make them all be the same sort without
him changing each one? Can you export to Excel, sort there and then import
them back in? I want to make sure this is done correctly because he cannot
lose all of his contacts.

Thanks for your help!

On 15 Feb., 15:52, TJAC wrote:
This looks like it works great, except I can't get the contacts with a middle
initial to change correctly. It appears the middle initial is grouped with
the last name. I would like the last name to appear first in the display,
but it's either the first name or the middle initial that appears first.
I love this tool though!

Hm, I`m not sure if I understand you. Can you give a little example or
send me a preview file?

Peter

--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook

For example, our COO has contacts such as John A. Smith. However, because of
the option he had when he created it, the contact was saved A Smith, John. I
can change it so it is listed as John A Smith, but cannot change it so it is
listed as Smith, John A. The A is always before the last name no matter what
I choose. Apparently he has too many like this and doesn't want to change
them all by hand.

"Peter Marchert" wrote:

On 15 Feb., 15:52, TJAC wrote:
This looks like it works great, except I can't get the contacts with a middle
initial to change correctly. It appears the middle initial is grouped with
the last name. I would like the last name to appear first in the display,
but it's either the first name or the middle initial that appears first.
I love this tool though!

Hm, I`m not sure if I understand you. Can you give a little example or
send me a preview file?

Peter

--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook

On 15 Feb., 18:02, TJAC wrote:
For example, our COO has contacts such as John A. Smith. However, because of
the option he had when he created it, the contact was saved A Smith, John.. I
can change it so it is listed as John A Smith, but cannot change it so it is
listed as Smith, John A. The A is always before the last name no matter what
I choose. Apparently he has too many like this and doesn't want to change
them all by hand.

Ok, thank you.

I guess he typed in the names in another order as the settings
expected it.

You can check this if you click on the button "Name...". If I´m right
the "A." will not be in the field "Middle Name" but in the Field
"Suffix".

However I´m right or not, this issue cannot be fixed only with
"ChangeNames". Please use "EditContacts" to exchange the fields
"Middle Name" and "Suffix". After that you should be able to get the
desired order with "ChangeNames".

"EditContacts" http://www.marchert.de/software.html#ec

Peter

--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook