Automatically sending Outlook mail

[whytheq]

Hello,

I've got several excel routines which create emails at the end to
alert people of files that have been created - just wandering if in
Office 2007 it is possible for these mails to Send automatically - at
present the mail appears on the screen in it's Inspector but you have
to press the Send button.

There used to be a way around this using a third party library called
Redemption but was wondering if Microsoft have now built redemption
into Outlook.

Any help appreciated
Jason.

 

[Ron de Bruin]

In Office 2007 there is no security warning anymore
http://www.rondebruin.nl/mail/prevent.htm

For code examples to mail see
http://www.rondebruin.nl/sendmail.htm

 

[whytheq]

In Office 2007 there is no security warning anymorehttp://www.rondebruin.nl/mail/prevent.htm

For code examples to mail seehttp://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm








- Show quoted text -

Thanks Ron - hadn't even tried just replacing .Display with .Send as I
thought the warnings would still be there.

all the best
Jason