Hi all,

I'm pretty knew at VBA, and can't seem to figure this out quickly enough (I estimate it will take me 2 months at current pace), so if anyone can be of assistance, please.

I have a workbook with 3 sheets. I have a button. Now when I press the button I want to 'send to mail recipient' "SHEET 3". I have a set e-mail adress for the "TO" email field, but I have 2 ranges on "SHEET 2" that contain the email adresses that need to go in the BCC field.

After sending, it should save the file as "Chauffeursplanning current date" and pop up a message box saying "file sent"

I hope it's clear what I need, and I hope this is possible. Any help is much appreciated.