Auto E-mail when cell displays "Yes"
Closed
Good Day
Could someone please assist me with my query? I do not have many experience with VBA Macro, and would appreciate a simple answer.
I have a spreadsheet where column G contains text Yes or Blank cells. If Yes are displayed I would like an automatic e-mail to be sent to 1 e-mail address containing the info for that row.
Thank you in advance for your time.
Could someone please assist me with my query? I do not have many experience with VBA Macro, and would appreciate a simple answer.
I have a spreadsheet where column G contains text Yes or Blank cells. If Yes are displayed I would like an automatic e-mail to be sent to 1 e-mail address containing the info for that row.
Thank you in advance for your time.
Related:
- Auto E-mail when cell displays "Yes"
- E-mail unicode.org - Guide
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Windows live mail download - Download - Email
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Auto download mms when roaming - Guide
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!