i am trying to send an email in the background of a USerform when this Userform is closed, i don’t want to create another window, and the email should be sent without disturbing the person that is using the database. The email should be just that a blank email, if possible with the Subject “Data has been loaded” but not really necessary, is this Possible.??
This article should accomplish that.
That's a bit of a hit or miss, depending on their security settings.and the email should be sent without disturbing the person
You can use Application.ScreenUpdating = False, just before the Send and then =True, after the Send, to minimize screen actions.
David
(*) Reputation points appreciated.
Here is the code.. Give it a try.. Modify it as per your needs..
Please Login or Register to view this content.
Last edited by Vikas_Gautam; 12-26-2014 at 06:02 AM.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Thanks man, this work really nice. two. questions. this work really nice sending from my work computer, will this work in any computer within my network, we all have the same sever and @extension.com?, once i try to send the email it ask me if i want to deny or allow to send an email? is here any way you can prevent that message to show up.
Okay..
I have googled and got the reason behind that 'Allow or Deny' window.
Actually, it were MS Outlook Programmatic access settings (Microsoft's Enhanced Security settings) which were creating the problem.
I have found a fix for it. Download and install the fix and try to rerun the code and see if that shows up or not.
Download page
http://support.microsoft.com/kb/953925
Knowledge page ( Read it for more info regarding the problem)
http://support.microsoft.com/kb/953806
https://social.technet.microsoft.com...ccess-security
Hope this will solve the issue.
I have been able to find a workaround for that Allow Deny nuisance.
Here is the revised code:-
Please Login or Register to view this content.
sorry, Duplicate Post
Due to internet problems.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks