Help needed starting default email program WITHOUT sending a message

  • Thread starter Thread starter John Moore
  • Start date Start date
J

John Moore

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
 
No offense, Alex, but I don't think that is the best illustration of how to
use the ShellExecute API. For one thing, it's not clear that the calls to
the API need to be inside a function or sub. And there's also the problem
that the actual calls (what I'm referring to above) are wrong in the
example!

lResult = ShellExecute(frmSplash.hwnd, vbNullString, "TEST.XLS",_
vbnullstring, App.Path, SW_SHOWMAXIMIZED)

lResult = ShellExecute(GetDesktopWindow(), "open", "http://www.arimsoft.ru"_
, "", 0&, SW_SHOWMAXIMIZED)

should be

lResult = apiShellExecute(frmSplash.hwnd, vbNullString, "TEST.XLS",_
vbnullstring, App.Path, SW_SHOWMAXIMIZED)

lResult = apiShellExecute(GetDesktopWindow(), "open",
"http://www.arimsoft.ru"_
, "", 0&, SW_SHOWMAXIMIZED)

Overall, I think the example at "The Access Web" illustrates the point
better
http://www.mvps.org/access/api/api0018.htm
 
Hi Doug,
thanks, you are the first who noticed this error from 1997 :-))
have to fix this...
 
Back
Top