I'm using the code below to automatically select a single worksheet and start my email programme. Is it book to get Excel to give a name to the newly created file instead of Book2, Book3 etc? (I'd like it to be called "Quotation" each time so that this appears in the Subject field of the email). I'm very new to VB in Excel, so appreciate your advice.
Thanks for your help