Exporting data from an email template to excel   

I am using MS Outlook 2003 and am creating a template email which will have 
various drop down fields which have to be picked before the email is sent to 
various groups. I am looking to have the information sent out by email, 
exported automatically into an Excel spreadsheet with columns for each of the 
fields. Is this possible?

date: Wed, 10 Sep 2008 15:16:15 -0700   author:   big_chief_hutch

RE: Exporting data from an email template to excel   

Yes, that's possible. You can use a published form, not a saved .oft file 
template, with code behind it to open the worksheet, read the data from 
Outlook, and fill in the cells. You might find the Excel-related samples at 
http://www.outlookcode.com/article.aspx?ID=23 useful.

Note, however, that using a custom form to send to non-Outlook recipients 
can cause attachment problems for those recipients. 

-- 
Sue Mosher, Outlook MVP
   Author of Microsoft Outlook 2007 Programming:
     Jumpstart for Power Users and Administrators
    http://www.outlookcode.com/article.aspx?id=54 




"big_chief_hutch" wrote:

> I am using MS Outlook 2003 and am creating a template email which will have 
> various drop down fields which have to be picked before the email is sent to 
> various groups. I am looking to have the information sent out by email, 
> exported automatically into an Excel spreadsheet with columns for each of the 
> fields. Is this possible?

date: Wed, 10 Sep 2008 17:00:01 -0700   author:   Sue Mosher [MVP-Outlook]

RE: Exporting data from an email template to excel   

This may do what you need.  http://www.qvlweb.blogspot.com  Allows you to 
collect data into a folder and copy it all out at one time.

"big_chief_hutch" wrote:

> I am using MS Outlook 2003 and am creating a template email which will have 
> various drop down fields which have to be picked before the email is sent to 
> various groups. I am looking to have the information sent out by email, 
> exported automatically into an Excel spreadsheet with columns for each of the 
> fields. Is this possible?

date: Fri, 19 Sep 2008 22:00:01 -0700   author:   JimmyE