• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help to avoid popup msgbox while sending an outlook email thru excel

ANKUSHRS1

Member
Hello Friends,

I have created a excel vba program for send email automatically. All works fine but one flaw. attached message occur while sending email. I want to avoid it...please give me solution.
upload_2019-3-20_17-40-5.png
 
Note that that message is specifically there to avoid people using malicious code to send email w/o users knowing. Bypassing it could be considered annoying to some users.

That said, you could get around it by either
a) Just having the email be Show, rather than Send, and let user manually send the email

or

b) Use SendKeys to try and mimic the user sending the email. This can be a bit tricky, as SendKeys is not specific to where the keystroke is going, it just sends the commands.
 
Back
Top