98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel / Outlook
Excel / Outlook
Resolved · Medium Priority · Version 2010
Annabelle has attended:
Excel Intermediate course
Outlook Advanced course
Excel / Outlook
How do you export contacts from Outlook to Excel on a PC please?
RE: Excel / Outlook
Hi Annabelle
Thank you for your question. Using Outlook 2010 go to to File and choose Options. Select the Advanced tab and click the Export button.
This launches the Import and Export wizard
Choose Export to a file then click Next
You can export to Excel or to a comma separated (ie delimited) file, among other formats.
After clicking next again you can choose the contacts folder to export.
The next step asks where the file should be stored.
The final step offers you the option to map (or rename) the fields that will arrive in your document. This is probably not necessary unless you are going to use the exported file to upload data into another database, such as a CRM product. Click Finish to complete.
Once exported the file could then be used as a mail merge data source.
I hope this helps - do let me know if you have any further questions.
PS I've also found a supporting article on this topic on the Microsoft website for your info.
Hope all well with you and it's not too snowy over where you are!
Kind regards,
Andrew
Fri 25 Jan 2013: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |