Solved

Supress message 'a program is trying to send an email'

Posted on 2013-06-20
11
1,281 Views
Last Modified: 2013-07-01
    ActiveWorkbook.EnvelopeVisible = True
   
    With ActiveSheet.MailEnvelope
       .Introduction = "This is a sample worksheet."
       .Item.To = "aravinds@fastfrate.com"
       .Item.Subject = "My subject"
       .Item.Send
    End With

Open in new window


Hi,

I am using the above code. Unfortunately there are no alternative due to the fact I must keep the formatting of the sheet alive.

Now this code works except I get a msg saying 'a program is trying to send email on your behalf..."

How do I supress this? (the method has to work in other computers as well - I cannot download a plugin, etc)

Any help is appreciated
0
Comment
Question by:Shanan212
  • 4
  • 4
  • 2
  • +1
11 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 39264277
Use Outlook Redemption.

Title: Outlook Redemption download
Link: http://www.dimastr.com/redemption/download.htm

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 39264294
>the method has to work in other computers as well - I cannot download a plugin, etc

Then you can't use Redemption.

It's an Outlook message.

Perhaps a solution here:

Title: A program is trying to send e-mail on your behalf , how to bypass this message
Link: http://www.pcreview.co.uk/forums/program-trying-send-e-mail-your-behalf-bypass-message-t2091096.html

Kevin
0
 
LVL 7

Expert Comment

by:dec0mpile
ID: 39264295
Try adding the following code before:

Dim SecurityManager As New AddinExpress.Outlook.SecurityManager 
SecurityManager.ConnectTo(outlookApp) 

SecurityManager.DisableOOMWarnings = True 

Open in new window

0
 
LVL 13

Author Comment

by:Shanan212
ID: 39264413
Kevin,

Would this require the user to manually edit their own macro settings?

Dec0ompile,

I've tried that before and its apparently a plugin?
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 39264449
>Would this require the user to manually edit their own macro settings?

Yes. Otherwise anyone could send emails without the user knowing. That's the whole point of the security blocks. But they only need to do this once.

Kevin
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39264545
You can change the setting about suspicious activity here: Tools>Options>Trust Centre>Programmatic Access.
0
 
LVL 13

Author Comment

by:Shanan212
ID: 39265953
Ok,

The purpose of this specific function is to send in ghost-emails from our customers when they select a specific product that they normally don't ship with us.

So the ghost email essentially tells us what info they looked for (price quote) and then during our next meeting, we can approach them for a potential business opportunity,

So the email has to be hidden/background and the customers are not expected to know 'how to tweak' the macro settings. However, we will tell them that the the program will communicate with us regarding their price quotes (so that its not entirely an illegal process)

At this situation, what are my options?

I know, sendkeys are one. Any other?

Eg: Possible to 'grab' the window controls of the email and then tell it to send it?
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39266038
Even if your motivation is entirely in the interest of the customer, you will have to circumvent security measures, and thus open the door for even worse malware.

I suggest that you involve your legal department before implementing anything of this nature.
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 39266702
Better yet, don't use email. Get your web developers to build a web service that you can hook into. This is how everyone else does this.

Even if you don't have a web development team or even a web site, you can set up a file server and dump files on it.

There are 101 ways to do this other than hijacking the user's email. Consider also that by doing so, even though you have notified the user that your software will be "phoning home," you have NOT notified them that their email address will be used and thus known by you. THAT is an egregious breach of trust. It would certainly piss me off ;-)

Kevin
0
 
LVL 13

Accepted Solution

by:
Shanan212 earned 0 total points
ID: 39278917
Sorry for getting back to the question late.

I decided to go on with using the email feature but to add a event-listener class and '.display' method

Public WithEvents itm As Outlook.MailItem

Essentially, I am waiting to see if customer clicked 'send' on the email that will send out the email. Then using the event-listener I am initiating other subs.
0
 
LVL 13

Author Closing Comment

by:Shanan212
ID: 39289410
No direct solutions but had to go through near alternative solution.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now