|
sendmail to variable
I need to send mail to a user whose value is in row E41 but cannot get it to work can this be done? ActiveWorkbook.SendMail Recipients:=Range("E41").Value, Subject:=(Range("A8").Value) & "-" & (Range("D22").Value) & Format(Date, "yyyy-mm-dd") ActiveWindow.Close SaveChanges:=False -- NO SPAM remove X from Xname@Xdomain |
sendmail to variable
Hi Looker
Try this Try this ActiveWorkbook.SendMail Recipients:=Range("E41").Value, _ Subject:=Range("A8").Value & "-" & Range("D22").Value & Format(Date, "yyyy-mm-dd") ActiveWindow.Close SaveChanges:=False -- Regards Ron de Bruin http://www.rondebruin.nl "Looker" wrote in message ... I need to send mail to a user whose value is in row E41 but cannot get it to work can this be done? ActiveWorkbook.SendMail Recipients:=Range("E41").Value, Subject:=(Range("A8").Value) & "-" & (Range("D22").Value) & Format(Date, "yyyy-mm-dd") ActiveWindow.Close SaveChanges:=False -- NO SPAM remove X from Xname@Xdomain |
sendmail to variable
What do you have in E41
-- Regards Ron de Bruin http://www.rondebruin.nl "Looker" wrote in message ... nope still get the error 1004 ambigous recipient name found "Ron de Bruin" wrote in message ... Hi Looker Try this Try this ActiveWorkbook.SendMail Recipients:=Range("E41").Value, _ Subject:=Range("A8").Value & "-" & Range("D22").Value & Format(Date, "yyyy-mm-dd") ActiveWindow.Close SaveChanges:=False -- Regards Ron de Bruin http://www.rondebruin.nl "Looker" wrote in message ... I need to send mail to a user whose value is in row E41 but cannot get it to work can this be done? ActiveWorkbook.SendMail Recipients:=Range("E41").Value, Subject:=(Range("A8").Value) & "-" & (Range("D22").Value) & Format(Date, "yyyy-mm-dd") ActiveWindow.Close SaveChanges:=False -- NO SPAM remove X from Xname@Xdomain |
| All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com