pull email address for sheets

I have the code to pull everything i need to the master list. Now i need to know how to keep the formatting. Everything work great except 2 of these are email addresses. They are formatted as an email in the sheets (automatically by excel), but not in the list.

Please Login or Register  to view this content.

here is the like to the actual thread. i posted this one in the wrong location.
http://www.excelforum.com/showthread.php?t=1168308