Exporting data from an email template to excel

  • Thread starter Thread starter big_chief_hutch
  • Start date Start date
B

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?
 
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.
 
Back
Top