Excel Contacts to Outlook: Need the field names!!

[Mathew]

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 = “[email protected]â€
..HomeAddressStreet = “111 S 1stâ€
..HomeAddressCity = “Omahaâ€
..HomeAddressState = “NEâ€
..HomeAddressPostalCode = “68100″
..SelectedMailingAddress = olHome
..Categories = “Business, Personalâ€

 

[Sue Mosher [MVP-Outlook]]

You look in the object browser -- F2 in VBA -- at the ContactItem object from the Outlook library.

 

[Mathew]

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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54