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.

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


--

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




<(E-Mail Removed)> wrote in message news:943dd54f-2a6d-419e-b75b-(E-Mail Removed)...
> 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.

On 6 June, 09:25, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> 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
>
>
>
> <whyt...@gmail.com> wrote in messagenews:943dd54f-2a6d-419e-b75b-(E-Mail Removed)...
> > 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.- Hide quoted text -
>
> - 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