I have 1500+ contacts in my Outlook 2007 contacts list. I want to assign specific categories to each contact so I can ultimately export certain contacts for use in something like MailChimp or Constant Contact.

Is there an efficient way for me to assign categories such as "Attorney", "CPA", "Personal", etc...?

My thought was to exported everything to Excel and started assigning the categories I've chosen, and then import the file back to Outlook. (This is also a good way for me to purge my contact list and clean it up)

Before I spend a lot of time doing this, is this the correct way to do it? Is there a more efficient way of doing it?



Any help/advice is greatly appreciated!!
Thanks!
Frank