Email Command Button with Cell value in Subject Line?

[jonbh10]

Hi,

Sorry but I can't seem to get this to work? I wish to instead of having populated subject as per in " " below, I would like to populate the subject line of the email with a particular cell value?

My current code:

Private Sub Emailform_Click()
Application.Dialogs(xlDialogSendMail).Show "jon@jon.com", "enter here"
End Sub

Thanks in advance
Jon

 

[Andrew Poulsom]

Like this?

Application.Dialogs(xlDialogSendMail).Show "jon@jon.com", Range("A1").Value

 

[jonbh10]

Brilliant

Thanks

 

[jonbh10]

If I wanted to have different cells e.g. A1 and B35 both included within the subject line how should i write this?

Cheers

 

[Andrew Poulsom]

Like this?

Application.Dialogs(xlDialogSendMail).Show "jon@jon.com", Range("A1").Value & " " & Range("B35").Value

 

[jonbh10]

Brillaint thanks Andrew

 

[harishnehru]

Hi,

Can you please help with my query. I need a Button on the sheet will will check the mandatory cells (C12, C14, C16, C18) before emailing to info@abc.com and picking the Subject from cell C10.

I am not expert in excel. Please advise in step by step on which type of button to add (activeX or form). The code to be added in "ThisWorkBook" or in Sheet1.

Thanks in advance///