copy e-mail addresses not alias

using outlook (exchange server) and excel 2003

I currently have a macro set up in excel that copies the file and sends it
to the e-mail addresses listed in specific cells. I need to add a large
group of people the list of recipients. I have e-mails that show all of the
new recipients, but they are all shown as their alias (based on our company's
global address book). Is there some way to get the actual e-mail address
other than going into the properties of each and then manually typing the
address from the e-mail address's tab? The macro in excel only recognizes
the actual addresses and not the alias.