Button sending email code - can any change it with slight variation?

[ld2x07]

Hi everyone

I have the code below. You can ignore the first part that relates to mirroring some cells and jump right down to where it saves the file sends it to an email address listed on one of the worksheets. It works fine but I would really like to make it do everything except actually sending the email. I.e. set everything up for the user to edit if need be.

I've tried, with my poor understanding of codes, to simply delete the

Please Login or Register  to view this content.

but that didn't do it.

Any help would be appreciated!

Please Login or Register  to view this content.

[Vidya Palani]

Replace .Send with .Display

It will show the mail in draft version.

[ld2x07]

Hi Vidya,

Thank you for the quick response.

I tried but this still sends the email. I'm probably making some daft mistake

Please Login or Register  to view this content.