Automatise emailing on request

Dear Sir,

I'm mac environnement. A use a excel file to generate invoices in pdf format. Then I have to email to corresponding client. Can you code a macro inside excel so that once invoice is ready a pdf is generated automatically and sent to corresponding people with predefined message ? Or at least once pdf are made manually, can they be sent to specific people depending on the file name ?

Best,

Agilane