Emailing worksheets from Excel to outlook?

Question

Hi
I have been given the following challenge and am at a loss with it.
We have a excel workbook with lots of worksheets they need to be together in one wb for other reporting but we now need to send out each worksheet to a different email address - I figure that if I put the email address for each recepient on "their" worksheet in the same cell on each worksheet this should be possible.

I am not used to using excel VBA but reckon that may be the only option.
Any help would be very much appreciated

Answer 1

I don't know of a way to send only one worksheet from a workbook. But, you can go to File>Send to>Mail recipient and it will give you the option of sending the whole workbook as attachment OR sending the current worksheet only, as the message body text.

This could work if the recipient doesn't need to do Excel calculations after he receives it.

Answer 2

very almost each place of work app has a deliver to menu get entry to. In my version of Excel it particularly is document | despatched To | Mail Recipient. It attaches the worksheet and opens up a sparkling message type interior the device's default mail customer. you have got your button in simple terms execute that command.

Answer 3

Try this site, there may be something there to help you. Its a long list so you will have to scroll down. Hope you find it.