Consulting

Results 1 to 6 of 6

Thread: Excel Outlook Vba

  1. #1

    Excel Outlook Vba

    I create reports and need to send it to users.
    Sometimes it is 50 and sometimes its 300.
    I am using Ms outlook 2007, its a Ms Exchange type.
    If I want to send an email to ABC, I type ABC in outlook and press Ctrl k and outlook automatically finds his names and email address.
    I cannot see there email address easily, I have to double click and check their info.
    Even copy paste doesn't work.
    Some times if there are 2 or more people with similar name, then I have to identify them by checking properties.

    I want a VBA code to query Full Name or Emp id for several employess and get their email from Active Directory, it would be a super difficult thing to do.
    Also if possible, can I get their Username, OU, Login/Logoff time, Computer Name, Reporting Manager, Department, Thanks in Advance

  2. #2
    Wouldn't it be better to use mail merge? See http://www.gmayor.com/ManyToOne.htm and its one to one mode.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  3. #3
    Gmayor, excellent work here.
    I will check and revert.
    I also looked up the web for the issue and found something like this.
    Check attachment.
    Source https://www.remkoweijnen.nl/blog/200...ry-from-excel/

    Its written very well, but I was not able to make it work.
    Maybe because I am a new bee to vb
    Attached Files Attached Files

  4. #4
    Quote Originally Posted by gmayor View Post
    Wouldn't it be better to use mail merge? See http://www.gmayor.com/ManyToOne.htm and its one to one mode.
    This didn't work.
    Please help.

  5. #5
    I searched we and found good codes.
    But it about ADO and I am not familiar with that.
    Please help

  6. #6
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    You are abusing our forum looking for free solutions for your work and it appears you are out of your depth in what you are attempting. If you are looking to learn VBA then please post your code and we can assist.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •