I am using Ron De Brun's code for emailing a single sheet from
workbook using Outlook. I want to have a cell that the macro will rea
from and make that where the email is sent.

I found this portion of the code on his website

.SendMail Sheets("mysheet").Range("a1").Value, _
"This is the Subject line"


Where would I add it, and would I have to delete a portion of this are
of the code?

With OutMail
.To = ""
.CC = ""
etc etc.

Also, I would like to have a cell that has an order number in it tha
would be changeable from the excel sheet. I then want the order numbe
to appear in the email in the subject or Body of the email. Fo
example, " Your order number is "$A$1" or something of the like, but
doubt it would be that simple

--
pete358
-----------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840
View this thread: http://www.excelforum.com/showthread.php?threadid=48429