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.
> > 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
[quoted text clipped - 12 lines]
> 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.
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
TJAC - 15 Feb 2007 19:30 GMT
That did it! Thanks for all your help! These downloads are great! They
have just saved us a lot of time. Thank you!
Trisha
> > 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
[quoted text clipped - 26 lines]
> Homepage: http://www.marchert.de
> Programming for Excel and Outlook
Peter Marchert - 15 Feb 2007 20:11 GMT
> That did it! Thanks for all your help! These downloads are great! They
> have just saved us a lot of time. Thank you!
> Trisha
Fine, I´m happy I could help you. Thanks for your feedback.
Peter
--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook
TJAC - 19 Feb 2007 17:51 GMT
I ran the tools on our COO's computer. Most of it worked great, the only
problem is now when you create a new email, click on the address book, change
to contacts, the Select Names doesn't necessarily follow what is in the
contacts. Some have initials first, others have first name listed first,
even though file as, display as and the name in the contacts are all correct
after running the tools.
We are assuming this is from dragging and dropping emails to contacts that
it is pulling the originators setup options.
The only way we can correct this is to create new contacts. Do you have any
suggestions for the Select Names to be displayed correctly?
Thanks again,
Trisha
> > 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
[quoted text clipped - 26 lines]
> Homepage: http://www.marchert.de
> Programming for Excel and Outlook
Peter Marchert - 19 Feb 2007 18:53 GMT
> I ran the tools on our COO's computer. Most of it worked great, the only
> problem is now when you create a new email, click on the address book, change
[quoted text clipped - 6 lines]
> The only way we can correct this is to create new contacts. Do you have any
> suggestions for the Select Names to be displayed correctly?
Did you checked the setting in "Tools", "E-mail Accounts", "View or
change existing directories or address books", "Change..."?
There you can set the address book view to "First, Last" or to "File
As".
Peter
--
Peter Marchert
[EDP-Service Marchert]
Homepage: http://www.marchert.de
Programming for Excel and Outlook