1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

importing multiple emails addresses into oulook10

Discussion in 'Business Applications' started by sndeh, Oct 20, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. sndeh

    sndeh Thread Starter

    Joined:
    Oct 20, 2011
    Messages:
    3
    I received an email with multiple recipients and i would liek to import/add them to my Outlook 10 contact list. Is there a way of doing this without copying and pasting each one individually?
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    Right click the address and select add to outlook contacts.
     
  3. sndeh

    sndeh Thread Starter

    Joined:
    Oct 20, 2011
    Messages:
    3
    i wish it was that easy. i can add contacts one at a time that way. i would like to add the entire group at one time. any other ideas?
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    You might be able to use a macro to do. Does the recipients field show contact names or the full email address?

    Rollin
     
  5. sndeh

    sndeh Thread Starter

    Joined:
    Oct 20, 2011
    Messages:
    3
    It shows the full email address.
     
  6. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    You can do it with a macro like was suggested. I tried it and it will export to a text file and you can then manually import it.

    Make a folder under the root of C named outlook
    Open Outlook and go to Tools > Macro > VBA editor. Click the plus next to Microsoft Office Outlook Objects and click ThisOutlookSession and paste the following code in the window on the right.

    Sub ExtractEmail()
    Dim OlApp As Outlook.Application
    Dim Mailobject As Object
    Dim Email As String
    Dim NS As NameSpace
    Dim Folder As MAPIFolder
    Set OlApp = CreateObject("Outlook.Application")
    ' Setup Namespace
    Set NS = ThisOutlookSession.Session
    ' Display select folder dialog
    Set Folder = NS.PickFolder
    ' Create Text File
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set a = fs.CreateTextFile("c:\outlook\email addresses.txt", True)
    ' loop to read email address from mail items.
    For Each Mailobject In Folder.Items
    Email = Mailobject.SenderEmailAddress
    a.WriteLine (Email)
    Next
    Set OlApp = Nothing
    Set Mailobject = Nothing
    a.Close
    End Sub

    Save it and close the VBA editor. Now go to Tools > Macro and run the macro you just created. It will put all address from whatever folder you selected and put them in a text file.
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1023198

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice