export date from Excel to Outlook Contact

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Edward - 28 Oct 2007 03:35 GMT

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?

Signature

Best regards,
Edward

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Oct 2007 04:40 GMT

Outlook contacts have two built-in date fields, Birthday and Anniversary.

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

> 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?

Reply to this Message

Edward - 29 Oct 2007 01:39 GMT

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.

Signature

Best regards,
Edward

> Outlook contacts have two built-in date fields, Birthday and Anniversary.
>
> > 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?

Reply to this Message

Sue Mosher [MVP-Outlook] - 29 Oct 2007 03:26 GMT

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

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

> Hi Sue,
> Sorry I mistyped the data( as date!) I have some data in Excel like
[quoted text clipped - 4 lines]
>
>> Outlook contacts have two built-in date fields, Birthday and Anniversary.

>> > 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?

Reply to this Message