excel outlook

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel / Outlook

Excel / Outlook

resolvedResolved · 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?

Edited on Fri 18 Jan 2013, 13:16

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips


Server loaded in 0.08 secs.