Results 1 to 4 of 4

Thread: Need to Extract information from Microsoft outlook basis given employee ID's usingVBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-29-2015, 03:57 PM #1
    Kush@0081
    Kush@0081 is offline
    Junior Member
    Join Date
    Apr 2015
    Posts
    1
    Rep Power
    0

    Need to Extract information from Microsoft outlook basis given employee ID's usingVBA

    Need to Extract information from Microsoft outlook basis given employee ID's usingVBA

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=QdwDnUz96W0&lc=Ugx3syV3Bw6bxddVyBx4AaABAg
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgxsozCmRd3RAmIPO5B4AaABAg. 9fxrOrrvTln9g9wr8mv2CS
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg. 9fz3_oaiUeK9g96yGbAX4t
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9g7pczEpcTz
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=UgyT1lo2YMUyZ50bLeR4AaABAg. 9fz3_oaiUeK9g7lhoX-ar5
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gD0AA-sfpl
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugx5d-LrmoMM_hsJK2N4AaABAg.9fyL20jCtOI9gECpsAVGbh
    https://www.youtube.com/watch?v=U76ZRIzBhOA&lc=Ugw6zxOMtNCfmdllKQl4AaABAg. 9g9wJCunNRa9gJGhDZ4RI2
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugz-pow-E8FDG8gFZ4l4AaABAg.9f8Bng22e5d9f8hoJGZY-5
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugxev2gQt7BKZ0WYMfh4AaABAg. 9f6hAjkC0ct9f8jleOui-u
    https://www.youtube.com/watch?v=Sh1kZD7EVj0&lc=Ugxg9iT7MPWGBWruIzR4AaABAg
    https://www.youtube.com/watch?v=tzbKqTRuRzU&lc=UgyYW2WZ2DvSrzUKnJ14AaABAg
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=317218#p317218
    https://eileenslounge.com/viewtopic.php?p=316955#p316955
    https://eileenslounge.com/viewtopic.php?p=316955#p316955
    https://eileenslounge.com/viewtopic.php?p=316940#p316940
    https://eileenslounge.com/viewtopic.php?p=316927#p316927
    https://eileenslounge.com/viewtopic.php?p=317014#p317014
    https://eileenslounge.com/viewtopic.php?p=317006#p317006
    https://eileenslounge.com/viewtopic.php?p=316935#p316935
    https://eileenslounge.com/viewtopic.php?p=316875#p316875
    https://eileenslounge.com/viewtopic.php?p=316254#p316254
    https://eileenslounge.com/viewtopic.php?p=316280#p316280
    https://eileenslounge.com/viewtopic.php?p=315915#p315915
    https://eileenslounge.com/viewtopic.php?p=315512#p315512
    https://eileenslounge.com/viewtopic.php?p=315744#p315744
    https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
    https://eileenslounge.com/viewtopic.php?p=315680#p315680
    https://eileenslounge.com/viewtopic.php?p=315743#p315743
    https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
    https://eileenslounge.com/viewtopic.php?p=314950#p314950
    https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
    https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
    https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 05-20-2024 at 03:43 PM.
    Reply With Quote Reply With Quote
  2. 05-08-2015, 09:36 PM #2
    Excel Fox
    Excel Fox is offline
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Kush, what exactly do you need to extract? Can you share a sample and how does using employee ID help to get what you are looking for.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook
    Reply With Quote Reply With Quote
  3. 05-13-2015, 11:36 AM #3
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Try this:

    Code:
    Enum OL_Info
    
    CompanyName = 1
    BusinessAddress = 2
    BusinessAddressCity = 3
    BusinessAddressState = 4
    BusinessAddressPostalCode = 5
    BusinessTelephoneNumber = 6
    Email1Address = 7
    
End Enum

