[VBA] Outlook Mail to Excel

[alexgoaga]

Hey guys, I want to extract a complete email using excel and outlook in the same times. (The code is provided in the attached document). I have several issues regarding some emails that contains tables or pictures (pictures to be at least detected or something).

When an email has tables no data is extracted and the location of the data remains blank.

Another issue would be if i can auto-enter in a specific folder from the outlook (it would be easier to create a rule to move an email to a specific folder to anyone.) but it seems like i can't use anything else than the Current Folder idea

Please Login or Register  to view this content.

Also, what's the maximum len of a outlook body in order to be processed by the Excel? (on some long e-mails excel runs out of memory) . I would like to by-pass that error and set to the Body cell row something like "E-mail to long to be processed " followed by the number of that email in outlook (it's possible to implement 2 or more On Error GoTo ?)