Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / February 2008

Tip: Looking for answers? Try searching our database.

Excel Contacts to Outlook:  Need the field names!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mathew - 27 Feb 2008 15:44 GMT
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”
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.