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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Forum statistics

Threads
1,196,385
Messages
6,014,974
Members
441,860
Latest member
Store154

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