Скачать с ютуб Send Bulk Mail from Excel Sheet with Attachment to Multiple Email Id in One Click || In Hindi в хорошем качестве

Send Bulk Mail from Excel Sheet with Attachment to Multiple Email Id in One Click || In Hindi

#techsonal #Bulkmailfromexcel #mailwithattachement This Video shows how you Can send multiple Mail from excel sheet with multiple attachment in one click , Best time saving Trick. VBA Code Sub Send_Mails() Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Sheet1") Dim i As Integer Dim OA As Object Dim msg As Object Set OA = CreateObject("outlook. Application") Dim last_row As Integer last_row = Application.CountA(sh.Range("A:A")) For i = 2 To last_row Set msg = OA.createitem(0) msg.to = sh.Range("A" & i).Value msg.cc = sh.Range("B" & i).Value msg.Subject = sh.Range("C" & i).Value msg.body = sh.Range("D" & i).Value If sh.Range("E" & i).Value "" Then msg.attachments.Add sh.Range("E" & i).Value End If msg.send sh.Range("F" & i).Value = "Sent" Next i MsgBox "All the mails have been sent successfully" End Sub