DoCmd.SendObject - Is there a way to have it automatically send 2

[SBendBuckeye]

I would like to use DoCmd.SendObject to create an automated email for a support application. Everything works fine except that it opens the message up in edit mode and I have to manually click send to send the message.

Is there a way to automatically send the message? Everything else is working exactly like I wanted it to work.

Thanks in advance and have a great day!

 

[EliseFreedman]

yes there is.
The sendObject Method has several arguments, one of which is Edit Message. This argument specifies whether the message can be edited before it's sent. Use True (–1) to open the electronic mail application immediately with the message loaded, so the message can be edited. Use False (0) to send the message without editing it. If you leave this argument blank, the default (True) is assumed.

Hope this helps

 

[SBendBuckeye]

Thanks, Elise. I appreciate you taking time to answer. I found that earlier this morning when I dug into it a little bit more. I missed it the first time around.

 

[yimitz]

This may not be the quite the same but in MS-Access 2000 I'm coding a sendmail object but when it sends there is a prompt saying that someone is trying to send a mail on the users behalf and prompting for access to the users address list. Is there a work around so this prompt doesn't come up or a switch I can code to "off" for this prompt?

I assume this is a 2000 security thing with all the viruses sending mail to users personal address lists.

 

[combs]

yimitz -

I had the same problem as you and ended up using a third party program. The program is Winsock Mail and it appears to be working great. You can download it or find out more about it at

http://glowbutton.faithweb.com.

You have to make sure that you have mswinsck.ocx and register the dll after you install the program, but once all is done the program works great.