| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement to send email
Want to give this one a try?
Why does all email get sent to and never to If (Range("A7").Value = "D") Then .To = " Else .To = " End If .CC = "" .BCC = "" .Subject = "ORDER ENTERED: " & CurrDir .Body = "Hi there. Your order: " & CurrDir & " has been entered." & vbNewLine & _ "This is an automatically generated message. GET MORE ORDERS!" '.Attachments.Add ActiveWorkbook.FullName 'You can add other files also like this '.Attachments.Add ("C:\test.txt") .Send 'or use .Display End With |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i send an automated email from excel using an if statement | Excel Worksheet Functions | |||
| send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
| send email | Excel Discussion (Misc queries) | |||
Threaded Mode
