Making columns the same

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Gwin - 29 Jun 2005 21:28 GMT

In Outlook 2003, I have a user-generated field called "Owner" in my contacts
database. What I want to do is make every single field in the "Owner" column
the exact same thing without having to go through the database and manually
type it all in (the db has north of 3000 records). Does anybody know how to
do this?

Thanks

Reply to this Message

Jocelyn Fiorello [MVP - Outlook] - 30 Jun 2005 05:16 GMT

Export the contacts to Excel or Access and make the changes there, then
import them back into Outlook. Make sure you have a good backup of the
contacts from Outlook before you try this, since the import/export process
can be problematic at times.

Signature

Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***

> In Outlook 2003, I have a user-generated field called "Owner" in my contacts
> database. What I want to do is make every single field in the "Owner" column
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Judy Gleeson MVP - Outlook - 30 Jun 2005 11:23 GMT

View in Phone List view (a Table) group by your new field and drag all the
ones with the filed empty into the group where they will be set to the
correct data.

Eg. if I have grouped By Category, I can drag people from category none into
Category A customer by dragging them into that group.

Hope this helps!!

Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia

see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm

Reply to this Message

Rate this thread: