View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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