Excel VBA Macro: Send Email with Attachments from a List (Dynamic Range)

Excel VBA Macro: Send Email with Attachments from a List (Dynamic Range). In this video, we go over how to send an email with attachments from a dynamic list. We use code to count the number of files in a list and use a for loop to add those files to our email, regardless of how long the list is. We also quickly go over how to choose the font and use the current date in the subject line.

#ExcelVBA #ExcelMacro

[HouseofProduction]

Honestly, I cannot thank you enough Greg. I was able to apply some of your logic with the attachments' code and now my excel works flawlessly.
I'm truly truly thankful and hope this helps more people!

[simonsun]

I am running your code. It looks fine. No error. But there is no email sent out. When I open my outlook application. there is no email in the outlook sent box. What is the issue here? Outlook 2019 is installed. but it seems the code is using outlook 2016.

[kameya]

Great tutorial... just happened to need this macro at work today... will revise my macro based on your format. Thanks.

[tomx]

Hi sir, I'm wondering do you have any video teaches how to add all email addresses from filtered data to the list separated by ";", and only keep unique email address, thank you.

[kranthitiwari]

Hi Sir, how to add an Attachment that is at a particular location and the name of the file changes every week to the present date. what could be the syntax for it

[kendc]

Hi I tried to do this codes but there’s no attachment included when I tried to send.

[fairlymoon]

how do you use this if there is a list of emails, different names and different files. So that it references the row in a sheet for example

[brendanlawlor]

How do you do this, but in the outlook part you send the email based on list of different email address that would pull a specific file .

For example . The saved file is 1234
Then send this file to email 1234

The next would be save file 2345
Send to 2345

Your videos are awesome but that’s the hurdle I can’t find ?

[jimmytiler]

Email gets created but does not attach the files?

[naimsaid]

hello how can i email with mail with many attachments i need vba code urgently i can only one attachments not much thank you

[TheDavbolmac]

Hi Greg, I have a need for something like this.
So i have setup a speedy email creator just like this with purchase orders attached, multiple email addresses entered and a nice little message "Hi, Please see attached your PO &Purchase Order No. Thanks David.
All works nicely. However i would like to send a copy of the spec files with the email. Right now my emails contain one attachment all from the same folder on my C drive. All attachments are .pdf.
The files i would like to attach with each order are also PDF but from a different folder, each file name will share the first 10 digits of the item number and a Revision letter as the final digit. e.g. Item no. VY12-00-016-01 will have an associated file VY12-00-016-XX-B.pdf.
Each PO may contain multiple Items and i want to attach each associated file to the email.

Using your example i have a few ideas but as a relative novice with VBA im sure i wont do it very efficiently or neat, could you put together another lesson showing something similar to this example?

This video is excellent by the way, really hope you'll consider my request.