Hi Tanya,

See the tips section on any of Ron de Bruin's email pages.

http://www.rondebruin.nl/sendmail.htm


---
Regards,
Norman



"tanyhart" wrote in
message ...

I've have a macro that will send a generic email from Excel.. My next
problem in that I would like the subject of each email to reflect the
infomation that are in two different cells of the workbook (say C5 and
C7 of sheet1). How would I enter this in the macro to accomplish this
task?

Thanks.


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