Email Range Of Cells

[daddyfoxuk]

Afternoon All, i'm after some help in emailing a range of cells depending on which cell changes to "on suspect list" See example below.

A B C D

[TABLE="width: 858"]
<colgroup><col span="3"><col></colgroup><tbody>[TR]
[TD]Pallet SU[/TD]
[TD]Scan Part Below[/TD]
[TD]Search[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]631809200105786044801200[/TD]
[TD] on suspect list[/TD]
[TD]Remove from pallet and store
[/TD]
[/TR]
</tbody>[/TABLE]

So every time "on suspect list" part appears in "C" ideally an email sent via outlook automatically including the info in A,B,C and D in the email body / subject.

This information is copied over to this sheet using command button from a front sheet.

Any help would be much appreciated!

Thank you!

 

[paulxmw]

HI who are you going to email as there is no email address on your sheet