Excel 2007 : Email worksheet (not entire workbook) to various recipients

[FDibbins]

I downloaded a macro to email a specific worksheet within a workbook, but you have to hard code the recipient. The macro works perfectly, its only drawback is the hard coded email addy. I use MS outlook, and I assume that the macro opens Outlook invisibly when it sends. Can anyone advise me on how to improve its functionality to allow the user to add their own "to" recipients? Ideally, I would like Outlook to open to allow the user to enter their own adresses, and then "send" as normal.

I have seen some of the "miracles" the gurus here have produced in excel, so Im sure this will be a breeze. Thanks in advance.

Below is the part of the macro that does the "send"

Please Login or Register  to view this content.

[DonkeyOte]

Change "myemailaddy@somename.com" to "" and the user will be prompted via OL dialog.

Technically you are emailing a workbook in it's entirety, however, that workbook contains only the desired sheet(s) from the original source file

[FDibbins]

HA awesome, works just the way I need it to

You guys are fantasitc, thanks