![]() |
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
|
|||
|
|||
![]()
Hi Sue,
thank you for your reply. I had subsequently found your reply to a similar question and tried this which works fine but I will have a go writing my custom VBA code too. Thanks for your help. Boselli "Sue Mosher [MVP-Outlook]" wrote: Outlook doesn't support exporting custom fields directly. 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. If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legaul...4/08/4502.aspx The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/article.aspx?ID=23 -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Boselli" wrote in message ... I have created a message form in Outlook 2003 which is being used in the office. I now need to export text from these forms into an excel spreadsheet however 4 of my user defined fields that I created do not show up on the Map Custom Fields option when I export. I think they need to belong to the all mail fields group for them to show up in Map Custom Fields but I don't know how to get them there. Please could you help? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
importing custom fields into a custom form | susan lasalle | Outlook - Using Contacts | 1 | January 16th 07 10:01 PM |
Accessing custom fields in Outlook with VBA | netnews.comcast.net | Outlook and VBA | 2 | October 20th 06 12:13 PM |
Accessing custom fields in Outlook with VBA | netnews.comcast.net | Outlook and VBA | 0 | October 19th 06 07:50 PM |
Customizing Custom Fields in Outlook | kypy | Outlook - Using Contacts | 1 | July 28th 06 09:34 PM |
copy custom task with custom fields | VinceGSMW | Outlook - General Queries | 3 | May 31st 06 04:11 AM |