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

Not sure, but I suppose it's an attachment that you can save as a file and
then open as a Excel.Workbook.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Wed, 1 Aug 2007 15:16:03 -0700 schrieb Allison Wonderland:

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

"Michael Bauer [MVP - Outlook]" wrote:



Not sure, but I suppose it's an attachment that you can save as a file and
then open as a Excel.Workbook.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Wed, 1 Aug 2007 15:16:03 -0700 schrieb Allison Wonderland:

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

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

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