I'm trying to use Access to run a query against our Global Address List in Outlook. What I want is the first name, last name and email address of all the people in a specific department.
I've imported the database and created the query and it pulls the people I want. The problem is that there are multiple lines in the Email Addresses field and only the first one is returned. How can I get to the rest of the information in the field?
I've searched here and in the MS Knowledge Base but didn't find anything that seemed to relate to the issue. It's not a 255 character limit on the field as some of the data it is getting is substantially less than 255 characters...it always ends with whatever is on the first line of the field.