G Guest Jun 26, 2006 #1 I am trying to export from a contact list located in our public folders. I have full permission to this list. Can I export to CSV?
I am trying to export from a contact list located in our public folders. I have full permission to this list. Can I export to CSV?
S Sue Mosher [MVP-Outlook] Jun 26, 2006 #2 Quick and dirty method: 1. Use a table view to display all the data fields that you want to export. 2. Choose Edit | Select All. 3. Choose Edit | Copy. 4. Paste to Excel. If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers
Quick and dirty method: 1. Use a table view to display all the data fields that you want to export. 2. Choose Edit | Select All. 3. Choose Edit | Copy. 4. Paste to Excel. If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers