No video

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!!
@derwinvandenberg4257
@derwinvandenberg4257 2 жыл бұрын
Thanks. Vey helpful!
@greggowaffles
@greggowaffles 2 жыл бұрын
No prob! Glad to hear that!!
@shueybamin5244
@shueybamin5244 3 жыл бұрын
That's very interesting. Thanks for sharing this. 😊
@greggowaffles
@greggowaffles 3 жыл бұрын
No problem. Glad to hear that!
@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
@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?
@yapgladys2298
@yapgladys2298 2 жыл бұрын
Great video, thanks for sharing! But what if I wish to send all the attachment in a folder ? is it possible?
@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!
@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?
@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!
@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?
@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
Excel VBA Macro: Send Multiple Emails (with Multiple Attachments)
12:09
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 38 МЛН
Useful gadget for styling hair 🤩💖 #gadgets #hairstyle
00:20
FLIP FLOP Hacks
Рет қаралды 10 МЛН
БАБУШКИН КОМПОТ В СОЛО
00:23
⚡️КАН АНДРЕЙ⚡️
Рет қаралды 17 МЛН
Spot The Fake Animal For $10,000
00:40
MrBeast
Рет қаралды 186 МЛН
Google Sheets Automation - Email On Basis Of Cell Value
11:49
Excel Mind
Рет қаралды 13 М.
IF AND OR Formula in Excel with MULTIPLE CONDITIONS
17:32
Presentation Mastery
Рет қаралды 632 М.
How To Copy An Excel Range To Outlook Using VBA
18:29
Sigma Coding
Рет қаралды 29 М.
How To Automatically Send Customized Emails With Attachments Using Excel Macros
19:40
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 38 МЛН