I know, it's a bit weird asking for a query to tell me my own email address right, I'll explain further...
I'm writing a COM add-in for Outlook 2007. One of the subs generates and sends an email to a particular address and this all works fine. However I have a need to have an option for the sender to be able to include themselves on the recipients list. As more than one person will be running this I cannot just set the sender's email address manually and would prefer to just add a check box on the form to enable this feature.
The only bit I'm stuck on is working out how to find the email address of the person sending the email. I could do it with an AD query against the logged on user but this needs to work for non-domain users also so need another method.
To put it more succinctly: Using VB, how can I return the primary email address associated with the logged-on user's current Outlook profile?