Email to appear as PART of workbook

[Swhitgob]

Using Office 2007. I want to save an excel template to be filled out and have the top part where the regular tool bars and such are, actually "appear & function" like an email. I would be able to prepopulate the intended recipients adrs and subject line. And then my staff would simply open the template, do what they need, hit send and it obviously emails.

I thought this would be an excel template. But I can't find anyway to do it. I've never created one previously but did have a coworker at some point with files like this.

Does that sound familiar to anyone? Hope this makes sense.

Thanks in advance,
Shalon