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

Pallet SU	Scan Part Below	Search	Action
123456	631809200105786044801200	on suspect list	Remove from pallet and store

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

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