Outlook: Exporting Custom Fields

Learn how to work around the Outlook limitation that prevents you from exporting custom fields.

Sue Mosher

July 27, 2003

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like