Hi All

I am looking for some help to create code fro the following.

I need a button the sends the entire workbook as an attachment in an email to the email address in cell "a1" and Cc to 2 other fixed email addresses.
I also need the subject field to consist of the contents of other cells in the workbook.

It needs to be in the following format.

to: "Cell B30"
Cc: "recipient1@email.com", "recipient2@email.com"
Subject: Completed: "cell B9", "cell B7", Account Number "cell B38"

Email body: "SITE ADDED TO ADMIN TOOL"

Is anyone able to help me with this?