1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| 'creation Mail
Set OutApp = CreateObject("outlook.application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = ""
'.CC = ""
'.BCC = ""
.Subject = "Rates: P&L & VAR and breaches as of " & Format(Date_Repor, "dd/mm/yyyy")
.Attachments.Add PathTmp & Img, olByValue, 0
.Attachments.Add chemin & "\" & graph1, olByValue, 0
.Attachments.Add chemin & "\" & graph2, olByValue, 0
.Attachments.Add PathTmp & Img2, olByValue, 0
.Attachments.Add PathTmp & Img3, olByValue, 0
.Attachments.Add chemin & "\" & graph3, olByValue, 0
.Attachments.Add PathTmp & Img8, olByValue, 0
.Attachments.Add PathTmp & Img5, olByValue, 0
.Attachments.Add PathTmp & Img6, olByValue, 0
'Body du mail en html
.HTMLBody = "<span LANG=FR><p class=style2>" _
& "<font FACE=Arial SIZE=2>Hello," _
& "<br>" & "<br>" & "<br>" & "Please find below a summary of the Rates product line of " _
& Format(Date_Repor, "dd/mm/yyyy") & "<br><br>" _
& "<font FACE=Arial SIZE=2> <strong> 1) P&L </strong>" & "<br>" & "<br>" & "<br>" _
& "<img src='cid:" & Img & "'</font></span>" & "<br>" & "<br>" & "<br>" _
& "<img src='cid:" & graph1 & "'</font></span>" & " " & "<img src='cid:" & graph2 & "'</font></span>" & "<br>" & "<br>" & "<br>" _
& "<font FACE=Arial SIZE=2> <strong> 2) P&L explanation </strong>" & "<br>" & "<br>" & "<br>" & "<img src='cid:" & Img2 & "'</font></span>" & "<br>" & "<br>" & "<br>" _
& "<font FACE=Arial SIZE=2> <strong> 3) VAR & worst scenarios </strong>" & "<br>" & "<br>" & "<br>" & "<img src='cid:" & Img3 & "'</font></span>" _
& "<br>" & "<br>" & "<br>" & "<img src='cid:" & Img8 & "'</font></span>" _
& "<br>" & "<br>" & "<br>" & "<img src='cid:" & graph3 & "'</font></span>" & "<br> <font FACE=Arial SIZE=1> An Add-on has been added to the VAR computation for Liquid bonds perimeter starting 15/06/2015. " & "<br>" & "<br>" _
& "<br>" & "<br>" & "<br>" & "<font FACE=Arial SIZE=2> <strong> 4) VAR Backtesting </strong>" & "<br>" & "<br>" & "<br>" _
& resBack & "<br>" & "<br>" & "<br>" _
& "<font FACE=Arial SIZE=2> <strong> 5) Contribution to CACIB VAR </strong>" & "<br>" & "<br>" & "<br>" & "<img src='cid:" & Img5 & "'</font></span>" & "<br>" & "<br>" & "<br>" _
& "<font FACE=Arial SIZE=2> <strong> 6) Stressed VAR </strong>" & "<br>" & "<br>" & "<br>" & "<img src='cid:" & Img6 & "'</font></span>" & "<br> <font FACE=Arial SIZE=1> Note: Limits are for VAR only (no limit on Stressed VAR)</font></span>" & "<br>" & "<br>" _
& "<font FACE=Arial SIZE=2> <strong> "
.Display
End With
'Vidage
Set OutMail = Nothing
Set OutApp = Nothing
Kill PathTmp & Img |
Partager