Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Can I create a report accessing Outlook email form data? (http://www.outlookbanter.com/outlook-vba/72345-can-i-create-report-accessing.html)

Diane Poremsky [MVP] May 21st 08 01:01 PM

Can I create a report accessing Outlook email form data?
 
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?



Sue Mosher [MVP-Outlook] May 21st 08 01:57 PM

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?




All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com