I have an Excel Command button used for opening Outlook/Outlook Express and sending the open file by e-mail.
Is it possible to get the ‘Subject’ field auto-populated by a specific cell value?
Then if possible, I want to follow the cell value with a simple text statement such as ‘Report Return’.

I want the subject line to look something like: 12/05 Report Return

(Where 12/05 is the cell value of R28)


I can already populate the field with just the text, as below:

Private Sub CommandButton8_Click()
Application.Dialogs(xlDialogSendMail).Show "", "Report Return"
End Sub


But is there a simple code to combine the two?

Any assistance to a Newbie would be appreciated.