Contact info

The default name can be changed in the Options, General and change the name there. You can on a document by document basis get more information including change of name by right clicking on the name presented in INFO and then choose Edit Property. This will present you with a small dialogue box. Click on the Verify Contact and the name will be underlined (if you have some kind of instant messaging like Skype installed) and the data filled in for that profile will be used...name, address, telephone etc.

I haven't found a way to make this permanent though.

Hi Hansemand,

Excel has 'Built In' and 'Custom' Document Properties. There is no 'Built In' Property for Phone or eMail. In the attached file, I put sample phone and eMail in the 'Comments' Bulit In Property. A 'Custom' Property could be created for each of those items. The file must be SAVED to make any changes permanent.

The complete code follows which includes sample routines to 'Add' a Custom Property, 'Delete' a Custom Property, Change the value of an existing 'Bulit In' or 'Custom' Property, and Display of all properties.

There is information about how to access VBA inside the sample file.

In an ordinary code module such as Module1:

Please Login or Register  to view this content.

Lewis

The odd thing about the author property is that if you click under the author and add another person, all the details for contact can be added for that contact but you can't make that the default without code

I never had version 2003 so can't comment on that. It appears that on my computer, when a contact name is added, that data goes into a folder under my user name called Contacts. It also seems to be related somehow to the contacts in instant messaging like Skype.

To me, it is a total mess.