I'm using Outlook 2003. I have to admit I'm not real familiar with HTML but
now that you point out that's what I'm dealing with, that does generally
answer my question.

David Allison

"Sue Mosher [MVP-Outlook]" wrote:

The MailEnvelope approach creates an HTML-format message, so processing the incoming data would be a matter of parshing the HTML table. Possible approaches will depend on your Outlook version, which you forgot to mention.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Allison Wonderland" wrote in message ...
I created an Excel form with the MailEnvelope option that is posted on our
department intranet site. Users fill out the form and it is preprogrammed to
go to a specific email box. When the recipient looks at it, it looks like a
regular Outlook email with the contents of the spreadsheet embedded in the
body of the email. Previously I was using a customized Outlook email for
this purpose and I had developed an Access macro to read the data directly
from the custom fields of a selected email and import it into the database to
save on data entry. However, with the new form, I can't figure out how to
reference the data in the email so that I can have a VBA macro read it and
automatically import it into Access. Any idea on how to refer to specific
cells in the email?

David Allison