VBA to Remove Images in Email Body?

Not sure if this is something that can be answered here, I normally get help with Excel stuff

So something broke with our Outlook at work. We get some generated order confirmation emails that have images in the body, which no longer show up when using excel and if you try to edit the email or forward, it will crash. It's been broke for a month now, IT hasn't been able to fix it.

I need this workaround so that I can edit these emails, a VBA macro that will simply remove images in the body (without converting it to text, I need it to remain HTML to keep the other formatting)

Thanks in advance if possible.

I should have specified it more clearly I think. I need to keep the emails in my inbox. These are order confirmations and I typically just edit the email in Outlook adding notes to the top to keep track. Right now due to the error/crashing I have to manually delete all the images in the email before I can save the edits I have made.

Hmm, let me think on this one.

There is no simple method other than setting .BodyFormat to olFormatPlain to remove images that I'm aware of.

I'd imagine you'll need to find <img ...> tag and remove them from .HTMLBody or at least edit src property.

Yeah that was my thoughts..the changing to Plain format didn't work as it makes a mess of the information

Try this. Uses Regular Expression to find img tags and replace with null string.

Please Login or Register  to view this content.

Yes it worked!!! Thanks!

You are welcome and thanks for the rep

If this solved your query, please mark the thread as solved by using thread tool found at top of your initial post.

I tried a bunch of stuff, I could get some Reply button things to work (like placing a subject) but it wouldn't run a macro and I could not find another way to check for text or anything..struggling on this one.

Apparently this is a known issue from Microsoft for the last 10+ years. They fix it sometimes then break it with another update. It's super frustrating!

I had to do it like this, but I couldn't, thanks for helpful guides

I stumbled upon this solution and it still works great. However, I noticed that after I run the macro, even though the inline images get removed, the size of the email remains the same after I close the email and click on "Save" upon being prompted that it has changed.

I am trying to understand why the size of the email is not reducing even through the images are getting removed.

Regards

Originally Posted by denallpan

I stumbled upon this solution and it still works great. However, I noticed that after I run the macro, even though the inline images get removed, the size of the email remains the same after I close the email and click on "Save" upon being prompted that it has changed.

I am trying to understand why the size of the email is not reducing even through the images are getting removed.

Regards

Great !!!!!!