Norman Jones Wrote:
Hi Tanya,

You could replace a code line like:

.To = "

with

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

---
Regards,
Norman

View this thread
http://www.excelforum.com/showthread...hreadid=549107


Actually, the quickest and easiest way to deal with this would be t
change .send to .display in your options, and don't use ".To" . Wit
send the email address is entered in the form you're creating (i
there's a cell/field designated for it). with display, it just open
the email, and you set the email address in Outlook, rather than i
Excel

--
ljsmit

-----------------------------------------------------------------------
ljsmith's Profile: http://www.excelforum.com/member.php...fo&userid=3053
View this thread: http://www.excelforum.com/showthread.php?threadid=54910