Function LM_Test(Name As String, Info As OL_Info) As String

    Dim olA                 As Object 'Outlook.Application
    Dim olNS                As Object 'Namespace
    Dim olAB                As Object 'MAPIFolder
    Dim lItem               As Long
    Dim sNameWanted         As String
    Dim sRetValue           As String

    Set olA = CreateObject("Outlook.Application")
    Set olNS = olA.GetNamespace("MAPI")
    Set olAB = olNS.GetDefaultFolder(olFolderContacts)

    Application.Volatile
    sNameWanted = rRng.Value
    sRetValue = "Not Found"

    On Error Resume Next

    For lItem = 1 To olAB.Items.Count
        With olAB.Items(lItem)
            If sNameWanted = .FullName Then
                Select Case Info
                    Case 1
                        sRetValue = .CompanyName
                    Case 2
                        sRetValue = .BusinessAddress
                    Case 3
                        sRetValue = .BusinessAddressCity
                    Case 4
                        sRetValue = .BusinessAddressState
                    Case 5
                        sRetValue = .BusinessAddressPostalCode
                    Case 6
                        sRetValue = .BusinessTelephoneNumber
                    Case 7
                        sRetValue = .Email1Address
                End Select
            End If
        End With
    Next lItem
    olA.Quit
    
    LM_Test = sRetValue
    
    'Release Memory
    Set olA = Nothing
    Set olNS = Nothing
    Set olAB = Nothing
    lItem = Empty
    sNameWanted = vbNullString
    sRetValue = vbNullString
    
End Function
    Or please check:

    http://www.globaliconnect.com/excel/...=79&Itemid=475
    Last edited by LalitPandey87; 05-13-2015 at 11:39 AM.
    Reply With Quote Reply With Quote
  4. 04-19-2018, 06:51 PM #4
    Michael Gray
    Michael Gray is offline
    Junior Member
    Join Date
    Apr 2018
    Posts
    1
    Rep Power
    0

    solution

    Okay, if you need to extract information from Microsoft outlook I can suggest you one way, to do it. Speaking from my experience, such call-it improvements could harm the working convenience indeed, as you said so. I tried this and it suited me specificly, but I see that for many other guys it turned their databases to mush. Usually you need to transfer data from one client to another and else, so when I was using winmail in vista and switched to more up-to-dated Outlook 2016 I was a bit confused, but later I found a transfet tool in order to import mail to outlook source Afterwards I was able to easily import all my emails, and it worked out fine for my coworker who switched from OS X Mail Client to that as well. Hope it will come in use for somebody here, in order to keep your data filtered out as it suppose to.

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=317218#p317218
    https://eileenslounge.com/viewtopic.php?p=316955#p316955
    https://eileenslounge.com/viewtopic.php?p=316955#p316955
    https://eileenslounge.com/viewtopic.php?p=316940#p316940
    https://eileenslounge.com/viewtopic.php?p=316927#p316927
    https://eileenslounge.com/viewtopic.php?p=317014#p317014
    https://eileenslounge.com/viewtopic.php?p=317006#p317006
    https://eileenslounge.com/viewtopic.php?p=316935#p316935
    https://eileenslounge.com/viewtopic.php?p=316875#p316875
    https://eileenslounge.com/viewtopic.php?p=316254#p316254
    https://eileenslounge.com/viewtopic.php?p=316280#p316280
    https://eileenslounge.com/viewtopic.php?p=315915#p315915
    https://eileenslounge.com/viewtopic.php?p=315512#p315512
    https://eileenslounge.com/viewtopic.php?p=315744#p315744
    https://www.eileenslounge.com/viewtopic.php?p=315512#p315512
    https://eileenslounge.com/viewtopic.php?p=315680#p315680
    https://eileenslounge.com/viewtopic.php?p=315743#p315743
    https://www.eileenslounge.com/viewtopic.php?p=315326#p315326
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40752
    https://eileenslounge.com/viewtopic.php?p=314950#p314950
    https://www.eileenslounge.com/viewtopic.php?p=314940#p314940
    https://www.eileenslounge.com/viewtopic.php?p=314926#p314926
    https://www.eileenslounge.com/viewtopic.php?p=314920#p314920
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 05-20-2024 at 03:52 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Extract Outlook 2007 global address List in excel 2007
    By superman in forum Outlook Help
    Replies: 0
    Last Post: 09-03-2014, 07:15 PM
  2. Transfer Information From One Sheet To Another Based On Criteria
    By jeff in forum Excel Help
    Replies: 4
    Last Post: 07-08-2013, 05:36 PM
  3. Extract Email Details For All Incoming Mails Using VBA In Outlook
    By vivek09 in forum Excel Help
    Replies: 6
    Last Post: 05-25-2013, 07:36 PM
  4. Lookup Populate Grouped Information Based On DropDown Selection
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 04-10-2013, 12:40 AM
  5. High Lighting Current Date In employee Attendance
    By sanjeevi888 in forum Excel Help
    Replies: 2
    Last Post: 07-01-2012, 10:59 PM

Bookmarks

Posting Permissions

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

Forum Rules