Invalid Use of Null Error

If you're encountering "Invalid Use of Null" errors the cause may be a blank contact listed in the contact data. This blank contact gets created when a staff member goes to add a new contact and immediately cancels the action. If this happens we want to remove the blank contact to eliminate any errors the blank contact may be causing.

blankcontact.png

If you see a blank contact listed above (Unspecified) you will want to remove it. The best way to remove it is to merge the blank contact into (Unspecified) using the Move Contact Information Tool.

BlankContact02.png

You can find the Move Contact Information tool listed under Contact > Move Contact Information.

BlankContact03.png

This is the Move Contact Data screen. It will allow you to merge information from the contact in the top field into the contact listed in the bottom field.

BlankContact04.png

We want to merge the blank contact into unspecified. So we're going to select the blank contact in the top field.

BlankContact05.png

We will select the (Unspecified) contact in the bottom field.

BlankContact06.png

Once we've selected the correct contacts we'll select the "Delete the old contact, after moving the data" check box and click OK

BlankContact07.png

Office Tools Pro will prompt you to confirm the merge and delete. Once you hit yes the blank contact will be gone. You may need to refresh the contact list; this can be done by searching for any contact in the Search box.