| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to send a mail to outlook
Hi all,
I need a macro to send the amail to the user mentioned in the excel sheet, if the value is true in the cell. Eg: A120 then send the mail to a person mentioned in the Cell B2. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to send a mail to outlook
===================================
Sub Naveen2() If Range("A1") 20 Then ActiveWorkbook.SendMail Recipients:=Range("B1") End If End Sub =================================== *** Please do rate *** " wrote: Hi all, I need a macro to send the amail to the user mentioned in the excel sheet, if the value is true in the cell. Eg: A120 then send the mail to a person mentioned in the Cell B2. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop outlook to be my default mail client | New Users to Excel | |||
| Excel Send to Mail Recipient (as Attachment) | Excel Discussion (Misc queries) | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| Send to mail recipient stays in OutBox | Excel Discussion (Misc queries) | |||
| help with send mail through excell | Excel Worksheet Functions | |||
Linear Mode
