Macro to send email

[jackspade9]

Hello expert,
Can you please help to create macro as per below, I am still a beginner and I would like list that will send email:
- check if there is any dates less than 30 from today dates in Column C
- it will not include anything in Column F that categorized as scrapped
- if above is true, then macro will create new spreadsheet that attached to the email. Also auto rename the file.
- it auto sorted the data by ascending in column B

thank you and appreciated it.

JS