Send Excel file by email, but Not to Save

Hi Folks

I need to prepare an Excel file, send it by email, but not to save it, using a Macro. What must be entered into the subject field is found in a cell in the file. In this case, Cell E2. I've attached an example. No recipients to worry about.

Many thanks

Patish