Hé bien : remplace donc "ron@debruin.nl" par sheets("mail").Range("E:13")
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub Mail_Selection() Dim source As Range Dim ColumnCount As Long Dim FirstColumn As Long Dim ColumnWidthArray() As Double Dim lIndex As Long Dim lCount As Long Dim dest As Workbook Dim i As Long Dim strDate As String Set source = Nothing On Error Resume Next Set source = Selection.SpecialCells(xlCellTypeVisible) On Error GoTo 0 If source Is Nothing Then MsgBox "The selection is not a range or the sheet is protect, please correct and try again.", vbOKOnly Exit Sub End If Set source = Range("A13:M30").SpecialCells(xlCellTypeVisible) Range("A13:M30").Select Application.ScreenUpdating = False ColumnCount = Selection.Columns.Count FirstColumn = Selection.Cells(1).Column - 1 ReDim ColumnWidthArray(1 To ColumnCount) lIndex = 0 For lCount = 1 To ColumnCount If Columns(FirstColumn + lCount).Hidden = False Then lIndex = lIndex + 1 ColumnWidthArray(lIndex) = Columns(FirstColumn + lCount).ColumnWidth End If Next lCount Set dest = Workbooks.Add(xlWBATWorksheet) source.Copy With dest.Sheets(1) .Cells(1).PasteSpecial xlPasteValues, , False, False .Cells(1).PasteSpecial xlPasteFormats, , False, False .Cells(1).Select Application.CutCopyMode = False For i = 1 To lIndex .Columns(i).ColumnWidth = ColumnWidthArray(i) Next End With strDate = Format(Now, "dd-mm-yy h-mm-ss") With dest ActiveWorkbook.SendMail ActiveSheet.Range("e1").Value, _ "TITRE DU MAIL" .Close False End With Application.ScreenUpdating = True End Sub