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?