By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

DoCmd.SendObject leaves recipient field blank?

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
I would appreciate some assistance on this.
Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

P: n/a
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, "me@example.com", "me@example.com",
"me@example.com", ".", strShortMessage

-- Jay Bienvenu
Nov 12 '05 #4

P: n/a
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, "me@example.com", "me@example.com",
"me@example.com", ".", strShortMessage

-- Jay Bienvenu

Nov 12 '05 #5

P: n/a
He's using 6.0.
Nov 12 '05 #6

P: n/a
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?
Nov 12 '05 #7

P: n/a
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, "me@example.com", "me@example.com",
"me@example.com", ".", "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:me@example.com" 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

Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.