A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can I create a report accessing Outlook email form data?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 21st 08, 01:01 PM posted to microsoft.public.outlook.general,microsoft.public.outlook.program_vba
Diane Poremsky [MVP]
external usenet poster
 
Posts: 12,991
Default 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?


Ads
  #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?


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data files or edit/create new email acount craig Outlook - Installation 1 August 5th 07 05:40 AM
How to create an Outlook form to send data to a database Billy Williams Outlook - General Queries 1 June 26th 07 12:47 PM
Can you create an email form within Outlook? Martin Outlook - Using Forms 1 December 26th 06 08:43 PM
How do I create an activity report from Outlook Calendar? PaulaK Outlook - Calandaring 2 November 1st 06 01:00 PM
How do I create an activity report from Outlook Calendar? PaulaK Outlook - Calandaring 0 October 31st 06 10:59 PM


All times are GMT +1. The time now is 11:35 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-2025 Outlook Banter.
The comments are property of their posters.