DoCmd.SendObject leaves recipient field blank?

[Jay Bienvenu]

I am trying to execute a DoCmd.SendObject command to produce an email
message from Access 2000. The command produces the email message, but
the To:, CC: and BCC: fields are blank. The subject field and content
come across fine.

I can verify that the information isn't leaving Access. My client is
experiencing the same problem. I tried it on two different computers;
same problem.

[Jay Bienvenu]

I would appreciate some assistance on this.

[Pavel Romashkin]

Could you please include some code that fills in the To field of the
DoCmd.SendObject? Usually people on this NG tend not to rely upon the
"it didn't work" kind of description but like to see the code that fails.

Pavel

Jay Bienvenu wrote:

I am trying to execute a DoCmd.SendObject command to produce an email
message from Access 2000. The command produces the email message, but
the To:, CC: and BCC: fields are blank. The subject field and content
come across fine.

I can verify that the information isn't leaving Access. My client is
experiencing the same problem. I tried it on two different computers;
same problem.

[Jay Bienvenu]

Pavel Romashkin <pa*************@hotmail.com> wrote in message news:<3F***************@hotmail.com>...

Could you please include some code that fills in the To field of the
DoCmd.SendObject?

DoCmd.SendObject , , acFormatTXT, "[e-mail]", "[e-mail]",
"[e-mail]", ".", strShortMessage

-- Jay Bienvenu

[Pavel Romashkin]

I don't see problems with the code, works just fine on my machine in
immediate window. What do you see in the message window that pops up
once the DoCmd.SendObject is executed? If To: field is blank, I'd
suspect a MAPI client problem.
I have experienced random message loss in Access 2000 and Outlook
Express 5.5 as MAPI client. However, Access 2002 worked fine with OE5.5
and 6. I read that people complain about OE MAPI implementation, so this
may be the problem if this is what you are using.

Pavel

Jay Bienvenu wrote:

Pavel Romashkin <pa*************@hotmail.com> wrote in message news:<3F***************@hotmail.com>...

Could you please include some code that fills in the To field of the
DoCmd.SendObject?

DoCmd.SendObject , , acFormatTXT, "[e-mail]", "[e-mail]",
"[e-mail]", ".", strShortMessage

-- Jay Bienvenu

[Jay Bienvenu]

He's using 6.0.

[Jay Bienvenu]

Since it's pretty clear that there's nothing wrong with the code, how
can I fix the problem? How can I explain to the client what the
problem is and how to fix it?

[Pavel Romashkin]

Sorry for the late reply - I was away.
In your case the simplest solution seems to be to form the URL
programatically - I am not even sure why would you send a MAPI request
to an interpreter program like Yahoo Mail. Might as well talk straight
to IE.
As far as using OE with A2000, I don't even know what to recommend. I
read quite a bit on this subject, as I still can't get my own client's
DB to E-mail consistently fom A2000 and OE, and I think I will try to
use Outlook on their system to mail for me. Outlook (not Outlook
Express) is said to be a much better MAPI compatible than OE.

Pavel

Jay Bienvenu wrote:

Pavel Romashkin <pa*************@hotmail.com> wrote in message news:<3F***************@hotmail.com>...

I don't see problems with the code, works just fine on my machine in
immediate window. What do you see in the message window that pops up
once the DoCmd.SendObject is executed? If To: field is blank, I'd
suspect a MAPI client problem.

I didn't think that it was anything wrong with the DoCmd.SendObject
command itself. I use the Yahoo Mail program as my default email
"client." It sends a URL to IE that goes to Yahoo Mail. When I issue
this command in the Immediate window:

DoCmd.SendObject , , acFormatTXT, "[e-mail]", "[e-mail]",
"[e-mail]", ".", "blah blah blah"

Yahoo Mail sends this to IE:

http://us.f96.mail.yahoo.com/ym/Comp....redir=ymmapi3

Notice there's nothing after "To=". However, if I type
"mailto:[e-mail]" in the Address bar of IE, it produces this:

http://us.f96.mail.yahoo.com/ym/Co**....redir=ymmapi2

Clearly, the problem is in what's going from Access 2000 to Yahoo
Mail.

I'll ask my client what version of Outlook he's using. Using Access
2002 isn't an option at this point. We are going to have to find a way
to get around the problem, because as long as it does this, the
solution doesn't work.

-- Jay Bienvenu