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

excel outlook

ResolvedVersion 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:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.