Hi all,

I have a file with around 55 columns and 400 rows.

All I need is that the data from columns A, AA, AG, BA, BB to be sent to my email including the headings of those columns that are located in row 4. This is based on the data in column BB that has text "Delivered". So those with "Delivered" should be copied.

A AA AG BA BB
4 No. ATA PORT ATA DEM DEL
5 123 12-09-2016 12-02-2016 2 Delivered
6 234 12-08-2016 12-03-2016 5
7 567 12-07-2016 12-04-2016 7
8 890 12-06-2016 12-05-2016 8 Delivered

Thanks a lot!

Phil