skyberg
asked on
Sending mail via Access
Hi !
I have developet a archive-system in Access for looking up and communication with any object locally or globally.
One of these objects is mail, making it possible to send
e-mail to adresses not contained in the adress-book in a wery fast manner.
After having converted to Windows-2000 this has become a
problem.
The statement in question is the following:
DoCmd.SendObject , , , <Adress>, , , <Subject>,<Message>, True
It works the first time, but seems to be locked after that
Is there a setting in Outlook or somewhere to solve the problem ?
Jan
I have developet a archive-system in Access for looking up and communication with any object locally or globally.
One of these objects is mail, making it possible to send
e-mail to adresses not contained in the adress-book in a wery fast manner.
After having converted to Windows-2000 this has become a
problem.
The statement in question is the following:
DoCmd.SendObject , , , <Adress>, , , <Subject>,<Message>, True
It works the first time, but seems to be locked after that
Is there a setting in Outlook or somewhere to solve the problem ?
Jan
Nevaar
What do you mean by "seems to be locked"? What happens (or doesn't happen)?
You may want to check out this link http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/181/qid/49081 as it offers you a solution or check the MS kb Q260819 - ACC2000: SendObject Method Fails in Access 2000 where this problem is detailed.
ASKER
Hi Nevaar !
By saying "seem to be locked" I mean that nothing happens
when I perform the statement mentioned above the second
time. The first time, the Outlook-form opens nicely for
keying in the text. When I close the Access-app and open
again, the statement works OK.
Jan
By saying "seem to be locked" I mean that nothing happens
when I perform the statement mentioned above the second
time. The first time, the Outlook-form opens nicely for
keying in the text. When I close the Access-app and open
again, the statement works OK.
Jan
ASKER
Hi manuelac !
The item You refers to on Tek-tips, suggests there is
some upper limit in number of characters in the message.
In my case, the number is far below 100 chars.
In my system, the SendObject opens up for manual input.
It is therefore only the mail-adress, a fixed subject and
some openning phrases that is automated.
The rest is keyed inn manually.
When I mail myself, it works ok the first time.
The second time, nothing happens.
Jan
The item You refers to on Tek-tips, suggests there is
some upper limit in number of characters in the message.
In my case, the number is far below 100 chars.
In my system, the SendObject opens up for manual input.
It is therefore only the mail-adress, a fixed subject and
some openning phrases that is automated.
The rest is keyed inn manually.
When I mail myself, it works ok the first time.
The second time, nothing happens.
Jan
Hi Skyberg
Unfortunately that's all I could find on the net. We are having the same problem with one of our db running on A2K, the SendObject works once only, then it silently fails. Only by exiting the application and relaunching again we get it to work again 1 more time! If you find a solution please let me know. Thanks.
Unfortunately that's all I could find on the net. We are having the same problem with one of our db running on A2K, the SendObject works once only, then it silently fails. Only by exiting the application and relaunching again we get it to work again 1 more time! If you find a solution please let me know. Thanks.
ASKER
I will.
I keep the case open until futher.
Jan
I keep the case open until futher.
Jan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks (at last)
Jan
Jan