Send or Draft Multiple Outlook Emails with Attachment Automatically




About this tutorial:

Video duration: 8:35
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

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

2 thoughts on “Send or Draft Multiple Outlook Emails with Attachment Automatically

    cindy geovani

    (February 3, 2019 - 10:22 am)

    Hi Thankyou very much for the tutorial, It’s very helpful for a beginner like me.

    Could you also provide a tutorial of how to combine this “Save Sheets as Multiple Files with 1 click – VBA for Beginner” video and “Send or Draft Multiple Outlook Emails with Attachment Automatically“ video only with 1 click?
    I need to do those 2 tasks, but I also want to do it only with 1 click.

    All of your tutorials are very helpful for me, so I hope that you can also help me with this case. Thankyou very much in advance 🙂

    Mahesh Zanzrukiya

    (February 3, 2019 - 10:22 am)

    Ooooooooooosome video and idea 👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
    Can we Add PDF files ?

Leave a Reply

Your email address will not be published. Required fields are marked *