adding subject when emailing with macro
 

I have a spread sheet that emails when i press a button . I want the subject
line to read information from two cells on the excell page eg cell a1 has the
date and cell a2 has the subject i want both pieces of information adding to
the subject line when i press the email button .

Is this possible and could somebody help please

adding subject when emailing with macro
 

Hi,

Have a look here
http://www.rondebruin.nl/sendmail.htm

Mike

"BIGBOY1974AA" wrote:

I have a spread sheet that emails when i press a button . I want the subject
line to read information from two cells on the excell page eg cell a1 has the
date and cell a2 has the subject i want both pieces of information adding to
the subject line when i press the email button .

Is this possible and could somebody help please