Excel Macro amendment

Job ID: 33877561

Budget: $30 – $250 AUD

I need the attached photo, from 3 buttons into 1 if possible.

Also, i would like for the email to be auto generated on the basis of the macro, rather then clicking a button and manually deciding if it needs to be done .

I have the existing spreadsheet, i just need an amendment to it .

thanks,