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

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?

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

File, Send to, Mail recipient as an attachment

"Vick" wrote:

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?

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

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


On Thu, 17 May 2007 09:41:04 -0700, Vick wrote:

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?

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

Hi Vick

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vick" wrote in message ...
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?

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

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.

"Simon" wrote:

File, Send to, Mail recipient as an attachment

"Vick" wrote:

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?