Email Current Sheet Macro

Hi there,

I tried to write a macro using the code for (Alt+F) followed by D,M,Enter in VBA to follow the toolbar file path for sending a current sheet of graphs (Named range - Application.Goto Reference:="GTC") to a mail recipient. The Macro doesnt recognise the short cut Alt+F.

Can anyone think of a way to email the current worksheet via a macro or perhaps some code that will work for the shortcuts?

Thanks guys

Hi Rookie,

Have you searched this forum ? There are alot of examples and links to sites that have examples.


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

Yeah I jumped the gun with a new thread, sorry guys. Was rushing.

Very helpful link, Cheers ZKat.

You're a champ

there are also some other unique codes for this that i have developed.

For example.

1. email sheet with selective cells, to include saving the file name as a cell reference, and some other tweeks.

if you are after something very specific, let me know and ill see if i can write the code for you in VBA. i am not a complete expert, but love challanges so feel free to request.

Thanks

Alex