If you cannot get entry id as one of the columns, don't use
File/Import/GetExternalData.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Salad" wrote in message
m...
Dmitry Streblechenko wrote:

Searching by subject is a bad idea, to put it mildly :-) What happens if
you have multiple messsages with the same subject?
Use the EntryID property and open the item using using
Application.Session.GetItemFromID. There is no reason to search.

Wouldn't you know, EntryID is not one of the columns in the table tha is
created in Access if one links a folder.

Well, MS gave us/me the partial information, but not all unfortunately.
The table lets one know if there are attachments or not, but not the
attachment names nor as it appears an easy way to find the email. Thus
I'd need a way to find the email if it had attachments.