I have a macro which I call from other macros, which saves the workbook with a new name based on the content of 2 cells in the active sheet, and then closes the newly saved workbook.

I need to add a code that will attach the newly saved file to a new outlook email. The email doesn't need the addressee populated, but it would be cool if it populated the subject with the same name as the saved file (minus the file extension). Then close the workbook, but leave the email up and ready for the user to fill in the address and body and send it manually.

Sub SaveAsEmailCopy()
Dim sFilename As String
sFilename = Range("c11") & " - " & Range("C14")
ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & sFilename
ActiveWorkbook.Close
End Sub
I've seen a number of discussions on variants of this online, but I couldn't figure out how to adapt it to this.