macro to send mail with graph in the body, text above graph and also signature

vinay_hd

New Member
Joined
Jun 17, 2014
Messages
1
Hi All,

Currently am using below code to send mail with graph in the body and text above graph.

But am not able to include signature in tha mail..

Can anyone help me out in this..

Code Used :

Sub Send_Range()
Dim StrSignature As String
StrSignature = "Regards"


' Select the range of cells on the active worksheet.
ActiveSheet.Range("M2:U32").Select

' Show the envelope on the ActiveWorkbook.
ActiveWorkbook.EnvelopeVisible = True



' Set the optional introduction field thats adds
' some header text to the email body. It also sets
' the To and Subject lines. Finally the message
' is sent.
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
ActiveSheet.MailEnvelope.Display
Dim StrSignature As String
StrSignature = "Regards"

.Introduction = "This is a sample worksheet." & vbNewLine & _
"" & vbNewLine & _
"Here i will make you awesome in Excel Macro." & vbNewLine & _
"Date " & Range("D6").Value

.Item.To = "xyz.com"
.Item.Subject = "My subject"
.Item.Display
.Body = StrSignature

.Item.Send
End With
End Sub
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,214,904
Messages
6,122,169
Members
449,070
Latest member
webster33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top