Hi there, I've created a userform which is being used by different people. When the userform has been filled out, on the click of a commandbutton I'm trying to get Excel to automatically bring the 'save as' window up to save the workbook, and then, once the user has sorted their file name and directory and clicked save, to attach the current workbook to their default email agent.

The trouble is that I need a bit more than the sendmail command offers. I need the email to contain a body as well as a subject, and obviously the attachment, and I need the email to display rather than automatically send (so the user can add anything if they want).

I'm fine for code doing all this in outlook. But some users are using Lotus Notes.

Does anyone know reliable code for determining the default email client and going from there?