Exporting contacts to an Excel File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created several new fields in my outlook contacts files to fit the
needs of my church office. When trying to export my contacts to an excel
file, I am unable to exported the created fields.

Any suggestions on how I might get this to work
 
Outlook doesn't support exporting custom fields directly. Quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. 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

The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/article.aspx?ID=23
 
Back
Top