Hi Tanya,

You could replace a code line like:

.To = "

with

.To = Activesheet.Range("A1").Value

---
Regards,
Norman



"tanyhart" wrote in
message ...

Hi,

I've been reading some Rob de Bruin scripts for sending email from
Excel. My problem is that the user would need to be able to select who
the recipient would be. I want to send a generic email reply, but to a
different person each time.

Is this possible?

Thanks in advance.

Tanya


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile:
http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=549107