add Customer ID to Contacts form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobArtRees - 03 Jan 2007 04:36 GMT

I'm trying to add the Customer ID field to my Outlook Contacts form. Later I
want to use Contacts as a linked database in Access. I have figured out how
to add the field to one single contact, but don't know how to change the form
universally so every new and old contact shows that Customer ID field.

I was trying to export the contacts to Excel so I could enter numbers for
the existing contacts, but OUtlook wouldn't export the Customer ID Field.

Reply to this Message

Sue Mosher [MVP-Outlook] - 03 Jan 2007 13:56 GMT

See http://www.outlookcode.com/d/newdefaultform.htm for information on making your new form the default.

Outlook doesn't support exporting custom fields directly. Quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.

If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

The alternatives are to write your own custom VBA code or to 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'm trying to add the Customer ID field to my Outlook Contacts form. Later I
> want to use Contacts as a linked database in Access. I have figured out how
[quoted text clipped - 3 lines]
> I was trying to export the contacts to Excel so I could enter numbers for
> the existing contacts, but OUtlook wouldn't export the Customer ID Field.

Reply to this Message