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?

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?

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?