Re: Usage of Outlook data via VBA in Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <Winfried.Kastner@xxxxxxxxx> wrote in message
news:1180598764.374605.215940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Adding a Row to Excel SS using OLE
    ... please see the Insert function of the Range object in the VBA help. ... This group is for Outlook, not for Excel. ... Viele Gruesse / Best regards ...
    (microsoft.public.outlook.program_vba)
  • Re: How to tell if Word is the email editor?
    ... I'm going to quote from Outlook VBA Help: ... inspector is displayed in an Outlook Inspector or in ... Returns True if the mail message is ...
    (microsoft.public.outlook.program_vba)
  • Re: Code to create "Keep In Touch" Tasks
    ... Helpful functions for you (please see VBA help for details and samples): ... Michael Bauer - MVP Outlook ... > The frequency field I use to code roughly how often I should try to keep ... > see if I've been delinquent in talking with someone. ...
    (microsoft.public.outlook.program_vba)
  • Re: 2 simple macros - create task from email and move email to folder
    ... You can start with the VBA help, which contains a lot of samples. ... Michael Bauer - MVP Outlook ... Right click on it, goto customize, commands, macro, and drag your macro ...
    (microsoft.public.outlook.program_vba)
  • Re: How do I create an e-mail template that is filled out by a for
    ... Functions are also documented in VBA Help. ... Sue Mosher, Outlook MVP ... Author of Configuring Microsoft Outlook 2003 ... One field is a numeric field only and the date fields all work... ...
    (microsoft.public.outlook.program_forms)