How to make batch changes to previously entered contacts

  • Thread starter Thread starter Casebase
  • Start date Start date
C

Casebase

I've got about 2000 contact items and I want to make an entry in the Other
Phone number field in all of them. The text of the entry will be the same
for each one.

I think I can do this by using a VBA script (?) which I've used to
retrospectively change the format of all the contact forms.

Does anyone know what code I need to write?

Thanks
 
You don't need to use VBA or VBScript at all, probably.

First get a table view of all and only those Contact items for which
you want to make the change. Add the "Other Phone number" to the
table. Modify the view to "Group by" "Other Phone Number".

Now, you can make sure that you are not about to accidentally wiping
out data in the "Other Phone Number" field.

After moving any valuable data from the "Other Phone Number" field,
enter the new "Other Phone Number" in one contact. Collapse the
categories. You should have only two: one with the new number and only
one member, the other with every other item that you want to have that
number. Drag the collapsed category without the right "Other Phone
Number" to the other category. A text box should appear telling you
what is about to happen. Let the mouse button go and then go get some
coffee. When you come back (or sooner), the job will be done.

I tested this (round trip) in Outlook 2002 with more than 1100
contacts.

I think this approach has a lot of application. You could train any
power user to do it. You do have to be careful.
 
Back
Top