ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically sending Outlook mail (https://www.excelbanter.com/excel-programming/429477-automatically-sending-outlook-mail.html)

[email protected]

Automatically sending Outlook mail
 
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

Automatically sending Outlook mail
 
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




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


[email protected]

Automatically sending Outlook mail
 
On 6 June, 09:25, "Ron de Bruin" 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



wrote in ...
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


All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com