[RESOLVED] Is it possible for an e-mail’s 'Subject' field to auto-fill from a cell value

[Tra1ner]

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.

[Static]

Application.Dialogs(xlDialogSendMail).Show "", Range("R28") & " Report Return"

[Tra1ner]

Brilliant Static

Just what I needed
Thanks for your help