Automatically Email an excel workbook as an attachment

[SarahMH]

Hi

I am still a beginner and know that this is proberably really simple but does anyone have sample code that will enable me to email a specific workbook to a specific person and c.c. to four other people - but running the code in another worksheet.

Many thanks in advance

 

[dyarwood]

Have a look at the FAQ

faq707-3564

 

[SarahMH]

Thanks, I did have a look but couldn't find it - obviously didn't look hard enough!

I have sorted it myself though - thanks anyway

 

[dyarwood]

You might have to add in the reference to Outlook. What code have you tried so far?

 

[SarahMH]

Thanks

I am managing to send the email but I was wondering if there is any way of turning off the message box that pops up asking if you wish to send the automated email?

 

[dyarwood]

Guessing you are using XP. The message is a built in warning and as far as I know there is no way of turning it off without using third party software.

 

[SarahMH]

Thanks

I'm still on 2000, but I didn't think there was. Thank you for your help!

 

[PHV]

Do a google search for outlook object guard model
Redemption seems a good stuff.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244