Mohammad Shafaat
New Member
Code:
Option Explicit
Sub SNAPSHOT()
Dim RNG As Range
Set RNG = Range("B2:O10")
''.............
Workbooks.Add
Dim CH As Chart
Set CH = Charts.Add
CH.Location xlLocationAsObject, "Sheet1"
Set CH = ActiveChart
RNG.CopyPicture xlScreen, xlBitmap
CH.Paste
CH.Export "D:\DBC\September-2018/DBC.Png"
'''Outlook -Early binding
Dim o As Outlook.Application
Set o = New Outlook.Application
Dim omail As Outlook.MailItem
Set omail = o.CreateItem(olmailitem)
With omail
.To = ""
.HTMLBody = "Hi Team Please find the Updated as on September Daily bill cut report," & "<Br>" & "<br>" & "<img src='D:\DBC\September-2018\DBC.Png'/>"
.Display
End With
End Sub
Last edited by a moderator: