I found an awesome approach to moving contacts in Excel to Outlook!!
http://www.dailydoseofexcel.com/archives/2004/11/11/parse-names-with-outlook/#comment-30943

We manage our contacts in Excel as it is easer for the staff. I’ve used
some of this code to directly import contacts from Excel to Outlook. It
works great!!

Question: Where do you find the field names for Outlook, i.e. FirstName
please see the code below. This example below is practically the only one I
can find and/or get to work. Strangely, I can’t find the field name (s) for
Business Phone (s) or business fax (s) to work. I’ve tried a couple
different variants, but I just can’t get it on trial and error approach. Is
there any location were these field names are published? I've looked in
Outlook, converted contacts in Outlook to Excel but even this dosn't work!! I
have to add some additional fields to the contacts we create. Thanks for any
help!!
..FirstName = “Dick”
..LastName = “Kusleika”
..MobileTelephoneNumber = “(402) 555-1212″
..Email1Address = “dick@dicks-clicks.com”
..HomeAddressStreet = “111 S 1st”
..HomeAddressCity = “Omaha”
..HomeAddressState = “NE”
..HomeAddressPostalCode = “68100″
..SelectedMailingAddress = olHome
..Categories = “Business, Personal”

Archived from group: microsoft>public>outlook>program_vba