Is there a way, using VBA or otherwise, to get the email address a email was sent to?

I have multiple email addresses that all arrive in the same account, and sometimes I would like to know which address was used.
(This is particularly relevant where I have been BCC'd, but there are other circumstances also.)

Does anyone know a way to do this?

(Just to make it more interesting, I would particularly like to do this from Excel, so I can list all emails sent to me using a particular address.
Also, I occasionally get duplicate emails where more than one of my addresses is in the distribution list, so I would like to be able to distinguish which one was sent to which address.)