Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

Sending email directly from a form

Last updated: 27 Sep 2001

Using a macro, you can send email to a particular email address


If the email address is in a database field, then use:

OPEN mailto:<<mytable.emailfield>>

If the email address is in a variable field, then use:

OPEN mailto:<<varfield>>

The following does the same thing using a script:

Sub CreateEMail

Dim lngRtn As Long

lngRtn = Shell("rundll32.exe url.dll,FileProtocolHandler mailto:" &

End Sub

Note that the mailto protocol also lets you insert the subject and a limited amount of text in the message body, but can't use it to send file attachments. Full details are in RFC2368 (search for this document on the web).

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.