Outlook: Exporting Custom Fields
Learn how to work around the Outlook limitation that prevents you from exporting custom fields.
July 27, 2003
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.
About the Author
You May Also Like