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?

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question