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

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" <[email protected]> wrote in message news:[email protected]...
>
> 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
>
>

nope still get the error 1004 ambigous recipient name found

"Ron de Bruin" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> >
> > 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
> >
> >
>
>

What do you have in E41

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Looker" <[email protected]> wrote in message news:[email protected]...
> nope still get the error 1004 ambigous recipient name found
>
> "Ron de Bruin" <[email protected]> wrote in message
> news:%[email protected]...
>> 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" <[email protected]> wrote in message
> news:[email protected]...
>> >
>> > 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
>> >
>> >
>>
>>
>
>
>