Custom Outlook contact fields, link into Access

Posted on 2009-02-24
Last Modified: 2012-05-06
I have "Contacts" from Outlook linked into an Access database.  This does not show custom fields on a custom form in Outlook though.  How can I gain access to the custom fields in Outlook so that I can link to them in Access?
Question by:Stephanie Hudson
    LVL 28

    Expert Comment

    Linking an Outlook folder in Access does not bring over all available Outlook fields.  You can test this by importing the Outlook folder directly into a local Access table.  This will get you all the Outlook fields but the table will not be linked.  You can, if necessary, set a procedure up to re-import the table when needed to capture the latest data.

    OM Gang
    LVL 28

    Accepted Solution

    Here's a link to a Q I answered quite some time ago regarding using code to iterate through an Outlook Contacts folder and checking the value of a particular field.

    OM Gang

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now