psSendMail

That psSendMail is a nice little utility. It is almost exactly what I am looking for. My problem is that I am trying to incorperate the SendMail form into another form but when I do it loses it functionality (or likewise when I try to incorperate an existing form into the SendMail form). You'll have to forgive me as I am not an Access Guru (novice at best) but if I could get this Sendmail function to work with an existing form, my life would me made much easiler. If you can give me any insite, or point me in the right direction, I would greatly appreiciate it.

Thank you.
Kevin

As for your specific "reuse" problem. What specific error are you getting? My first guess is that you need to declare the DLL functions. The following code snippet is from the mod_sendmail module:

Option Compare Database

Declare Function QuickSend Lib "psSendMail" (ByVal Host As String, 
ByVal strFrom As String, ByVal SendTo As String, ByVal Subject As String, 
ByVal MsgText As String) As Long

 
Declare Function Connect Lib "psSendMail" (ByVal xHost As String) As Long '
;0 (Connected) -1 (Not Connected)
 

Declare Function InitMsg Lib "psSendMail" (ByVal xHost As String, 
ByVal xmsgFrom As String, ByVal xmsgTo As String, ByVal xCC As String, 
ByVal xBCC As String, ByVal xSubject As String) As Long '
;0 (No Error) -1 (No Host specified) -2 (No from e-mail address supplied) -3 (No send to e-mail address(es) supplied)

 
Declare Function Attach Lib "psSendMail" (ByVal xFilename As String) As Long '
;0 file found, -1 couldn't find file to attach
 

Declare Function SendMsg Lib "psSendMail" (ByVal xMsgText As String) As Long '
;0 (No Error) -1 (MsgText is blank) -2 (Error occurred while sending message)
 

Declare Function Quit Lib "psSendMail" ()