Outlook: Exporting Custom Fields

I'm using Outlook 2000 in an Exchange environment. My custom form contains Yes/No check boxes. When I create a table view and attempt to paste data into a Microsoft Excel worksheet, the columns with the check boxes don't copy over to Excel. How can I fix this?

Copying from a table view to Excel is a popular workaround for a limitation in Outlook that prevents you exporting custom fields. By default, a Yes/No field displays a check box in the table view, but the copy procedure ignores those check boxes. The solution is to change the format of the column in the table view. Right-click the column heading, then choose Format Columns. Next, use the Format drop-down list to change the selection from Icon to True/False. You can then copy the data into Excel.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.