MS Access and Internet - Docmd.SendObject unsing Outlook Express

Author

Docmd.SendObject unsing Outlook Express

Michel Boivin

2005-11-27, 3:30 am

Some of my application users use Outlook Express as their primary internet
messaging application. One of the functionnalities oy my Access application
allows the user to send an internet message. I use the SendObject method for
this. Everything works fine with Outlook, but does not work with Outlook
Express. On one machine, Outlook is installed but the user uses Outlook
Express as primary mail application. When my Access application sends a
message and Outlook Express is running, the message goes to the out basket of
Outlook, even if Outlook is not running. In order to get the message out,
the user has to start Outlook.

Is there a way to point the message from my Access application to use
Outlook Express instead of Outlook ? Even better, is there a way to detect
which mail application is running and use that mail application to send my
message from my Access application ?

Sylvain Lafontaine

2005-11-28, 8:28 pm

You say nothing about the method that you are using to send email. However,
Outlook Express (OE) doesn't offer support for Automation (only MAPI); so
quite likely you cannot open it with your method if you have used Automation
and this will only work with Outlook.

I won't suggest you to try using MAPI to open OE as this interface is a real
big shunk of problems and is fading into oblivion. Instead, if it's
possible with your clients, you should use a SMTP client such as JMail to
send your messages without using Outlook or OE. The free version of JMail
require access to a SMTP server but I think that the pro version has its own
STMP server included.

They are other SMTP clients (and Servers) on the market.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

"Michel Boivin" < MichelBoivin@discuss
ions.microsoft.com> wrote in message
news:2B786D88-0BB1-4488-8D2A- CB9A9E68DB08@microso
ft.com...
> Some of my application users use Outlook Express as their primary internet
> messaging application. One of the functionnalities oy my Access
> application
> allows the user to send an internet message. I use the SendObject method
> for
> this. Everything works fine with Outlook, but does not work with Outlook
> Express. On one machine, Outlook is installed but the user uses Outlook
> Express as primary mail application. When my Access application sends a
> message and Outlook Express is running, the message goes to the out basket
> of
> Outlook, even if Outlook is not running. In order to get the message out,
> the user has to start Outlook.
>
> Is there a way to point the message from my Access application to use
> Outlook Express instead of Outlook ? Even better, is there a way to
> detect
> which mail application is running and use that mail application to send my
> message from my Access application ?

Michel Boivin

2005-11-28, 8:28 pm

Thanks Sylvain for your effort to help me.
Here is the command I'm using:

DoCmd.SendObject acSendNoObject, , acFormatTXT, varInetÃ€, varInetCc, ,
TitreInet, MessageInet, 0

What I liked about this command was it's simplicity to use. Trying to use
something like SMTP server would be too complicated and make my application
less portable on different stand alone machines.

I thaught that I could, from my Access application, direct the message to OE
instead of Outlook. Or else, by adjusting some parameter in windows, make
one application (OE or Outlook) the default messaging application to which
the Docmd.SendObject would send the message.

PS If it's suitable to you, it would be easier to communicate in french.

"Sylvain Lafontaine" wrote:

> You say nothing about the method that you are using to send email. However,
> Outlook Express (OE) doesn't offer support for Automation (only MAPI); so
> quite likely you cannot open it with your method if you have used Automation
> and this will only work with Outlook.
>
> I won't suggest you to try using MAPI to open OE as this interface is a real
> big shunk of problems and is fading into oblivion. Instead, if it's
> possible with your clients, you should use a SMTP client such as JMail to
> send your messages without using Outlook or OE. The free version of JMail
> require access to a SMTP server but I think that the pro version has its own
> STMP server included.
>
> They are other SMTP clients (and Servers) on the market.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "Michel Boivin" < MichelBoivin@discuss
ions.microsoft.com> wrote in message
> news:2B786D88-0BB1-4488-8D2A- CB9A9E68DB08@microso
ft.com...
>
>
>

Sylvain Lafontaine

2005-11-29, 3:24 am

No, you cannot replace the default mail client used by MAPI. The user can
choose by changing the value in IE -> Options -> Programs -> E-mail but it
would be very complicated to do the same from MAPI or by manipulating the
registry. This is probably what's happening on your client using both
Outlook and OE: he use OE but probably Outlook is set as the default.
However, with MAPI, we never know what's really happening.

Trying to control OE with MAPI will probably get you nowhere but you can try
to use Automation to open Outlook and send your message. However, you might
be hurt with the standard security features of Outlook.

You can try to replace the value of the last parameter from 0 (false) to
True.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

"Michel Boivin" < MichelBoivin@discuss
ions.microsoft.com> wrote in message
news:F05F1425-F671-4F57-ADDD- 43C228D6B725@microso
ft.com...[color=darkred]
> Thanks Sylvain for your effort to help me.
> Here is the command I'm using:
>
> DoCmd.SendObject acSendNoObject, , acFormatTXT, varInetÀ, varInetCc, ,
> TitreInet, MessageInet, 0
>
> What I liked about this command was it's simplicity to use. Trying to use
> something like SMTP server would be too complicated and make my
> application
> less portable on different stand alone machines.
>
> I thaught that I could, from my Access application, direct the message to
> OE
> instead of Outlook. Or else, by adjusting some parameter in windows, make
> one application (OE or Outlook) the default messaging application to which
> the Docmd.SendObject would send the message.
>
> PS If it's suitable to you, it would be easier to communicate in french.
>
> "Sylvain Lafontaine" wrote:
>

Michel Boivin

2005-11-29, 9:30 am

Many thanks Sylvain,

I'll have a second tought about this and maybe I'll have to drop this email
functionnality from my Access app.

Have a nice day.

"Sylvain Lafontaine" wrote:

> No, you cannot replace the default mail client used by MAPI. The user can
> choose by changing the value in IE -> Options -> Programs -> E-mail but it
> would be very complicated to do the same from MAPI or by manipulating the
> registry. This is probably what's happening on your client using both
> Outlook and OE: he use OE but probably Outlook is set as the default.
> However, with MAPI, we never know what's really happening.
>
> Trying to control OE with MAPI will probably get you nowhere but you can try
> to use Automation to open Outlook and send your message. However, you might
> be hurt with the standard security features of Outlook.
>
> You can try to replace the value of the last parameter from 0 (false) to
> True.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "Michel Boivin" < MichelBoivin@discuss
ions.microsoft.com> wrote in message
> news:F05F1425-F671-4F57-ADDD- 43C228D6B725@microso
ft.com...
>
>
>

Sponsored Links