How do I use ddesend to get Outlook to create a new mail message?

[servant]

From an Access form, I want to initiate an email message when the user double
clicks on an email address. Access help partially documents the ddesend
function, which appears to be the obvious path, but I can't find any
elaboration of "topics" or "items" that must be supplied in parameters to
ddesend. Help tells me to "check the other application's documentation for a
list of topics." Outlook help doesn't seem to have any idea what ddesend is.

Where can I find lists of parameters for these applications?

Thank you.

 

[Douglas J. Steele]

Realistically, DDE is obsolete technology. You'd probably be better off
using Automation.

Check the Access EMail FAQ that Tony Toews has at
http://www.granite.ab.ca/access/email.htm

 

[servant]

Thank you, Doug. That FAQ has a wealth of helpful information and should get
me where I want to go. Your response is greatly appreciated.

 

[dch3]

All of the Office aplications - and a few not in the Office suite - can be
manipulated from one another via VBA. Read up on CreateObject. To fully
understand how to manipulate the an app, look for 'OBJECT MODEL' in the VBA
help file for the app that your manipulating. When I'm having problems or I'm
working with a app that I'm not familar with, I'll actually develop the code
in the app and then copy & paste it over to the actually App - basically
writting code in Outlook to use VBA to create a mail message and then copy it
to Access. (No going to explain why, but it is usefull). I'll also play
around with the object model to better understand the properties and methods
of the various objects by creating objects, viewing properties, and executing
methods directly in the Immediate Window. Let me know if you'd like some
basic code and excercises.