Can I create a report accessing Outlook email form data?

[cdorm]

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?

 

[Diane Poremsky [MVP]]

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]

 

[Sue Mosher [MVP-Outlook]]

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/legault/archive/2005/04/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

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:
(e-mail address removed)



Subscribe to Exchange Messaging Outlook newsletter:
(e-mail address removed)

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?