![]() |
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? |
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