Hi Richard,

In your Email Seminar lesson 26 (collecting data via email)...where you've demonstrated how to read email into access by use of a questionnaire. I would like to know, if this could be done if an excel table which is pasted in the message body can be read into access i.e. looping through each row in the email table.

I would appreciate you expert advice on how this can be achieved.

Regards

Hamish

---

Reply from Alex Hedley:

Once you have the body of the email you can manipulate it just like any string.
Look into the HTMLDocument and parsing XML in vba.