SendObject command doesn't automatically send e-mail

[Jerry Schiffelbein]

In Access 2002-2003, even though I set "edit e-mail" to false, the message is
still opening in a new window (which requires that I click on send) rather
than automatically sending the e-mail. Since I will be sending several dozen
e-mails, it would not work to have to click on each message to send it.

Thanks!

Jerry

 

[ryguy7272]

Try this:
http://www.contextmagic.com/express-clickyes/

I've used it; works great!

 

[Jerry Schiffelbein]

Sorry. I should have specified that I'm using MSN software, not Outlook;
thus I'm not getting that particular Outlook message. What it is doing is
creating the message and then opening it as a separate window rather than
just sending the e-mail.

Thanks!

Jerry

 

[Rick Brandt]

Sorry. I should have specified that I'm using MSN software, not Outlook;
thus I'm not getting that particular Outlook message. What it is doing is
creating the message and then opening it as a separate window rather than
just sending the e-mail.

One of the arguments for SendObject controls that.

 

[Jerry Schiffelbein]

Yes, that is correct. I set the "edit e-mail" command to False; however,
the e-mail was not sent automatically, so the problem still persists.

Jerry

 

[Rick Brandt]

Yes, that is correct. I set the "edit e-mail" command to False; however,
the e-mail was not sent automatically, so the problem still persists.

Post your exact code.

 

[Jerry Schiffelbein]

Here's the code, Rick:

DoCmd.SendObject , , acFormatTXT, "(e-mail address removed)", , , "Test
Email", "Sending test e-mail message", -1

Thanks again!

Jerry

 

[Rick Brandt]

DoCmd.SendObject , , acFormatTXT, "(e-mail address removed)", , , "Test
Email", "Sending test e-mail message", -1

Your final argument is [edit message] and you have set it to -1. -1 is
True, not False, so that is why the message is opened for editing.

I don't think this part matters, but you don't need to specify an object
format when you are not sending an object (no need for acFormatTXT).


DoCmd.SendObject , , , "(e-mail address removed)", , , "Test
Email", "Sending test e-mail message", False

 

[Jerry Schiffelbein]

Hi Rick,

Thank you for your response. Actually I tried -1, 1, 0, True, and False,
none of which made a difference. In my research on this command, I found
that this is apparently a known issue with the SendObject command, so I
believe that there is no further resolution possible with this problem.

Thanks again for your help. It was very much appreciated!

Jerry

DoCmd.SendObject , , acFormatTXT, "(e-mail address removed)", , , "Test
Email", "Sending test e-mail message", -1

Your final argument is [edit message] and you have set it to -1. -1 is
True, not False, so that is why the message is opened for editing.

I don't think this part matters, but you don't need to specify an object
format when you are not sending an object (no need for acFormatTXT).


DoCmd.SendObject , , , "(e-mail address removed)", , , "Test
Email", "Sending test e-mail message", False


.

 

[Rick Brandt]

Hi Rick,

Thank you for your response. Actually I tried -1, 1, 0, True, and False,
none of which made a difference. In my research on this command, I found
that this is apparently a known issue with the SendObject command, so I
believe that there is no further resolution possible with this problem.

Thanks again for your help. It was very much appreciated!

I certainly have never heard of that as an issue with SendObject. Do you
have a source for where you saw this?