adding addresses to outlook 2007

Forums › Microsoft Windows › adding addresses to outlook 2007

CADMAX

218 posts

Master Geek

Subscriber

Topic # 112936 28-Dec-2012 09:17
Well i have spent the morning on goolge with next to no luck. I want to add every one that has ever sent me a email that's still in my inbox to my address book. Now I would have guessed that i could have done it with mail rules but seems like i cant. Does any one know how to do this? I want to add every one (in my inbox) to my address book.. <a href="http://www.lakeflyit.co.nz">lakeflyit

532 posts

Ultimate Geek

Reply # 737983 28-Dec-2012 10:48
Don't know if this will work but have you tried exporting the addresses into a .csv file? File>File Import and export, unselect all the fields on the right hand side except the From Address field. So you have a .csv file with just the From addresses in it. Then import than file back into Outlook - might pay to try the import into a dummy account with a few emails copied into its inbox first, as a test, in case the import action while adding the contacts thinks all the other fields in the account should now be emptied seeing that they don't exist in the import file. I have Outlook 2007 here but is probably just as easy for you to test it if you are interested than for me to do so.

822 posts

Ultimate Geek

Reply # 738006 28-Dec-2012 12:01
John2010 is correct, The easiest way is to simply export to CSV file: 1. Go to File 2. Import and Export 3. Choose export to a file 4. Choose Comma Separated File (Windows) 5. Select Inbox 6. Choose a name for the exported file (click Browse to set the location and name of the file) 7. The next block will say..."The following actions will be performed" and you will see Export Email messages from folder Inbox 8. Click Finish 9. Find the excel file where you saved it in step 6 and open it Your email addresses are under the "From address column" You can then sort it from there in excel. Once you have a list of emails, save them into a CSV file and re-import them back into Outlook.

218 posts

Master Geek

Subscriber

Reply # 738046 28-Dec-2012 14:30
thats verey cool! I should have noted that my inbox is a IMAP and it will not work on a imap :( <a href="http://www.lakeflyit.co.nz">lakeflyit

822 posts

Ultimate Geek

Reply # 738058 28-Dec-2012 15:30
CADMAX: thats verey cool! I should have noted that my inbox is a IMAP and it will not work on a imap :( Can you create a new profile using POP and do it that way? (setting it to "Leave email on the server")

218 posts

Master Geek

Subscriber

Reply # 738059 28-Dec-2012 15:32
lol ok. will do. :) thanks for all the help :) <a href="http://www.lakeflyit.co.nz">lakeflyit

532 posts

Ultimate Geek

Reply # 738062 28-Dec-2012 15:38
OR - Export your IMAP Inbox to a temporary .pst file then open that file using MSOutlook (File>Open). It will appear as a new mail item in MSOutlook and you will be able to export that to a CSV file, etc with the fields you want as previously described. When finished remove the temporary .pst file via Tools>Acount Settings>Data files.