E-Mail attachment to same e-mail address in Outlook

[Guest]

I'm trying to find a macro or the easiest way for a user of my spreadsheet to
click a button or link, and send the workbook as an attachment to me. Does
someone know of a way of accomplishing this?

 

[Guest]

File, Send to, Mail recipient as an attachment

 

[Gord Dibben]

Vick

See Ron de Bruin's site for methods and code and/or his Sendmail add-in which
gives lots of choice.

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


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Hi Vick

For code see this page
http://www.rondebruin.nl/sendmail.htm

 

[Guest]

I knew how to do that, I want it set it up so that it automatically sends the
file to me, when the button is pressed. I need it to include my e-mail
address and send not just pop up a new message from outlook.