You can edit a contact's information for the current worksheet, so that it is different than what is stored in the Contacts database. This feature also allows you to update your Contacts database when you receive a worksheet that has newer contact data.
-
Click
on the Standard toolbar.
-
In Worksheet Properties, click General on the left.
-
Click the
button beside one of the contact fields.
-
In the Edit Worksheet Contact... dialog, modify the contact information under This Worksheet's Copy.
If you make a mistake and want to copy the information from the Contacts database, click Copy from Database.
If you want to copy the information in the current worksheet to the Contacts database, click Save To Database. -
Click OK in the Edit Worksheet Contact... dialog.
-
In the Worksheet Properties dialog, click OK to save and close or Apply to save and keep the dialog open.