How to start the default email program WITHOUT sending a message

[Tony Ciconte]

There is plenty of VBA code around that allows you send email
messages. Does anyone know where I can see a sample of VBA code or a
technique that only opens the default email program and then waits for
user input? For example, a VBA technique that simulates
double-clicking on an email desktop icon or opening something from a
program group. I am using Access 97 in a runtime environment.

Any and all help is greatly appreciated.

TC

[NeilAnderson]

try

Dim stAppName As String

stAppName = "C:\Program Files\Microsoft Office\Office\OUTLOOK.EXE"
Call Shell(stAppName, 1)

neil

Tony Ciconte <to******@comcast.net> wrote in message news:<qc********************************@4ax.com>. ..

There is plenty of VBA code around that allows you send email
messages. Does anyone know where I can see a sample of VBA code or a
technique that only opens the default email program and then waits for
user input? For example, a VBA technique that simulates
double-clicking on an email desktop icon or opening something from a
program group. I am using Access 97 in a runtime environment.

Any and all help is greatly appreciated.

TC

[David Schofield]

On Sun, 28 Nov 2004 07:35:15 -0500, Tony Ciconte
<to******@comcast.net> wrote:

There is plenty of VBA code around that allows you send email
messages. Does anyone know where I can see a sample of VBA code or a
technique that only opens the default email program and then waits for
user input? For example, a VBA technique that simulates
double-clicking on an email desktop icon or opening something from a
program group. I am using Access 97 in a runtime environment.

Any and all help is greatly appreciated.

TC

Hi
Docmd.Sendobject with no arguments should bring up the default email
client.
You could also open a MAPI session (assuming that the client is MAPI
compatible) but finding the default profile is a hassle. Search Google
for Q171422.
-David

[Tony Ciconte]

Thanks to both Neil and David. This what I was looking for.

TC

d.***************@blueyonder.co.uk (David Schofield) wrote:

On Sun, 28 Nov 2004 07:35:15 -0500, Tony Ciconte
<to******@comcast.net> wrote:

There is plenty of VBA code around that allows you send email
messages. Does anyone know where I can see a sample of VBA code or a
technique that only opens the default email program and then waits for
user input? For example, a VBA technique that simulates
double-clicking on an email desktop icon or opening something from a
program group. I am using Access 97 in a runtime environment.

Any and all help is greatly appreciated.

TC

Hi
Docmd.Sendobject with no arguments should bring up the default email
client.
You could also open a MAPI session (assuming that the client is MAPI
compatible) but finding the default profile is a hassle. Search Google
for Q171422.
-David

[David Schofield]

On Sun, 28 Nov 2004 07:35:15 -0500, Tony Ciconte
<to******@comcast.net> wrote:

There is plenty of VBA code around that allows you send email
messages. Does anyone know where I can see a sample of VBA code or a
technique that only opens the default email program and then waits for
user input? For example, a VBA technique that simulates
double-clicking on an email desktop icon or opening something from a
program group. I am using Access 97 in a runtime environment.

Any and all help is greatly appreciated.

TC

Hi
Docmd.SendObject without arguments should bring up the default email
program. However there are some limitations in using sendobject for
mail. See Tont Toews web site.

You could also open a simple MAPI session (assuming the mailer is
MAPI compliant) but it is a hassle finding the default profile - there
is a KB article on this (seach google for Q171422)

David

[Tony Toews]

d.***************@blueyonder.co.uk (David Schofield) wrote:

Docmd.SendObject without arguments should bring up the default email
program. However there are some limitations in using sendobject for
mail. See Tont Toews web site.

FWIW SendObject's twenty limitations
http://www.granite.ab.ca/access/email/sendobject.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[adsl]

"Tony Toews" <tt****@telusplanet.net>
???????:5t********************************@4ax.com ...

d.***************@blueyonder.co.uk (David Schofield) wrote:

Docmd.SendObject without arguments should bring up the default email
program. However there are some limitations in using sendobject for
mail. See Tont Toews web site.

FWIW SendObject's twenty limitations
http://www.granite.ab.ca/access/email/sendobject.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm