VB6, VBA ExampleTo send an email with file attachment, we need to use AddAttachment method. This method can attach a file to the email message from local disk or a remote URL.
' The following example codes demonstrate sending email message with file attachment
' To get full sample projects, please download and install EASendMail on your machine.
' To run it correctly, please change SMTP server, user, password, sender, recipient value to yours
Private Sub btnSendMail_Click()
Dim oSmtp As New EASendMailObjLib.Mail
oSmtp.LicenseCode = "TryIt"
' Set your sender email address
oSmtp.FromAddr = "test@emailarchitect.net"
' Add recipient email address
oSmtp.AddRecipientEx "support@emailarchitect.net", 0
' Set email subject
oSmtp.Subject = "test HTML email from VB 6.0 project with attachment"
' Set HTML body format
oSmtp.BodyFormat = 1
' Set HTML body text
oSmtp.BodyText = "<font size=5>This is</font> <font color=red><b>a test</b></font>"
' Add attachment from local disk
If oSmtp.AddAttachment( "c:\test.doc" ) <> 0 Then
MsgBox "Failed to add attachment with error:" & oSmtp.GetLastErrDescription()
End If
' Add attachment from remote website
If oSmtp.AddAttachment( "http://www.emailarchitect.net/webapp/img/logo.jpg" ) <> 0 Then
MsgBox "Failed to add attachment with error:" & oSmtp.GetLastErrDescription()
End If
' Your SMTP server address
oSmtp.ServerAddr = "smtp.emailarchitect.net"
' User and password for ESMTP authentication, if your server doesn't require
' User authentication, please remove the following codes.
oSmtp.UserName = "test@emailarchitect.net"
oSmtp.Password = "testpassword"
' If your smtp server requires SSL connection, please add this line
' oSmtp.SSL_init
MsgBox "start to send email ..."
If oSmtp.SendMail() = 0 Then
MsgBox "email was sent successfully!"
Else
MsgBox "failed to send email with the following error:" & oSmtp.GetLastErrDescription()
End If
End Sub
Click here to read original topic - full version ... If you have any comments or questions about above example codes, please add your comments here.