How to start the default email program WITHOUT sending a message

  • Thread starter Thread starter Tony Ciconte
  • Start date Start date
T

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
 
try

Dim stAppName As String

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

neil
 
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
Click to expand...

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
 
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.
Click to expand...

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
 
Back
Top