View Single Post
  #2  
Old May 21st 08, 01:57 PM posted to microsoft.public.outlook.general,microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Can I create a report accessing Outlook email form data?

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


"Diane Poremsky [MVP]" wrote in message ...
Yes, you can use addins to do this. If you use newer versions of Office,
infopath or other method might work too. See the experts in program_vba
newsgroups for specifics.

[cross-posted to microsoft.public.outlook.program_vba]

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips:
http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:




"cdorm" wrote in message
...
We have created a custom form in Outlook that we will be using in email
correspondence. I have received a request to create a report or query
that
accesses the data in the email form and lists the values. Is it possible
to
pull data from emails into a report or query format?


Ads