E-mail: subject

Jan Prins · May 8, 2004

I want to put the text in range("A1") into the subject field when
using the E-mail button.
I suppose it should be done in VBA.
Can somebody help me?

Ron de Bruin · May 8, 2004

Hi Jan

How to Send a Range of Cells Using VBA
http://support.microsoft.com/default.aspx?scid=kb;en-us;816644

..Item.Subject = Range("A1").Value