Auto Mail Using outlook is Going through..

[vineetmadaan]

Dear All,

I am in the urgent need of advise. I am trying a automate a mail to send a data in the Mailbody. Everything is working perfectly fine except the one step that is a sendkey command to send the mail. Please check below my code.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time but future violations could result in an infraction. --6StringJazzer


Requesting Available experts to advise the best alternative for the problem.

Thanks
vineet

[TMS]

Why don't you use .Send rather than messing about with the very unreliable SendKeys?

[vineetmadaan]

Hi,

Thanks for your revert.

Actually I tried using that as well. But using that it throws a Outlook popup that "Another programme is trying a send a mail on behalf of you". So each time I would have to allow this manually to surpass the warning. So i am looking for a way to automate this. So that each time we would not have to allow the mail manually.
Thanks

[vineetmadaan]

Hi Everyone,

Any Suggestions. Urgently Need your help.

Thanks

[TMS]

Actually I tried using that as well. But using that it throws a Outlook popup that "Another programme is trying a send a mail on behalf of you". So each time I would have to allow this manually to surpass the warning. So i am looking for a way to automate this. So that each time we would not have to allow the mail manually.

Then that's the issue you should be researching, not how to create a messy workaround using SendKeys.

In Outlook 2007 (might be a slightly different route in 2013):

File | Options | Trust Center | Trust Center Settings | Programmatic Access | The default setting is: Warn me about suspicious activity when my antivirus software is inactive or out-of-date (recommended) ... tick that if it is not set.

https://www.msoutlook.info/question/883

And, obviously, make sure your AntiVirus software is up to date for this to be effective.

Last note: please don't "bump" your thread after only 18 minutes from your last post (and 22 minutes after a response from someone else).

[6StringJazzer]

Your post does not comply with Rule 3 of our Forum Rules: Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7.

[vineetmadaan]

Hi,

Really Appreciate your revert.

There was network issue going on or slowness in the Server because of which My post was not going through. So i accidentally submit the post multiple times. As i am not a frequent user of the forum, I tried to Unsubscribe or delete the One of the posts but could not do that. So I apologize for the multiple post of the same thread.
Thanks for the help.

[vineetmadaan]

Hi 6StringJazzer,

I highly regretted for the inconvenience caused. I was not aware of the format for posting any query. Will be adhere to policies and rules next time.
Thanks

[6StringJazzer]

Hi 6StringJazzer,

I highly regretted for the inconvenience caused. I was not aware of the format for posting any query. Will be adhere to policies and rules next time.
Thanks

Thanks. But please go back and edit your original post to add the CODE tags as described above. At the bottom of your post is a link for "Edit Post."