How do I Access all the Past Email Addresses I've used in Outlook 2007

[Michelle G]

How do I access all the past email addresses I've used in Outlook? I want to send an EM to everyone I've emailed in the past.

[ADezii]

Here is some interesting Code that I came across that will retrieve the E-Mail Addresses of all Users from all Mails in an Outlook Folder, but first:

1. Open the Visual Basic Editor (ALT+F11).
2. Double Click on ThisOutlookSession in the Project Window.
3. Copy-N-Paste the following Sub-Routine.
   

   Sub GetALLEmailAddresses()
   Dim objFolder As MAPIFolder
   Dim strEmail As String
   Dim strEmails As String
   Dim objItem As Object
    
   Set objFolder = Application.GetNamespace("Mapi").PickFolder
    
   For Each objItem In objFolder.Items
     If objItem.Class = olMail Then
       strEmail = objItem.SenderEmailAddress
         If InStr(strEmails, strEmail) = 0 Then strEmails = strEmails + strEmail + ";"
     End If
   Next
    
   Debug.Print strEmails
   End Sub
    

4. Hit the F5 Key and let it Run.
5. Select an Outlook Folder when prompted.
6. Press CTRL+G (Immediate Window).
7. Copy-N-Paste the String that was produced in order to obtain the E-Mail Address off all Users from all Mails in the Outlook Folder.