E-Mail just one worksheet, not the whole book

[ilovelagar]

Hi!

I have a workbook with two worksheets. I have an "E-Mail" button within the workbook that, when clicked, emails the entire workbook (using Outlook). The button essentially triggers a macro that makes a copy of the file, opens the dupilcate, mails it, then deletes the duplicate ... all the while the original is still open and not changed at all.

Everything works fine, however I would like to know if there's a way to have the "E-mail" button to just email one of the worksheets. For example, I have two worksheets entitled "WFS" and "CAR". When the email button is clicked, I would like to only have the "CAR" sheet emailed.

Here's the code I currently have in place:

Please Login or Register  to view this content.

Any ideas

Cheers,

[ncmay]

This website might help:

http://www.rondebruin.nl/sendmail.htm

[ilovelagar]

This website might help:

http://www.rondebruin.nl/sendmail.htm

Done & done, it works!

Cheers