Reading the email address stored within the From field
Posted on 2011-03-22
I am developing a function within my Access database that lets us handle bounce backs and "Out of office" emails. To do this, I link directly into Outlook via ADO and then pull in the relevant data. However, on some of the "Out of office" emails it has the persons name within the FROM field but no email address (although I can see it on the screen). I am guessing that it is within the email properties, but i do not know how to access this data.
Currently (after the connection string), I am simply using a very simple test string to select the emails within a specific folder:
SELECT * FROM [Bounced emails]
But as mentioned above, this doesn't give me everything. Any ideas?