Buy Dideo Subscription
Topic: Send or Draft Emails with Attachment from Outlook Automatically Scenario: You have multiple files and you want to send to multiple people by email automatically or save them to the draft box Function: Macro for Loop and Sending Email ***Marco Code*** Sub SendEmailfromOutlook() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim Path As String Path = Application.ActiveWorkbook.Path Set OutApp = CreateObject("Outlook.Application") For Each cell In Range("C7:C11") Set OutMail = OutApp.CreateItem(0) With OutMail .To = cell.Value .Subject = Cells(cell.Row, "D").Value .Body = "Dear " & Cells(cell.Row, "B").Value & "," _ & vbNewLine & vbNewLine & _ "Please see your department information as attached to this email. Thank you!" .Attachments.Add (Path & "\" & Cells(cell.Row, "D").Value) '.Send .Save End With Next cell End Sub ******Follow-up Consulting Services****** If you have specific question regarding your issue, you can email me at the email here https://goo.gl/WejijZ Note that there will be a fee of US$50 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: https://www.paypal.me/caripros ******More Videos in Playlists****** Excel for HR https://goo.gl/JdeVnd Excel for HR - Master Class https://goo.gl/LYfq2f Excel Macro - Beginner https://goo.gl/Yae5nc Excel Macro/VBA - Splitting a Master File https://goo.gl/m8CHya Excel Charts Data Visualization https://goo.gl/2ao6BP Excel Vlookup Function https://goo.gl/kP2Wpz Excel Pivot Table Function https://goo.gl/rukkPs Excel Array Function https://goo.gl/i4sQH8 Excel Index and Match Function https://goo.gl/i7VGU4 Excel Solver/Goal Seek Functions https://goo.gl/FTkTnj Excel Cell Formatting Solutions https://goo.gl/gpa6MY HR Analytics - Merit Matrix https://goo.gl/Koy7co HR Analytics - Salary Structure https://goo.gl/uZBnFa Excel Tricks https://goo.gl/TeqGDw Excel Troubleshooting https://goo.gl/bdY5by Fun HR Topics https://goo.gl/7zVg8h For more successful stories, view at: http://caripros.com/index.php/success-stories/ ******Tools I use for this channel****** Channel management: https://www.tubebuddy.com/HRAnalytics "I Love Spreadsheets" Mug: https://amzn.to/2D0bYmL #ExcelforHR#HRAnalytics#Excel#HR
