Quick Links
This page provides information on use of utility Command line email in Microsoft Access VBA macro (Visual Basic for Applications). With knowledge of VBA you can send automatic, well formatted HTML emails directly from Microsoft Access macro. By using febooti Command line email you can:
- Send email message using plain text or HTML message with embedded pictures.
- Send unlimited number of attachments.
- Use return codes to check success or failure.
- Works on Microsoft Windows (98 / Me / NT / 2000 / 2003 / XP / Vista) including all server versions.
- And many more options...
Sample MS Access VB script:
Sub send_email()
' Send Access e-mail and output the result.
Dim server
Dim subj
Dim body
Dim command
' Define all email parameters.
server = " -SMTP smtp.sender.com -PORT 25"
subj = "email using Access VBA"
body = """This is <I>HTML / MIME</I> e-mail message "
body = body & "sent from MS ACCESS VB script<BR>"
body = body & "using <B>febooti Command line email</B>"""
command = "febootimail.exe -HTML -FROM access-script@sender.com "
command = command & "-TO john@recipient.com "
command = command & "-SUBJ " & subj & " -BODY " & body & server
' We are passing one long line to Scripting object.
' If you need to add aditional parameters, do it before.
Dim wsShell, proc
Set wsShell = CreateObject("wscript.shell")
Set proc = wsShell.Exec(command)
Dim s : s = ""
Do While proc.Status = 0
' Yields execution so that the operating system can process other events
DoEvents
Loop
' Use proc.ExitCode to check for returned %errorlevel%
s = s & "StdOut=" & proc.StdOut.ReadAll()
s = s & Chr(13) & Chr(10) & "ExitCode=" & proc.ExitCode
MsgBox (s)
Set wsShell = Nothing
Set proc = Nothing
' Error Level values and descriptions are available at:
' www.command-line-email.com/online-help/batch-file-errorlevel.html
End Sub Additional Command line email notes and resources:
- febooti Command line email utility parameters.
- Please don't use this tool to send Unsolicited Commercial Email (SPAM).
- Overview on how to send email from VBA (Visual Basic for Application) macro.
- You must be familiar with MS Access VBA (Microsoft Access Visual Basic for Applications) in order to use this email sending example.
Please do not hesitate to contact our support department with any possible further questions or to solve practical issues connected with Command line email.