Well I have 90% of it here:<br>
But it prompts for you to hit send.<br>
-----------------------<br>
Insert this Declare in your module<br>
<br>
Public Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long<br>
<br>
----------------------------------------<br>
Private Sub Command1_Click()<br>
On Error GoTo Err_Command1_Click<br>
<br>
' Raise the exception<br>
s = 3 / 0<br>
<br>
Exit_Command1_Click: '<<< Put all this code at the bottom right above the END SUB<br>
Exit Sub<br>
<br>
Err_Command1_Click:<br>
Select Case Err.Number<br>
Case 3021<br>
' No current record<br>
<br>
Case Else<br>
MsgBox "Error # " & Err.Number & " " & Err.Description, vbInformation, "In sub Command1_Click"<br>
<br>
End Select<br>
<br>
Dim stext As String<br>
Dim sAddedtext As String<br>
<br>
stext = "mailto:" & "douglasp"<br>
<br>
sAddedtext = sAddedtext & "&Subject=" & "Error From VB Program " & Err.Number & " " & Err.Description<br>
sAddedtext = sAddedtext & "&Body=" & "Put your Body Text here if needed"<br>
<br>
'Add an attachment if needed<br>
'If Len(txtAttachment) Then<br>
'sAddedtext = sAddedtext & "Attach=" & Chr$(34) & Me!txtAttachment & Chr$(34)<br>
'End If<br>
<br>
stext = stext & sAddedtext<br>
<br>
' launch default e-mail program<br>
If Len(stext) Then<br>
Call ShellExecute(Me.hwnd, "open", stext, vbNullString, vbNullString, SW_SHOWNORMAL)<br>
End If<br>
<br>
Resume Exit_Command1_Click<br>
<br>
End Sub<br>
-------------------------------------<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>