Outlook email from MS Access

[murthyspd]

Hi

I have written a code that composes a new mail from MS Access. It does what i need. It also gives a question before displaying the mail body :
"A program is trying to access e-mail addresses yo have stored in outlook. Do yo want to allow this ?"

If I give yes, it proceeds with composition. If I give No, it gives an error "Application-defined or object defined error". Is there any way I can avoid this error, or if possible with the dialog box itself.

 

[Jhitch]

And me

I am trying to solve this problem particularly as the message appears for every contact the code is emailing ie 10 contacts 10 messages! So far i have only found this knowledge base article which seem sto suggest there is noy really an easy way roud it. Read it and let me know if you can use it to hep. I dont really understand it. http://support.microsoft.com/kb/263084/en-us

 

[FireStrike]

I would suggest to just find the variable that is not declared, and declare it. But you can usually remove the option explicit without any problem. Any variable not declared will be assumed to be a variant type. this is normally not a problem, unless you try to do this with large arrays, then you can start to run short on memory. but if your program is relativly small, then you should be able to remove the option explicit with no problems.

 

[FireStrike]

hmm sorry bout that last post, that was wierd, I was looking at a different message, and when it posted, it put it here very odd indeed

 

[yeatmanj]

I have found a solution to this problem using a reference library called Redemption. It works very well at bypassing the security messages. Please make sure to read the site thoroughly because my knowledge of this library is as limited as yours and I will not be able to help answer questions. Also, if you are planning distributed applications, please do the right thing and purchase the library.

Here is the site.
http://www.dimastr.com/redemption/