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?

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:
dailytips-subscribe-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)



"cdorm" <(E-Mail Removed)> wrote in message
news:BB6F87A7-3EEE-4854-9EAE-(E-Mail 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?

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]" <(E-Mail Removed)> wrote in message news:4078AF83-DFD3-42E0-83AC-(E-Mail Removed)...
> 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:
> dailytips-subscribe-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
>
>
> "cdorm" <(E-Mail Removed)> wrote in message
> news:BB6F87A7-3EEE-4854-9EAE-(E-Mail 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?
>