Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sendmail recipient
does anyone know how to get the email function to email a recipient whos
address is in a cell (D21) ? eg-- how do i get this to work:- With Dest .SaveAs TempFilePath & TempFileName & FileExtStr, FileFormat:=FileFormatNum On Error Resume Next .SendMail Sheets("Options").Range("D21").Value, "EPB" On Error GoTo 0 .Close SaveChanges:=False End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sendmail recipient
Looks good
Are you sure that the activeworkbook on this moment have a sheet named "Options" If not you can point to the workbook with the code like this ..SendMail ThisWorkbook.Sheets("Options").Range("D21").Value, _ "This is the Subject line" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Atishoo" wrote in message ... does anyone know how to get the email function to email a recipient whos address is in a cell (D21) ? eg-- how do i get this to work:- With Dest .SaveAs TempFilePath & TempFileName & FileExtStr, FileFormat:=FileFormatNum On Error Resume Next .SendMail Sheets("Options").Range("D21").Value, "EPB" On Error GoTo 0 .Close SaveChanges:=False End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Routing Recipient | Excel Discussion (Misc queries) | |||
Sendmail with a named cell value as recipient | Excel Programming | |||
SendMail | Excel Programming | |||
Routing Recipient | Excel Programming | |||
SendMail and BCC | Excel Programming |