| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending mail to different mail address based on cell value
You could also set up string variable at the beginning of your procedu
Dim strRecipient As String If Range("Z1").Text = "00M" Then strRecipient = " ElseIf Range("Z1").Text = "00C" Then strRecipient = " End If And then modify the send mail line: ActiveWorkbook.SendMail strRecipient, _ ("Memo From Sto ") & Sheets("Sheet1").Range("H4").Value |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing From Address before sending mail | Excel Programming | |||
| E-Mail attachment to same e-mail address in Outlook | Excel Discussion (Misc queries) | |||
| E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
| General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
