View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Usage of Outlook data via VBA in Excel

Winfried,
Check the VBA Help in Outlook for "Find Method".
So I assume your contacts have a field of "Username", so you can find their
real name and phone number ?

NickHK

"Winfried" wrote in message
oups.com...
Hi Nick,

Inside VBA the VBA command "environ" -environ ("USERNAME")- really
works fine and gives me the Windows login name. Do have "THE" link
what helps me to get the required Outlook information for VBA inside
Excel? That would be great!!!

Winfried