|
| 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 |
|
#1
October 28th 07, 02:35 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
export date from Excel to Outlook Contact
Hi everybody,
How can I populate Outlook contact with Excel date from Excel? I have names address and other fields in Excel and I would like know if there is a way with VBA to popultae Outlook contact with those? -- Best regards, Edward 
|
| Ads |
|
#2
October 28th 07, 03:40 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
export date from Excel to Outlook Contact
Outlook contacts have two built-in date fields, Birthday and Anniversary.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Edward" wrote in message ... Hi everybody, How can I populate Outlook contact with Excel date from Excel? I have names address and other fields in Excel and I would like know if there is a way with VBA to popultae Outlook contact with those? -- Best regards, Edward
|
|
#3
October 29th 07, 12:39 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
export date from Excel to Outlook Contact
Hi Sue,
Sorry I mistyped the data( as date!) I have some data in Excel like name,title, address, email address and ... instead of typing them one by one in Outlook I want to know if there is a code to export this data to Outlook's contact? I know how to write the Excel part but I don't know anything about Outlook VBA so I will appreciate any help greatly. -- Best regards, Edward "Sue Mosher [MVP-Outlook]" wrote: Outlook contacts have two built-in date fields, Birthday and Anniversary. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Edward" wrote in message ... Hi everybody, How can I populate Outlook contact with Excel date from Excel? I have names address and other fields in Excel and I would like know if there is a way with VBA to popultae Outlook contact with those? -- Best regards, Edward
|
|
#4
October 29th 07, 02:26 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
export date from Excel to Outlook Contact
If no custom fields are involved, you don't need code. You can just use the File | Import and Export command.
If you want to write code, though, you can start with the samples listed at http://www.outlookcode.com/article.aspx?ID=23 -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Edward" wrote in message ... Hi Sue, Sorry I mistyped the data( as date!) I have some data in Excel like name,title, address, email address and ... instead of typing them one by one in Outlook I want to know if there is a code to export this data to Outlook's contact? I know how to write the Excel part but I don't know anything about Outlook VBA so I will appreciate any help greatly. -- Best regards, Edward "Sue Mosher [MVP-Outlook]" wrote: Outlook contacts have two built-in date fields, Birthday and Anniversary. "Edward" wrote in message ... Hi everybody, How can I populate Outlook contact with Excel date from Excel? I have names address and other fields in Excel and I would like know if there is a way with VBA to popultae Outlook contact with those?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I export my contact list to Microsoft Excel? | KathywithaKtheonlyway | Outlook - Using Contacts | 2 | September 24th 07 03:52 PM |
| export figure from Outlook msg to Excel | Max Bialystock | Outlook and VBA | 1 | April 25th 07 05:59 AM |
| How export contacts to excel add contact and import again | Henry Roif | Outlook - Using Contacts | 2 | April 17th 07 04:12 PM |
| Can i export an excel sprd of contact name & adresses into outlok | jjhansen20 | Outlook - Using Contacts | 1 | March 18th 06 04:34 PM |
| export a public contact folder to excel? | mjb | Outlook - Using Contacts | 1 | January 20th 06 05:44 AM |
Linear Mode
