Emailing a page in workbook

[hawee]

Hi

I have excel 2007 and was wondering if this is possible.

I have a workbook and there are a bunch of tabs. Is it possible to add a button to each worksheet that will auto email that individual worksheet?

If so, please tell me how.

[royUK]

You need VBA.

See Ron de Bruin's email examples

[hawee]

i'm fairly new to this

im looking at his stuff, im tried applying one of the codes, but done see where a button to send the page is at.

[hawee]

its working, its emailing the page when i try running it in VB but when it i open the doc in my email it opens vb page not the excel page, how do i add a button to the excel sheet that'll send the sheet?

[hawee]

okay, so i got it working and was able to place a button,

now i've run into a big problem

each worksheet needs to be assign to a certain email address, as of now it will only send to one email address.

any ideas?

[martindwilson]

which method are you using?