I found an awesome approach to moving contacts in Excel to Outlook!!
http://www.dailydoseofexcel.com/archives/2004/11/11/parse-names-with-outlook/#co
mment-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”
Sue Mosher [MVP-Outlook] - 27 Feb 2008 17:03 GMT
You look in the object browser -- F2 in VBA -- at the ContactItem object from the Outlook library.

Signature
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
>I found an awesome approach to moving contacts in Excel to Outlook!!
> http://www.dailydoseofexcel.com/archives/2004/11/11/parse-names-with-outlook/#co
mment-30943
[quoted text clipped - 22 lines]
> .SelectedMailingAddress = olHome
> .Categories = “Business, Personal”
Mathew - 27 Feb 2008 18:39 GMT
Sue: You are a Gem! Thanks for the help!!
> You look in the object browser -- F2 in VBA -- at the ContactItem object from the Outlook library.
>
[quoted text clipped - 24 lines]
> > .SelectedMailingAddress = olHome
> > .Categories = “Business, Personal”