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
| Option Explicit
Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Private Const KEYEVENTF_KEYUP = &H2
Private Const VK_SNAPSHOT = &H2C
Private Const VK_MENU = &H12
Private Const VK_BAS = 40
Private Sub CommandButton1_Click()
keybd_event VK_MENU, 0, 0, 0
keybd_event VK_SNAPSHOT, 0, 0, 0
keybd_event VK_SNAPSHOT, 0, KEYEVENTF_KEYUP, 0
keybd_event VK_MENU, 0, KEYEVENTF_KEYUP, 0
DoEvents
EnvoiMail
End Sub
Sub EnvoiMail()
Dim OutApp As Outlook.Application, OutMail As Outlook.MailItem, olInsp As Object, wdDoc As Object, oRng As Object, msg As String, i As Integer
msg = "Bonjour," & vbCrLf & vbCrLf & _
"Vous trouverez, ci-dessous, une copie de l'userform" & vbCrLf & vbCrLf
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = "jack.bauer@24h.fr"
.cc = vbNullString
.Subject = "Userform"
.Body = msg
.Display
For i = 0 To UBound(Split(msg, vbCrLf))
keybd_event VK_BAS, 0, 0, 0
keybd_event VK_BAS, 0, KEYEVENTF_KEYUP, 0
Next
SendKeys "^v", True
End With
End Sub |