|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
September 26th 06, 05:23 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Export Form Data
Sue,
Thanks for all your help on this issue... I have created a task form that contains a variety of custom fields. I am able to export some of the custom fields (i.e. text entry, date) without issue, however I have some check boxes that do not copy over? The properties of the checkbox fields are set as: Type: Yes/No Format: Icon Property to use: Value There is no initial value or validation done on these check boxes. Thanks again for any help you can provide... Mike "Sue Mosher [MVP-Outlook]" wrote: Simply copy or move them -- drag/drop or the commands on the Edit menu. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Shree" wrote in message ... Hi Sue, Can you please expand a little more on how I can put all the items in one folder. I have a custom made form(message) with several custom fields and layers(tabs). Thanks in advance. "Sue Mosher [MVP-Outlook]" wrote: Outlook doesn't support exporting custom fields. Quick and dirty method: 1. Put all the items from your form in one folder. 2. Use a table view to display all the data fields that you want to export to Excel. 3. Choose Edit | Select All. 4. Choose Edit | Copy. 5. Paste to Excel. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm . -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Harv" wrote in message ... Hope you can help. I created a form based on a Task. All seems to work fine with that. Now, I would like to export the information to an excel file. The problem is that when I do this, I only get the field from the task and none of the custom fields I created. I really just want the fields I created. Any help or suggestions would be appreciated. Thanks Harv 
|
| Ads |
|
#2
September 26th 06, 05:30 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Export Form Data
How are you performing the export?
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Wiscrebels" wrote in message ... Sue, Thanks for all your help on this issue... I have created a task form that contains a variety of custom fields. I am able to export some of the custom fields (i.e. text entry, date) without issue, however I have some check boxes that do not copy over? The properties of the checkbox fields are set as: Type: Yes/No Format: Icon Property to use: Value There is no initial value or validation done on these check boxes. Thanks again for any help you can provide... Mike "Sue Mosher [MVP-Outlook]" wrote: Simply copy or move them -- drag/drop or the commands on the Edit menu. "Shree" wrote in message ... Hi Sue, Can you please expand a little more on how I can put all the items in one folder. I have a custom made form(message) with several custom fields and layers(tabs). Thanks in advance. "Sue Mosher [MVP-Outlook]" wrote: Outlook doesn't support exporting custom fields. Quick and dirty method: 1. Put all the items from your form in one folder. 2. Use a table view to display all the data fields that you want to export to Excel. 3. Choose Edit | Select All. 4. Choose Edit | Copy. 5. Paste to Excel. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm . -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Harv" wrote in message ... Hope you can help. I created a form based on a Task. All seems to work fine with that. Now, I would like to export the information to an excel file. The problem is that when I do this, I only get the field from the task and none of the custom fields I created. I really just want the fields I created. Any help or suggestions would be appreciated. Thanks Harv
|
|
#3
September 26th 06, 05:48 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Export Form Data
I've added all the custom fields to the view and tried both exporting
(File/Import and Export/Export to a file/Microsoft Excel) and dragging and dropping to Excel. "Sue Mosher [MVP-Outlook]" wrote: How are you performing the export? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Wiscrebels" wrote in message ... Sue, Thanks for all your help on this issue... I have created a task form that contains a variety of custom fields. I am able to export some of the custom fields (i.e. text entry, date) without issue, however I have some check boxes that do not copy over? The properties of the checkbox fields are set as: Type: Yes/No Format: Icon Property to use: Value There is no initial value or validation done on these check boxes. Thanks again for any help you can provide... Mike "Sue Mosher [MVP-Outlook]" wrote: Simply copy or move them -- drag/drop or the commands on the Edit menu. "Shree" wrote in message ... Hi Sue, Can you please expand a little more on how I can put all the items in one folder. I have a custom made form(message) with several custom fields and layers(tabs). Thanks in advance. "Sue Mosher [MVP-Outlook]" wrote: Outlook doesn't support exporting custom fields. Quick and dirty method: 1. Put all the items from your form in one folder. 2. Use a table view to display all the data fields that you want to export to Excel. 3. Choose Edit | Select All. 4. Choose Edit | Copy. 5. Paste to Excel. You can't change the fields available for export. However, if you use Access to set up a linked table connected to your mail folder, you will see the Received date among the available properties. Third-party export tools are also available; see http://www.outlookcode.com/d/customimport.htm#tools Otherwise, you'd have to write custom code or use a third-party application. See http://www.outlookcode.com/d/customimport.htm . -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Harv" wrote in message ... Hope you can help. I created a form based on a Task. All seems to work fine with that. Now, I would like to export the information to an excel file. The problem is that when I do this, I only get the field from the task and none of the custom fields I created. I really just want the fields I created. Any help or suggestions would be appreciated. Thanks Harv
|
|
#4
September 26th 06, 06:00 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Export Form Data
Custom fields can't be exported with the Import and Export wizard. Try displaying the desired fields in a table view, using text for the Yes/No fields instead of icons, and copying, selecting all, then copying and pasting to Excel. If that doesn't give you the desired results, you'll need to write your own export code or use a third-party tool. See http://www.outlookcode.com/d/customimport.htm
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Wiscrebels" wrote in message ... I've added all the custom fields to the view and tried both exporting (File/Import and Export/Export to a file/Microsoft Excel) and dragging and dropping to Excel. "Sue Mosher [MVP-Outlook]" wrote: How are you performing the export? "Wiscrebels" wrote in message ... I have created a task form that contains a variety of custom fields. I am able to export some of the custom fields (i.e. text entry, date) without issue, however I have some check boxes that do not copy over? The properties of the checkbox fields are set as: Type: Yes/No Format: Icon Property to use: Value
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Scripting an export and import of data and settings in outlook | Nate | Outlook and VBA | 3 | August 15th 06 04:32 PM |
| Outlook 2003 no longer allows export of contact data to a CSV | James Borders | Outlook - Using Contacts | 2 | March 18th 06 08:49 PM |
| How do i export data | thtsps | Outlook - Using Forms | 1 | March 15th 06 04:26 PM |
| OL2003 - can you auto-fill a singel new contact form with online form data | TimR | Outlook - Using Contacts | 1 | February 15th 06 01:43 PM |
| How do I export the calendar data to a XML file? | Satya | Outlook - Calandaring | 1 | January 30th 06 06:18 AM |
Linear Mode
