Richard Schierer
asked on
How to Export Outlook Contacts from Multiple files to Excel
Over the years, I have acquired hundreds of email addresses, from multiple states that I lived in. I would like to export ALL of them into one excel csv spreadsheet.
I am using Outlook 2016 w/ a Office 365 subscription.
What are my options?
TIA
I am using Outlook 2016 w/ a Office 365 subscription.
What are my options?
TIA
Saqib Husain
Where are all those contact info? Are they not on one contacts sheet in Outlook?
VBA is the quickest, see: https://wellsr.com/vba/201
You can also export the contact info to a text file and then open that in Excel, see: https://www.datanumen.com/
Also, as an FYI, Microsoft Access can directly connect to Outlook giving you very easy access to your contact's information in a tabular format. Then you can query, export, ... and do much more with great ease.
You can also export the contact info to a text file and then open that in Excel, see: https://www.datanumen.com/
Also, as an FYI, Microsoft Access can directly connect to Outlook giving you very easy access to your contact's information in a tabular format. Then you can query, export, ... and do much more with great ease.
I am sure there is a lot more to it in your case, but this may give you an idea of how export from Outlook to Excel works:
https://clientlook.com/how-to-export-contacts-from-outlook-to-excel
https://clientlook.com/how-to-export-contacts-from-outlook-to-excel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Richard,
Are you using an Mac or a PC ?
Because depending of your OS, the procedure is different.
Regards
Are you using an Mac or a PC ?
Because depending of your OS, the procedure is different.
Regards
ASKER
I am running Windows 7 enterprise, OFFICE 365 2016
I have about 9 contact lists that I have created over the years.
I will have a go at some of the above suggestions, but feel free to expand on the info that I have provided to your questions.
I have about 9 contact lists that I have created over the years.
I will have a go at some of the above suggestions, but feel free to expand on the info that I have provided to your questions.
Answers of Tom or Bill should work, regards
I'd think Bill's would be pretty simple to implement.
ASKER
Thanks to everyone that chimed in on this one.
I have at least 7+ outlook contact files in outlook and was interested in find out if there was a low tech automated solution that would search the hard drive for contacts and export to a single EXCEL spreadsheet.
I already had exported each of the files to EXCEL and saved to an XLSX format.
I then copied and pasted into one master spreadsheet.
Got rid of the duplicates (and triplicates).
I now have 1 master contact spreadsheet that can used for exporting.
It took a little longer than I want it too, but ...
I have at least 7+ outlook contact files in outlook and was interested in find out if there was a low tech automated solution that would search the hard drive for contacts and export to a single EXCEL spreadsheet.
I already had exported each of the files to EXCEL and saved to an XLSX format.
I then copied and pasted into one master spreadsheet.
Got rid of the duplicates (and triplicates).
I now have 1 master contact spreadsheet that can used for exporting.
It took a little longer than I want it too, but ...
Hey Richard, next time check out Power Query, which is embedded in Excel. It might have kept you from having to copy and paste the multiple spreadsheets into one master. Easy to get rid of duplicates, and clean up clutter.