View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom B Tom B is offline
external usenet poster
 
Posts: 5
Default Capture Outlook E-Mail Address

Windows 2000 / Excel 2000

Anyone know how to capture the user's Outlook address?

I am creating a macro that automatically sends text e-mail
messages to various recipients based on input selections
from the user.

My problem is getting the user to be included. I have
tried variants of

Application.UserName

but that relies on the user being set up with the same
name in the e-mail address.

Anyone know how to capture the user's Outlook address?


Thanks in advance,

- - TB - -