Excel VBA Macro: Send Email with Multiple Attachments (Based on Cell Value)

Excel VBA Macro: Send Email with Multiple Attachments (Based on Cell Value). In this video, we create a macro that automatically sends an email with multiple attachments in Outlook. We start off with typing the file paths directly into the code and then referencing cells in an excel workbook in order to add attachments based on cell value. We also quickly go over how to choose the font and use the current date in the subject line.

#ExcelVBA #ExcelMacro

[tstoneami]

...actually THIS is just what I needed. Thank you.

[MultiChanelo]

Very good tips shown in this video ! Thanks alot for sharing

[reagan.dollesin]

nice to see you post new videos again! hoping to see more! TYSM!

[Smartbirds]

Im breaking my head for this. Lucky to see here

[everteero]

Great video! Have you also found a way how to attach file that was just generated with specific name and uploaded to onedrive? So way how to generate a file with one click and automatically attach to an e-mail

[shueybamin]

That's very interesting. Thanks for sharing this. 😊

[phunkieemonkiee]

Hey there! Thank you for sharing this. I am NEW NEW to macros and VBA. Is there a way to edit this script so that it includes multiple emails with multiple attachments. For example x named files from file path to x email and z named files to z email? I have a macros that split a doc based on who I need it to go to and then a macros to send out those emails but trying to send all emails in one macros ... or even Mary the two if possible. Thank you in advance for any guidance! (: Cheers!

[sandeshpadigela]

This is a really good trick, thanks for taking the time to share knowledge, I do have a question extent of this. 1) We have employee performance data with multiple details, 2) we get this data week basis 2) We select each employee's data from the validation list 3) We take this screenshot 4) Copy the screenshot in an email 5) Send that to employee - I see challenge to select 20 employees from data validation list and copying screenshot, is there any way we can work on this?

[yapgladys]

Great video, thanks for sharing! But what if I wish to send all the attachment in a folder ? is it possible?

[khoonghoong]

Is it possible to make a dialog box to select multiple files in ordre to attach the selected file rather than copy the path of file to make it a list in excel?

[ngujennifer]

Hi, do you have one with tables but paste as picture, cos my table is too big when paste on the email, many thanks, regards

[nancywilliamson]

Can you show me how to make a cell link to an email, therefore when someone clicks that button it sends the attachment to my email?

[hechosrandom]

Great video! Have you also found a way how to attach file that was just generated with specific name and uploaded to onedrive? So way how to generate a file with one click and automatically attach to an e-mail