Referencing embedded Excel data in an Outlook email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I had thought that might work when I first promised I could do this. I know
how to reference an attachment and thought I could get at individual fields
from there. But the problem is it doesn't come as an attachment. At least
there's no paper clip icon so I'm assuming there's no attachment. Rather it
just seems to be part of the body of the email. That's a good thing in the
sense that all the data and formatting is retained whether you forward or
reply, but it seems to be a bad thing if you want to reference what were
specific fields in the original Excel document with VBA in Outlook.

David Allison
 
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.
 
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
 
Back
Top