How to open a new Outlook email by filling some range of an excel worksheet using VBA?

Dear Excel Masters,

I have the following:

[C1] My dynamic email subject
[C5:C10] My dynamic email body message
My recipient is always same "[email protected]"

Now, I need a VBA code, that will

• automatically open a blank new outlook email window
• fill the fixed recepient
• fill the dynamic subject and body of the message from a range in my workbook

Then just stop there so that I can attach some different files each time and send myself.

Could you please help me about it? I found some other codes but they didn't help me.
If i can manage, i will distribute it to my colleagues and i may gain my boss's praise.

Well since my message dropped on page 6, I wanted send a new and last post to mention that my problem is still unsolved :D

Thank you very very much. You helped me a lot. May God bless you.
I hope you would get amazing news in a few days for your life