Excel

Email selection as Images

Ivan F Moala

Can Do

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

This page was last updated on: March 16, 2008

There are times when you may wish to Email a sheet selection in the body of an Email. One of the 1st codes I saw that did this was from DK (Dan) found here and here (Hall Of Fame entry)

This code is incorporated in the Html Maker and here also @ HtmlMaker 2.42

But what if you wanted to include graphics, Chart or just a selection of visible cells eg Autofiltered range selection or a combination of all of these. Most coding will not do this for you and using Html coding for a selection will include all cells (Autofiltered) unless explicitly coded for.

Using an Image, you can show just the Autofiltered results >>>

Below is a routine that will Email a selection as an Image, OR with a few changes you could reference a Image File from within your Drive eg A Logo, signature etc.

A picture is indeed worth a thousand words, see example Email image below.

Image of resultant Email code

Get Example WorkBook here

Currently under construction;

Emailing multiple images

Email addin

If you're using Windows XP, you know how important it is to have all the necessary laptop parts to run the programs. If you don't have enough memory, you may find that your laptop fan is running constantly or your laptop battery isn't holding up well. Make sure you have all the parts you need to keep XP running.