Sub MailSheet1()
For Each cl In ThisWorkbook.Sheets("Kies").Range("B1:B50")
If cl.Value Like "?*@?*.?*" And LCase(cl.Offset(0, 1).Value) = "ja" Then
If strto = "" Then strto = stro & ";"
strto = strto & cell.Value & ";"
End If
Next cl
strsubject = Sheets("brief").[B1]
strcc = ""
strBcc = ""
For Each cell In ThisWorkbook.Sheets("brief").Range("B2:B50")
strbody = strbody & cell.Value & vbNewLine
Next
Call Mail_ActiveSheet(strto, strcc, strBcc, strsubject, strbody)
End Sub
Sub MailSheet2()
For Each cl In ThisWorkbook.Sheets("test1").Range("B1:B50")
If cl.Value Like "?*@?*.?*" And LCase(cl.Offset(0, 1).Value) = "ja" Then
If strto = "" Then strto = stro & ";"
strto = strto & cell.Value & ";"
End If
Next cell
strsubject = Sheets("brief").[B1]
strcc = ""
strBcc = ""
For Each cell In ThisWorkbook.Sheets("brief").Range("B2:B50")
strbody = strbody & cell.Value & vbNewLine
Next
Call Mail_ActiveSheet(strto, strcc, strBcc, strsubject, strbody)
End Sub
Sub Mail_ActiveSheet(strto As String, strcc As String, strBcc As String, strsubject As String, strbody As String)
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = strto
.CC = strcc
.BCC = strBcc
.Subject = strsubject
.body = strbody
.Display [COLOR="#008000"] 'send[/COLOR]
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub