Skip to main content

HOWTO Export contacts from Outlook to Excel.

This HOWTO article applies to Microsoft Office 2007. I think it should work for Microsoft Office 2003 as well. This is to export your Outlook Contacts information to an Excel worksheet. A little information to share about the difference between Outlook Address Book, and Outlook Contacts. "They are both part of Outlook. However, the Address Book is a compilation of the different address lists you might have stored in Outlook, such as Personal Address Book (.pab), LDAP Internet directories, the Global Address List (GAL), or other third-party address books. Contacts is just one of the address lists that makes up the Address Book." (2010, Office.Microsoft.com)


Here's the step by step guide.

  • In Outlook, on the File menu, click Import and Export
  • Click Export to a file, and then click Next.
  • Click Microsoft Excel, and then click Next.
  • In the folder list, click the Contacts folder, and then click Next.
  • Browser to the folder where you want to save the contacts as an Excel file (.fls)
  • Type a name for the exported file, and then click OK.
  • Click Next.
  • Click Finish.
See attached captured files for additional information. I hope this help you.
 








Popular posts from this blog

Alternative Social Networks

If you are planning to create your social network e.g. similar to Facebook. Here's a short list of alternative software's:

Open Source and Free​
http://buddypress.org/ - Wordpress (Open Source and Free)http://elgg.org/ - (Open Source and Free)Commercial Social Networks software
http://www.socialengine.com/ ($299 Stand Alone, $29/mo Cloud)http://www.jomsocial.com/ (run with Joomla, need to know CMS)http://www.boonex.com/ (very expensive, $399 for Standard)http://www.anahitapolis.com/http://www.oxwall.org/http://sharetronix.com/http://www.moosocial.com/http://www.jcow.net/http://phpdolphin.comhttp://www.grou.ps (from free to Commercial, I left my networks and they are selling it http://www.phpfox.com/ (I used this before, it's hard to maintain. I moved to NING but left too after it was sold to another company)http://www.ning.com (I don't recommend using this service, it's hard to export your data when it's time to move)Something to check when selecting your next soc…

Example of Out of Office Reply for Terminated Employee

This is a sample message that I used for terminated employees, unless HR staff specified a different message.
=== Example for KING.NET Employee === John Doe (employee or consultant) is no longer with KING.NET effective June 1, 2008 (termination date). For matters relating to "Project Name here" please direct your concerns to John Smith at johnsmith@king.net (Manager or Supervisor). For all other matters, please direct your email to Mary Smith HR at marysmith@king.net.
Please call our main office 703-345-6789 if you have other concerns.
Thank you.
=== end of message ===

Frequent Account Lockout in Active Directory

I have a user in Windows Pro 7, and Windows Server 2003 environment that is frequently account locked out. I tried many different scenarios to resolve this account lockout issue, from resetting his password, changing a new password, remove and re-join the domain, rebooting the workstation and active directory servers.

I tried to use the command prompt utility to run "rundll32.exe keymgrdll, KRShowKeyMgr" (case sensitive) to delete the account in Windows 7 password cache, and still no luck.

Still searching for answer ... Let me know if you encounter a similar issue in Windows Pro 7 and Windows Server 2003.

Continue reading updated post here:
http://www.whaddya.com/2011/09/windows-needs-your-credentials.html