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

  Рет қаралды 10,116

greggowaffles

greggowaffles

3 жыл бұрын

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

Пікірлер: 21
@MultiChanelo
@MultiChanelo Жыл бұрын
Very good tips shown in this video ! Thanks alot for sharing
@tstoneami
@tstoneami Жыл бұрын
...actually THIS is just what I needed. Thank you.
@greggowaffles
@greggowaffles Жыл бұрын
Glad to hear that!
@reagan.dollesin
@reagan.dollesin 3 жыл бұрын
nice to see you post new videos again! hoping to see more! TYSM!
@greggowaffles
@greggowaffles 3 жыл бұрын
Thanks for the support!!!
@ttdseva4830
@ttdseva4830 2 жыл бұрын
Im breaking my head for this. Lucky to see here
@greggowaffles
@greggowaffles 2 жыл бұрын
Thanks for watching!!
@shueybamin5244
@shueybamin5244 3 жыл бұрын
That's very interesting. Thanks for sharing this. 😊
@greggowaffles
@greggowaffles 3 жыл бұрын
No problem. Glad to hear that!
@derwinvandenberg4257
@derwinvandenberg4257 2 жыл бұрын
Thanks. Vey helpful!
@greggowaffles
@greggowaffles 2 жыл бұрын
No prob! Glad to hear that!!
@phunkieemonkiee
@phunkieemonkiee 2 жыл бұрын
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!
@everteero5305
@everteero5305 3 жыл бұрын
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
@yapgladys2298
@yapgladys2298 2 жыл бұрын
Great video, thanks for sharing! But what if I wish to send all the attachment in a folder ? is it possible?
@sandeshpadigela2079
@sandeshpadigela2079 Жыл бұрын
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?
@khoonghoong1233
@khoonghoong1233 Жыл бұрын
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?
@nancywilliamson2471
@nancywilliamson2471 3 жыл бұрын
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?
@ngujennifer3066
@ngujennifer3066 2 жыл бұрын
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
@greggowaffles
@greggowaffles 2 жыл бұрын
not yet, but i'll make a video on this today!
@Steve-fs7ze
@Steve-fs7ze 2 жыл бұрын
Hi Greg, I've followed the code perfectly in my vba, but I get a runtime error 440: 'The object does not support this method" and the debug highlights the .To "email@email.com" line. The email is correct though?
@hechosrandom
@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
Secret Experiment Toothpaste Pt.4 😱 #shorts
00:35
Mr DegrEE
Рет қаралды 35 МЛН
Double Stacked Pizza @Lionfield @ChefRush
00:33
albert_cancook
Рет қаралды 110 МЛН
КАК ДУМАЕТЕ КТО ВЫЙГРАЕТ😂
00:29
МЯТНАЯ ФАНТА
Рет қаралды 10 МЛН
Sigma girl and soap bubbles by Secret Vlog
00:37
Secret Vlog
Рет қаралды 14 МЛН
Excel VBA Macro: Send Multiple Emails (with Multiple Attachments)
12:09
Excel VBA Macro: Send Email (with Attachment)
8:55
greggowaffles
Рет қаралды 58 М.
How To Copy An Excel Range To Outlook Using VBA
18:29
Sigma Coding
Рет қаралды 29 М.
Send Multiple Emails From Excel
10:09
Excel Macro Mania
Рет қаралды 67 М.
How to send BULK EMAILS using VBA in Excel and sending it via Outlook | VBA
16:52
Excel Spreadsheet Support
Рет қаралды 8 М.
Send Emails to Multiple Persons with Multiple Attachments
12:23
Dinesh Kumar Takyar
Рет қаралды 62 М.
Secret Experiment Toothpaste Pt.4 😱 #shorts
00:35
Mr DegrEE
Рет қаралды 35 МЛН