View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BIGBOY1974AA BIGBOY1974AA is offline
external usenet poster
 
Posts: 3
Default 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