[Creosote]

I was saying I tried amtrac24's solution and it's not giving me my local LAN address.

Your solution looks cool. Here is another solution to send the email with CDO if you want to try that too.

http://support.microsoft.com/?id=286431