• 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.

email problem from excel

aliasger.q

New Member
hello everyone

i have design one template in 2003 excel for mail merge and every thing is working fine but only one problem which i am getting is that when i try to send button in my excel so after completing full process give me warning message


A PROGRAM IS TRYING TO SEND AN EMAIL MESSAGE ON YOUR BEHALF,

DO YOU WANT TO ALLOW THIS.


and how to avoid this message because every time i have to press yes button in this message for send mail.

and yes button can be visible after 5 secound.


please send any possitive reply,

its very very urgent.


thanks
 
Hi, aliasger.q!

Could you please paste the code you're using for that process? Consider uploading a sample file.

Regards!
 
Aliasger.q


I have no experience with trying to do that

However others have and this looks like a solution


http://www.excelforum.com/excel-programming/674566-disable-a-program-is-trying-to-message.html
 
thanks for reply again,


here is link

https://rapidshare.com/files/2003985118/Mail_Merge_updates.xls

or

may be this one

https://rapidshare.com/files/3801969919/Mail_Merge_updates.xls


password for login: 123

password for code: alif.laila


note: please click mail merge button in which getting problem


thanks again.
 
Hi, aliasger.q!


I don't have a 2003 Office version, I'm running a 2010, so I can't reproduce exactly your same scenario.


But Outlook messages prompting for response at each outgoing mail can be omitted with the statement:

SecurityManager.DisableOOMWarnings = False

... not True as it's in your code. So change it to false, and set it again to true before quitting, i.e. in the cleanup section.


Give a try to this and let's see what happens.


Regards!
 
thanks to all,

Now my template is working nice which i wanted but not from


SecurityManager.DisableOOMWarnings = False


this code.


lastly i have downloaded 3rd party application (api function)

and now its working cool with only one click.

thanks again for support.
 
Hi, aliager.q!

Glad you solved it. Thanks for your feedback and consider posting here your solution so as it's available for other who might be interested or need it. Welcome back whenever needed or wanted.

Regards!
 
Back
Top