HeathRobinson
New Member
- Outlook version
- Outlook 365 64 bit
- Email Account
- Office 365 Exchange
I'm using a modified version of Diane's code in the Excel workbook available on the Macro to Export Outlook Fields to Excel Slipstick page
My modification is to list out one row, per attachment, per email (I have a For Each objAttachment within the For Each olItem )
It works fine if the attachment is a true email attachment, but I've found a problem if the file is embedded in the body of the email:
What happens is that a row does get written to the spreadsheet with its details (filename and size in separate columns), but on the second go round I get this:
erroring here:
How do I overcome this?
My modification is to list out one row, per attachment, per email (I have a For Each objAttachment within the For Each olItem )
It works fine if the attachment is a true email attachment, but I've found a problem if the file is embedded in the body of the email:

What happens is that a row does get written to the spreadsheet with its details (filename and size in separate columns), but on the second go round I get this:

erroring here:

How do I overcome this?