Importing Custom Fields From Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kooltou - 08 Nov 2005 01:54 GMT

I have a list of homeowners for my Homeowners Association that I wan
to keep in Outlook contacts list. It is currently in Excel and
have numerous fields that don't direclty map to fields in Outlook.
The name, addresss, phone email fields map fine but fields lik
whether the lot is developed or not, differentiation between mailin
address versus property address, date the owner purchased th
lot/house etc don't map well. Is there a way to make them ma
automatically to a custom field

O

Is there a way to have a folder in Outlook that brings up that addres
list in its native Excel format that looks decent

Reply to this Message

Milly Staples [MVP - Outlook] - 08 Nov 2005 07:14 GMT

OUtlook will not import custom fields.

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Kooltou asked:

| I have a list of homeowners for my Homeowners Association that I want
| to keep in Outlook contacts list. It is currently in Excel and I
[quoted text clipped - 9 lines]
| Is there a way to have a folder in Outlook that brings up that address
| list in its native Excel format that looks decent?

Reply to this Message

Misstine - 08 Nov 2005 14:10 GMT

The fields aren't custom fields. I exported all the fields to the
spreadsheet so that I wouldn't encounter a problem with "custom fields". It
will export 86 of the 215 contacts I have in the spreadsheet. It's as if
there is a limit.

> OUtlook will not import custom fields.
>
[quoted text clipped - 11 lines]
> | Is there a way to have a folder in Outlook that brings up that address
> | list in its native Excel format that looks decent?

Reply to this Message

Sue Mosher [MVP-Outlook] - 08 Nov 2005 12:33 GMT

As Milly said, Outlook doesn't support importing to custom fields. You'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have a list of homeowners for my Homeowners Association that I want
> to keep in Outlook contacts list. It is currently in Excel and I
[quoted text clipped - 9 lines]
> Is there a way to have a folder in Outlook that brings up that address
> list in its native Excel format that looks decent?

Reply to this Message