COM Control in Net Framework 4 for Office applications
the Email_Send4 component you can send emails directly from Microsoft Access,
Word or Excel without having to press a confirmation from Outlook.
an example in MS Acess 2016
References to .tlb
email_send component must be integrated into vba (Alt-F11) under Menu->
Tools-> References with Browse to the local path of the file Email_Send4.tlb
Download, required files
Email_Send component you need the file Email_Send4.dll. These can be downloaded
here and saved on a local path.
addition, the registerbat and unregister.bat files are available for logging in
as ActiveX Control in the computer so that the component can also be viewed in
Access and Excel.
following is an example of the vba macro code that is used to send mail in
function also works in MS Excel, Word and Powerpoint
Option Compare Database
Option Explicit On
Private Sub btnSend_Click()
Private Sub fx_Email_Senden()
'-------------< fx_Email_Senden() >-------------
Dim objEmail As Email_Send4.Email_Send4
Set objEmail = New Email_Send4.Email_Send4
Dim sAddress_TO As String, sSubject As String, sText As String
Dim sAddress_FROM As String, sPassword As String, SMTP_Address As String, sPort As String, Enable_SSL As Boolean
sAddress_FROM = tbxEmail_From
sPassword = tbxPassword
SMTP_Address = tbxDomain
sAddress_TO = tbxEmail_To
Enable_SSL = True
sPort = tbxPort
sSubject = tbx_Subject
sText = tbxText
with Email_Send4.dll Control
sAddress_TO, "", sAddress_FROM, sPassword,
SMTP_Address, sPort, Enable_SSL, sSubject, sText
'< Abschluss >
Set objEmail = Nothing
mit Outlook senden >----
order for the Email_Send4.dll to be recognized as ActiveX COM Control in
Microsoft Office, the file Register.bat has to be executed as an administrator.
Register.bat, the .NET registry is run with regasm.exe. You have to adjust the
following path where the current component should be installed.
Email_Send4\Email_Send4.dll" /tlb /codebase
uninstall, you must also run Unregister.bat as an administrator.
file path to the current Email_Send4.dll must also be adjusted here