(Excel) Rename Email Attachments After Adding

Demonstrates how to rename email attachments after adding but before sending.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

mailman.SmtpHost = "smtp.my-mail-server.com"
mailman.SmtpUsername = "MY_SMTP_USERNAME"
mailman.SmtpPassword = "MY_SMTP_PASSWORD"
mailman.SmtpSsl = True
mailman.SmtpPort = 465

Dim email As Chilkat.Email
Set email = Chilkat.NewEmail

email.Subject = "This is a test"
email.Body = "This is a test"
email.From = "Chilkat Support <support@chilkatsoft.com>"

success = email.AddTo("Chilkat Admin","admin@chilkatsoft.com")
' To add more recipients, call AddTo, AddCC, or AddBcc once per recipient.

' Add some attachments.
' The AddFileAttachment method returns the value of the content-type it chose for the attachment.

contentType = email.AddFileAttachment("qa_data/jpg/starfish.jpg")
If (email.LastMethodSuccess <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

contentType = email.AddFileAttachment("qa_data/pdf/fishing.pdf")
If (email.LastMethodSuccess <> True) Then
    Debug.Print email.LastErrorText
    Exit Sub
End If

' If we save the email to a .eml, we can examine in a text editor.
success = email.SaveEml("qa_output/e1.eml")
If (success = False) Then
    Debug.Print email.LastErrorText
    Debug.Print "Failed to save .eml"
    Exit Sub
End If

' We see the following in the e1.eml
' Notice that Chilkat replaced the full path with just the filename.
' The full local path is not part of the email that gets sent..

' ...
' --------------020807050607070004010609
' Content-Type: image/jpeg; name="starfish.jpg"
' Content-Transfer-Encoding: base64
' Content-Disposition: attachment; filename="starfish.jpg"
' 
' ...
' --------------020807050607070004010609
' Content-Type: application/pdf; name="fishing.pdf"
' Content-Transfer-Encoding: base64
' Content-Disposition: attachment; filename="fishing.pdf"
' ...

' Before sending, each filename can be changed within the email object.
' For example:
success = email.SetAttachmentFilename(0,"orange_starfish.jpg")
success = email.SetAttachmentFilename(1,"tuna_fishing.pdf")

' Look at the new MIME source of the email in a  text editor...
success = email.SaveEml("qa_output/e2.eml")
If (success = False) Then
    Debug.Print email.LastErrorText
    Debug.Print "Failed to save .eml"
    Exit Sub
End If

' You'll see this:

' ...
' --------------020807050607070004010609
' Content-Type: image/jpeg; name="orange_starfish.jpg"
' Content-Transfer-Encoding: base64
' Content-Disposition: attachment; filename="orange_starfish.jpg"
' 
' ...
' --------------020807050607070004010609
' Content-Type: application/pdf; name="tuna_fishing.pdf"
' Content-Transfer-Encoding: base64
' Content-Disposition: attachment; filename="tuna_fishing.pdf"
' ...

' Send the email with the updated filenames..
success = mailman.SendEmail(email)
If (success <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If

success = mailman.CloseSmtpConnection()
If (success <> True) Then
    Debug.Print "Connection to SMTP server not closed cleanly."
End If

Debug.Print "Mail with attachments sent!"