Option Explicit Private 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 Const EMAIL_TO = "mailto:your-email@your-address.com" Public Function Mail(subject As String, message As String) As Boolean On Error GoTo MailError ShellExecute 0&, vbNullString, EMAIL_TO & "?" & "subject=" & subject & "&body=" & message, vbNullString, vbNullString, vbNormalFocus Mail = True Exit Function MailError: Mail = False Exit Function End Function