I am working on a macro to send an email thru excel, which for the most part i have setup. I have all of the fields that are need to including pulling the nt username and populating a cell when then macro is ran to pull the email client up. Is it possible to send to a gal (global address list) entry above the username entered. for example, the username populates as myself "Agent1", then email needs to go to "Sup1" which is the entry above mine. Is this even possible thru vba? I have also toyed with the idea of using vlookup optns to populate the "TO" field.