Hi guys,

I need to use VB to send an email from my spreadsheet. The spreadsheet is quite large, but I only want to send a carefully selected number of rows and columns.

Column D of the sheet contains a either the number 1,2,3, or "----". This column is used to flag up the seriousness of issues within the business with "----" indicating no issue, and 1,2, or 3 highlighting progressively more serious issues.

I want to be able to search for all those rows that have either a 1,2, or 3 in them. For these rows I then want Excel to pull together a very small table showing the corresponding cells from Column C and Column F. I want this to be sent to 2 email recipients (the same ones each time). I want this all to be executed at the click of a button in the worksheet.

This one is going to be extremely useful within my department so any help would be greatly appreciated, even if it doesn't get me the whole way. If anyone needs more info please let me know.

Thanks in advance!

Christian