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
|
Sub EnvoiCondition()
If Range("A4") = "" Then
'
Else
If WorksheetFunction.VLookup(Range("A4"), Sheets("Codes").Range("A2:D36"), 3, False) = "" Then
FaxTo VLookup(Range("A4"), Sheets("Codes").Range("A2:D36"), 4, False)
Else
MailTo VLookup(Range("A4"), Sheets("Codes").Range("A2:D36"), 3, False)
End If
Application.ActivePrinter = "DelFax sur Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"DelFax sur Ne03:", Collate:=True
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
End If
Dim Adresse As String
Adresse = WorksheetFunction.VLookup(Range("A4"), _
Worksheets("Codes").Range("A2:D36"), 3, False)
ThisWorkbook.SendMail Recipients:=Adresse
End Sub |
Partager