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.