VBA Code for Multiple criteria auto Filter & sending the mails based on that

Dear Experts,

I think this might be posted earlier by some one else on this forum, & might be sorted out too, but I could not find the same on forum & google for the solution.
Need your help.

I am attaching here the file with code.

What my code is doing now is..
1. sending auto filtered data based on mutliple condition & mail the same in Body of the mail to the respective persons but including last two columns which are actually i added for the execution of this code only

Need your help on :
1. I want to remove last two columns at the time of execution in mail
2. I want that same data which is mailing by code in body as xl attachment too (same data in body & also as attachment too)
3. For every mails, respective Job nos. should be there in Subject line.

Please guide me on the same.
Which kind of changes can fullfill my requirement..

Thanks,
Rajveer