Sending a copy of spreadsheet to mailrecipient; mail adress indicatedin a cell in the spreadsheet

[Snoopy]

Hey guys
I believe there is a way to make a macro that will send a copy of my
spreadsheet (values/+formats) as a new Excel-file attached to the mail
- dedicated mailrecipient is indicated in a cell in the worksheet.

I cant figure it out.
Are there any compassonate Excel-guru who can lead me to this devine
level of knowlegde?

Most kindly regards
Snoopy

 

[Dave Peterson]

Ron de Bruin has lots of tips here:
http://www.rondebruin.nl/tips.htm

 

[Nils Morten]

Ron de Bruin has lots of tips here:http://www.rondebruin.nl/tips.htm

Thanks Dave
I appreciate your help, but my network dont allow me to downloud add
ins like this (company policy bla bla bla ...) - i think that was your
advice (a good one too).
Then I have to edit my macro code manually.

Regards
Snoopy

 

[Dave Peterson]

If you can get to the site, you'll see that Ron has lots of code to use with
emailing. You don't need the addin.

You can just copy the code and paste into a text file (or directly into the VBE
if you want).

 

[Nils Morten]

If you can get to the site, you'll see that Ron has lots of code to use with
emailing.  You don't need the addin.

You can just copy the code and paste into a text file (or directly into the VBE
if you want).









--

Dave Peterson– Skjul sitert tekst –

– Vis sitert tekst –

Thanks a lot