Linking Outlook Contacts - email address fields missing

[Mariner81]

I am using External Data - New Data Source - From Other Sources - Outlook Folder and trying to link my outlook contact data. This all seems to well except the wizard does not bring the contact email field along. The main reason I am doing this is because I want to use email addresses for sending reports. It seems just about every possible field is being linked EXCEPT the email.



Any clues as to what may be going on here?

I can export to a CSV file and the email fields show up but not when using the Access Wizard.

[Micron]

Have never done this before but works for me with 365 version 2016. It is the 25th column in the resulting table.
Are you sure that you're selecting "contacts" from the list of available folders? Not ideal, but perhaps you will have to grab the addresses from a csv file.

[Mariner81]

I actually created a folder called TestContacts with some sample data for testing purposes. However I get the same results if I try it on my personal contacts folder.

As I stated the CSV export import works fine but what i am trying to do is link to Outlook and allow my users to select email addresses from their outlook contacts and add them to a setup form which contains the parameters for emailing a report using the DoCmd.SendObject method. The form has fields for To, CC, BCC, Subject, and Message Text. Grabbing the email addresses directly from their Outlook contacts list will be much more streamlined than any other workaround.

[June7]

Using Access 2010 and I also see the E-mail address field in linked table.

[Mariner81]

I am using Access 2016 and Outlook 2016.

[Welshgasman]

Mine is the 24th field in the table and I only have 2007?

[Mariner81]

Mine is the 24th field in the table and I only have 2007?

My 24th field is named "Account" which could very likely be the email field except it did not bring any data with it when it linked. The other fields however did. Quite strange.

[Welshgasman]

Sorry, I was not counting the autonmber field, just the field as they were brought in. Even then I appear to have counted wrong.
In the table
Field 23 is Display name
Field 24 is Email Type
Field 25 is Email Address
Field 26 is Account which is also blank.

[Mariner81]

On mine I have

Field 21 is Other Fax
Field 22 is Telex Number
Field 23 is Display name
Field 24 is Account

Strange that they show different.

[Welshgasman]

2007
I knocked up some code to get all mine.
0 ID
1 First
2 Last
3 Title
4 Company
5 Department
6 Office
7 Post Office Box
8 Address
9 City
10 State
11 Zip/Postal Code
12 Country/Region
13 Phone
14 Mobile Phone
15 Pager Phone
16 Home2 Phone
17 Assistant Phone Number
18 Business Fax
19 Home Fax
20 Other Fax
21 Telex Number
22 Display name
23 E-mail type
24 E-mail address
25 Account
26 Assistant
27 Send Rich Text
28 Primary
29 Normalized Subject

I obviously cannot count?