Sendign email from within Excel
 

I think it is possible to write some VB to send an email from within
Excel. However is there any way to stop Outlook generating the dire
warnings about a program is trying to email.

No I'm not trying to write a mass mailing worm! I need to allow this
functionality on two PCs. I did wonder if the VB was digitally signed
can that certificate be imported into Outlook so that there is in
effect a trust?

Basically I need the ability for an email to go out if a trigger event
occurs in Excel.

I wonder if anyone can offer a suggestion?


Regards

Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile: http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=539461

Sendign email from within Excel
 

Ron de Bruin has some sample code and discussion of using CDO to get around
this:

http://www.rondebruin.nl/sendmail.htm

--
Regards,
Tom Ogilvy

"ccarmock" wrote in
message ...

I think it is possible to write some VB to send an email from within
Excel. However is there any way to stop Outlook generating the dire
warnings about a program is trying to email.

No I'm not trying to write a mass mailing worm! I need to allow this
functionality on two PCs. I did wonder if the VB was digitally signed
can that certificate be imported into Outlook so that there is in
effect a trust?

Basically I need the ability for an email to go out if a trigger event
occurs in Excel.

I wonder if anyone can offer a suggestion?


Regards

Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile:
http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=539461

Sendign email from within Excel
 

Clive,

The best thing I have found that works with all the newest security patches
applied is called Outlook Redemption. It's a dll that you need to register
on your machine, but circumvents the security warning.

http://www.dimastr.com/redemption/home.htm

Robin Hammond
www.enhanceddatasystems.com

"ccarmock" wrote in
message ...

I think it is possible to write some VB to send an email from within
Excel. However is there any way to stop Outlook generating the dire
warnings about a program is trying to email.

No I'm not trying to write a mass mailing worm! I need to allow this
functionality on two PCs. I did wonder if the VB was digitally signed
can that certificate be imported into Outlook so that there is in
effect a trust?

Basically I need the ability for an email to go out if a trigger event
occurs in Excel.

I wonder if anyone can offer a suggestion?


Regards

Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile:
http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=539461

Sendign email from within Excel
 

How do you stop the Outlook message when downloading emails to Excel. I need
the "real email address" on the Outlook message to respond (via Excel). Here
is the code I use (applicable lines only):

strEntryID = objMsg.EntryID
strStoreID = objMsg.Parent.StoreID
Set objSession = CreateObject("MAPI.Session")
Set objItem = objSession.GetMessage(strEntryID, strStoreID)
Let SenderFromAddress = objItem.Sender.Address

At the "Let SenderFrom Address" line is when Outlook issues the following
message:

A program is trying to access e-mail address you have stored in Outlook. Do
you want to allow this? If this is unexpected, it may be a virus and you
should choose "No".


I also download the Contact List (Address Book) to Excel and receive the
same message.


Please understand, the code is working. I just have the bother of answering
the Outlook warning about 50 times per day....sigh...

Thx
MSweetG222