I have a few checkboxes in my custom Outlook 2007 form. When I change the
"View" of my calendar to "All Appointments" and choose which fields I would
like to show (so that I can see an Outlook spreadsheet and copy/paste the
data to an Excel spreadsheet and report against the fields extracted), I can
get all the fields to show up (including the color categories, textboxes,
comboboxes and checkboxes)... but when I copy (Ctrl Shift DownArrow) and
paste into Excel, the checkboxes don't show up at all. All the other fields,
including the color categories, show up, but it's like Excel doesn't
recognize the checkboxes.

In the Outlook spreadsheet the status of the checkbox is marked as an icon of
an empty checkbox or a checked checkbox in the actual cell, not a y/n...
maybe it's the picture of the checked or not-checked checkboxes that Excel
doesn't recognize? Maybe if I could get them to show up as Y/N or O/I or T/F
instead of as little icons Excel would recognize them and import them? In
the Properites tab where I created the field I assumed that the "format" of
the field would have to be Yes/No (as apposed to text or number, etc.), but I
tried to use different "property to use" choices (used all 4 offered: icon,
Yes/No, True/False and On/Off), but they all kept showing up in the Outlook
spreadsheet as little checked or unchecked checkbox icons in the cells and
would not show up in Excel when I copy and pasted the data.

Any suggestions? I just need to be able to pull a boolean value from these
checkboxes (yes/no) that takes to Excel. (or a better way than Excel to
extract the data and create a report?)

Thank you!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...forms/200903/1

I right clicked in the headers and selected format columns Let's see if
that works.

cmonroe21 wrote:
I have a few checkboxes in my custom Outlook 2007 form. When I change the
"View" of my calendar to "All Appointments" and choose which fields I would
like to show (so that I can see an Outlook spreadsheet and copy/paste the
data to an Excel spreadsheet and report against the fields extracted), I can
get all the fields to show up (including the color categories, textboxes,
comboboxes and checkboxes)... but when I copy (Ctrl Shift DownArrow) and
paste into Excel, the checkboxes don't show up at all. All the other fields,
including the color categories, show up, but it's like Excel doesn't
recognize the checkboxes.

In the Outlook spreadsheet the status of the checkbox is marked as an icon of
an empty checkbox or a checked checkbox in the actual cell, not a y/n...
maybe it's the picture of the checked or not-checked checkboxes that Excel
doesn't recognize? Maybe if I could get them to show up as Y/N or O/I or T/F
instead of as little icons Excel would recognize them and import them? In
the Properites tab where I created the field I assumed that the "format" of
the field would have to be Yes/No (as apposed to text or number, etc.), but I
tried to use different "property to use" choices (used all 4 offered: icon,
Yes/No, True/False and On/Off), but they all kept showing up in the Outlook
spreadsheet as little checked or unchecked checkbox icons in the cells and
would not show up in Excel when I copy and pasted the data.

Any suggestions? I just need to be able to pull a boolean value from these
checkboxes (yes/no) that takes to Excel. (or a better way than Excel to
extract the data and create a report?)

Thank you!!

--
Message posted via http://www.officekb.com