Macro code EXCEL

Hi, Request help regarding sending Remittance to each supplier(company) when Clicking Column Q (if possible "Send Button/link" for particular supplier and "Send All" for sending all in one go)

Email can be send from default outlook email and email format is mentioned in same sheet.

Excel file attached herewith

Thankyou.

Regards