I want to have a macro in an Excel file which does this.

(1) Create an email in Outlook and attach the Excel file (in which the macro is stored) to the email.
(2) Pick up the value from cell A1, say it is "Apple".
(3) The subject line in the email should read "Sending report on [value in cellA1]", in effect, in this example, it should be "Sending report on Apple".
(4) Send the email to [email protected] with cc to [email protected]

I am a beginner on macros, so would need the actual macro code.

Can you help, please? Thanks.