Codigo:
Dim oOApp As Outlook.Application
Dim oOMail As Outlook.MailItem
Set oOApp = CreateObject("Outlook.Application"
Set oOMail = oOApp.CreateItem(olMailItem)
With oOMail
.To = "name@domain.com"
.Subject = "email subject"
.Body = "email message"
.Attachments.Add "\serverdrivefolderfilename", olByValue, 1
.Send
End With