Related:
- Auto E-mail when cell displays "Yes"
- Windows live mail download - Download - Email
- E-mail structure - Guide
- E-mail unicode.org - Guide
- Yahoo mail sign up - Guide
- Grand theft auto 1 download - Download - Action and adventure
1 response
This cannot be done without considerable work, and preparation (CODING OF MAIL OBJECTS).
Here is some help, please do not ask me to modify it to suite your needs, that is YOUR job!
I hope this is a good start, I have provided the HARD part.
Please understand, you will not be able to trigger this with a formula in a cell. It will need to be triggered with a button!
Here is some help, please do not ask me to modify it to suite your needs, that is YOUR job!
Dim OutlookApp As Object
Dim OutlookMail As Object
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
.to = VarToEmail
.CC = Var ccEmail
.BCC = bccemail
.Subject = varSubject
.Body = varBody
.Attachments.Add ActiveWorkbook.FullName
.Send
End With
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub
I hope this is a good start, I have provided the HARD part.
Please understand, you will not be able to trigger this with a formula in a cell. It will need to be triggered with a button!
