|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#3
February 27th 08, 06:39 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Excel Contacts to Outlook: Need the field names!!
Sue: You are a Gem! Thanks for the help!!
"Sue Mosher [MVP-Outlook]" wrote: 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 "Mathew" wrote in message ... I found an awesome approach to moving contacts in Excel to Outlook!! http://www.dailydoseofexcel.com/arch...#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 = ” .HomeAddressStreet = “111 S 1st” .HomeAddressCity = “Omaha” .HomeAddressState = “NE” .HomeAddressPostalCode = “68100″ .SelectedMailingAddress = olHome .Categories = “Business, Personal” 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Children field in contacts, dont want it to alphabetize the names | Joanne | Outlook - Using Contacts | 4 | December 31st 07 06:46 AM |
| Add field when importing from Excel into Outlook | LBlake | Outlook - Using Contacts | 3 | June 6th 07 07:10 PM |
| Notes for contacts disappear when two names are in first name field | Rebecca | Outlook - Using Contacts | 1 | May 7th 06 04:25 AM |
| Move Contacts into other folder /Rename Field Names | Chris145 | Outlook - Using Contacts | 2 | April 11th 06 01:19 PM |
| import excel names & emails help | Chris at the Inn | Outlook - Using Contacts | 1 | April 7th 06 09:02 PM |
Threaded Mode