PC Review


Reply
Thread Tools Rate Thread

Capturing Data from a form into excel

 
 
Diego
Guest
Posts: n/a
 
      15th Apr 2010
Hi,

Is there a way to capture data from an outlook form into an excel file?

Sorry but I am new to outlook forms.


Thank you!
 
Reply With Quote
 
 
 
 
Sue Mosher [MVP]
Guest
Posts: n/a
 
      15th Apr 2010

Outlook doesn't support exporting custom fields directly. 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



"Diego" wrote:

> Hi,
>
> Is there a way to capture data from an outlook form into an excel file?
>
> Sorry but I am new to outlook forms.
>
>
> Thank you!
> .
> Submitted using http://www.outlookforums.com
> .
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Capturing form data Bob A Microsoft Outlook VBA Programming 1 26th Jan 2010 02:01 AM
Capturing data from a form Brent Microsoft Excel Programming 1 24th Nov 2007 09:03 PM
Capturing data from a form and writing to a table. JDP Microsoft Access Form Coding 3 20th Sep 2004 01:03 AM
Re: Capturing data record entered in edit mode form Con Giacomini Microsoft Access Forms 2 18th Sep 2003 06:48 PM
External form data capturing Steve B. Microsoft VB .NET 1 5th Sep 2003 11:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:06 PM.