Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Supress message 'a program is trying to send an email'
Posted on 2013-06-20
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
4
2- +1
11 Comments
Use Outlook Redemption.
Title: Outlook Redemption download
Link: http://www.dimastr.com/redemption/download.htm
Kevin
Title: Outlook Redemption download
Link: http://www.dimastr.com/redemption/download.htm
Kevin
>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
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
Try adding the following code before:
Dim SecurityManager As New AddinExpress.Outlook.SecurityManager
SecurityManager.ConnectTo(outlookApp)
SecurityManager.DisableOOMWarnings = True
Kevin,
Would this require the user to manually edit their own macro settings?
Dec0ompile,
I've tried that before and its apparently a plugin?
Would this require the user to manually edit their own macro settings?
Dec0ompile,
I've tried that before and its apparently a plugin?
>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
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
Active 1 day ago
You can change the setting about suspicious activity here: Tools>Options>Trust Centre>Programmatic Access.
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?
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?
Active 1 day ago
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.
I suggest that you involve your legal department before implementing anything of this nature.
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
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
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.
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.
Featured Post
![[eBook] Windows Nano Server](https://filedb.experts-exchange.com/files/public/2017/6/24/1329f749-2f43-4bd1-8413-3b5b5ab33fc6.png)
Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month5 days, 18 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.