Dear Excel Masters,

I have the following:

[C1] My dynamic email subject
[C5:C10] My dynamic email body message
My recipient is always same "burak@burak.com"

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.