Exporting data from an email template to excel

[big_chief_hutch]

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?

 

[Sue Mosher [MVP-Outlook]]

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.

 

[JimmyE]

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.