O.m.g. i have been looking for something like this for years!!! Other instructions have no attachment, or one attachment one path, but just not everything. This has absolutely everything and its the exact scenario i was after. Whilst explaining the code so it makes sense and possibly alterable. Maybe add one set attachment and one specific attachment. Add the cc. Email, or set the from email.. And the button!!! Everyone just expects ppl to press F5 This is AMAZING!! Thank you thank you thank you
noooo, not sure why but I keep getting a path error? is there a limit on where the file is saved? (one drive) and the file is named "text.txt" but no brackets on the worksheet and it doesn't work for some reason...
This totally just made me a rockstar at my temp gig and may have landed me a staff position. Or maybe I'll raise my rates and start doing exclusively consulting work because it also saved me 40 of work (which effectively costs me a week's worth of pay, sigh - hourly pay is such a weird concept...). Thank you!
Thanks. I love this course. U opened my eyes for Excel..... I have a question to u or somebody - I want to be able to send email from a spesific mail account in MS Outlook. How to do that?
Thanks for such a great tutorial, I have a question, is there any way to put a check, mark or something so if it has already sent it once, it does not send it again to the same person every time we click that button?
This video is just what I needed. Question though: on my outlook I have access to two separate email account (a personal and a general account for my place of work). Only through my personal account am I able to use the microsoft apps for excel and such. Is there a way through the VBA that I can have the emails generated send from this second account, so it is sent from the work email rather than my personal? Thanks very much!
Amazing it works ! Is it possible to include one of outlook's predetermined signatures in the code ? Ij ust have trouble spacing first and second name with R.Offset (0, X) so doing those and the signature manually Thank you !
Thank you for the video and for providing the Excel macro. I have adapted it as shown in the video but I get the error message with the attachment although it should actually work. Does anyone know what the problem could be?
This is amazing! Thank you very much for the video. One small thing is that when it creates the email with the attachments, it says that it cannot find the file in a runtime error warning pop-up. However the file is successfully attached. Any ideas what I could be doing wrong even though the code is actually working.....?!?!
Really nice and comprehensive video. If I want to send the same mail to several mails in my TO: field, Do I just input all mails in the same Cell separated by a coma..??
The only problem in this code is, if there is only 1 row, it goes in a loop, and for my file it's not gonna work, thank you for the content by the way. Can you please help me with this case?
Mr. Tugwell, is it possible for you to provide the update to this code for multiple attachments? I know it is probably a loop in the loop but I am not quite able to write the update and I truly need to send multiple attachments for a very important project at work. I have looked for help and your video here has been the only one capable of doing exactly what I need and being simple at the same time. I do not want to have to rewrite this from someone else's example as they are very complicated. Please help!
Mr Tugwell if our company email has a signature that is usually applied to any new email that gets sent is there a way it will still be included when the emails are sent using this automation?
Hi Chester, I have a question - if I put only one row of e-mail addreses (just for sending one email), the VBA makes it an infinity loop. Do you know the solution to this problem?
Great Tutorial! Thanks! Two questions: 1. I have two email accounts at work and need to use a specific acount to send these emails from. how can I add this to the code so it is selected automatically? 2. When I add .Send to the code it returns a Run-time error '287' Application-defined or object-define error. My code is exactly like yours and with .Display it works perfectly, any tips to solve the issue with .Send? Many Thanks!
Is there a way to handle the email classification using vba before sending email , as my org has Microsoft Azur protection classification for emails we send
Can you help me? I am facing a problem with the aforementioned attachment file. Can you help me with the way to link the name to the attachment and the MBF of the attachment Thanks
This is great, but we have a problem because we are using Microsoft default mail from Microsoft store. (not outlook). New outlook email vba macros does not work in mail app. Any suggestion.
How would you make this work if you would like to have more then one file as an attachment to one email? And also if you would like to have this sent to more then one email address or with a CC. Does anyone have any good suggestions/solutions?
You are great, I am very very newby on excel and I was able to do mostly everything. I ran into an error in the end, Ru-time error 438, anyone else went thru this and now how to fix it? The email is not sent, but it does record in the Record of invoices as sent.
I get the same problem. If I replace the word 'Display' with 'Send' and leave everything else the same, I get a runt-time error. Changing the word back to Display resolves the problem... but I don't want it to Display :( Great tutorial otherwise, thank you.
Ecellent Vba code Sir, please can you share the code wihere we can add several attachment base on a cell reference , this will complete my weekly issue
I wonder if there is a way to change colour of the message (partly)? I searched over the internet and most of them are dealing with HTML. But i have no knowledge in this field enough to apply them to this version :(
the Attachments.Add (path & R.offset (0, 3) triggers an "cannot find this file, verify the path" and yet if i step thu the code it shows the path and the offset. Help please
Hi.. small question. I'm sending an email using vba, with data in the body that comes from my excel list. Unfortunately when it comes to numbers, it loses it's formatting. For example; In excel is written 1.500,70 in the email it writes only 1500,7. How can i solve this that it also writes as 1.500,70 in the email? Thanks a lot for your help!!!
Great videos! One question - how do I add my email signature to the above code? I have tried a few different things, but I have so far been unsuccessful. Any help would be greatly apprecaited.
I am getting a bug: "I cannot find this file. Verify the file and path name." To get the path name of my desired Excel document, I clicked on the document and clicked " copy path" in the folder. Does the cell need to be the name of the, document or a link to the document?
My script made it so it keeps sending emails to nothing and it does not have the name or email in it, but the body text does indeed work. Whatever it is, its not grabbing the input data from the excel worksheet. I did not include the attached script in mine , I do not need it.
Sir Can you help me my ex company has auto mail sender sheet 1 was same as your but Sheet 2 has Full Table and automatic match customer code and separate file and attached automatic
Great video, thanks! If I want to send email with two attachments I will just have to add another line like this one: .Attachments.Add (path & R.Offset(0, 3)) but instead "3" I should put number of column with name of another attachment right?
Help me to make a VBA code to send 20 files. Just like you did it need to add up a little bit more. Let me give details a little bit. Each mail has a different attachment and mail body. Like if I am sending my 1st mail. I will open that excel file, go to a particular sheet, copy data, paste it to the email body, and attach that same file as an attachment. Once the mail is ready then that file gets closed. And then with 2nd mail and it will go on for 19 times.
Wow. I wanted to know how to do this for years and now I finally can. It worked!! Thanks so much!!
This is Genius !! Take a bow !! You made it so simple. This shows not only you have knowledge but qualities of a good teacher/Trainer.
O.m.g. i have been looking for something like this for years!!! Other instructions have no attachment, or one attachment one path, but just not everything. This has absolutely everything and its the exact scenario i was after. Whilst explaining the code so it makes sense and possibly alterable.
Maybe add one set attachment and one specific attachment.
Add the cc. Email, or set the from email..
And the button!!! Everyone just expects ppl to press F5
This is AMAZING!! Thank you thank you thank you
noooo, not sure why but I keep getting a path error? is there a limit on where the file is saved? (one drive) and the file is named "text.txt" but no brackets on the worksheet and it doesn't work for some reason...
Thank you so much!!!!!!!! I'm an absolute newbie in VBA and after learning from you made my first code and it works!!!!!!! Thank you!
i dont usually sub and like and follow YT channels but when i find it very helpful i do so. thank you for this. you got a new sub.
Thank you Chester , it was beautifully explained and a quick tutor , Thanks again !!🙏👍
Thanks!
Many thanks!!!!
Wow !! Many thanks for this. It saves so much time.
Thank you! Amazing, you save me so much time!
Thank you so much! So well explained and really useful code!
Thanks a ton!
I am very much blessed by this utility.
It is working fine.
I am grateful!
Hands down best Sheets tutorials on TH-cam IMO. I appreciate the vids my friend!
Thank you isnt enough - it's Simple and it works - Amazing 😀
thank you so much, this is awesome, this is such a good tutorial, great explanation
This totally just made me a rockstar at my temp gig and may have landed me a staff position. Or maybe I'll raise my rates and start doing exclusively consulting work because it also saved me 40 of work (which effectively costs me a week's worth of pay, sigh - hourly pay is such a weird concept...). Thank you!
Awesome. Thanks... The Right thing I was looking for
Thanks Chester. I was able to add my default signature by changing ".body" to ".HTMLbody" then at the end of the body text append " & EItem.HTMLbody"
Simple and functional. Can't ask for much more. Thanks so much.
very easy to understand. I like your pace excellent and thanks a lot.
Amazing piece of code and illustration.......a million thanks
Very nice explanation. You make it look like a piece of cake. Thanks a lot!
Nicely Done Sir!!!
Thanks man. Still i am not tried it. But even hope so it's will definitely work❤
Hi i am following your channel for the past 2 years i learned a lot can you teach me send pivot table in mail using VBA
Have you got anything on how to add a signature to that script?
Great video, thanks; and what about if I need to send two attachments in every email?
Nice! Could multiple attachments?
Thanks for the video, it's indeed very helpful. I wonder how I can add a pre-defined signature in outlook to my emails using VBA...
Thanks. I love this course. U opened my eyes for Excel..... I have a question to u or somebody - I want to be able to send email from a spesific mail account in MS Outlook. How to do that?
Does the code exist to specify the From portion of the email?
Excellent, great video.
This is great, can we also use outlook webmail instead of outlook application?
Very helpful video, thanks so much! What additional lines of code are necessary to send from a shared mailbox?
Thanks for such a great tutorial, I have a question, is there any way to put a check, mark or something so if it has already sent it once, it does not send it again to the same person every time we click that button?
As usual Fanbloodytastic tutorial, you make it so simple, thank you. 1 Question is there such a command as set email area like the set print area?
Brilliant piece of code
Very clean and informative.
This video is just what I needed. Question though: on my outlook I have access to two separate email account (a personal and a general account for my place of work). Only through my personal account am I able to use the microsoft apps for excel and such. Is there a way through the VBA that I can have the emails generated send from this second account, so it is sent from the work email rather than my personal? Thanks very much!
You are the best ! Thanks a lot!!!
Amazing it works ! Is it possible to include one of outlook's predetermined signatures in the code ?
Ij ust have trouble spacing first and second name with R.Offset (0, X) so doing those and the signature manually
Thank you !
works like a charm
Thank you for the video and for providing the Excel macro. I have adapted it as shown in the video but I get the error message with the attachment although it should actually work. Does anyone know what the problem could be?
This is amazing! Thank you very much for the video. One small thing is that when it creates the email with the attachments, it says that it cannot find the file in a runtime error warning pop-up. However the file is successfully attached. Any ideas what I could be doing wrong even though the code is actually working.....?!?!
Thank you very much, been trying to set a cell with a special format but cant figure it out
Hi! Does this work also with web outlook?
Really nice and comprehensive video. If I want to send the same mail to several mails in my TO: field, Do I just input all mails in the same Cell separated by a coma..??
I don’t know the answer, but usually emails are separated by semi-colons in the TO: field. Hope that works!
it worked. Thankss sooooo much.
This is great. Is their away to do the same but as a calendar invite rather than an email?
What if you needed to have your Dim Path set yo be variable , such as retrieving the most recent file in the download folder
The only problem in this code is, if there is only 1 row, it goes in a loop, and for my file it's not gonna work, thank you for the content by the way. Can you please help me with this case?
Thank you for the information :)
Mr. Tugwell, is it possible for you to provide the update to this code for multiple attachments? I know it is probably a loop in the loop but I am not quite able to write the update and I truly need to send multiple attachments for a very important project at work. I have looked for help and your video here has been the only one capable of doing exactly what I need and being simple at the same time. I do not want to have to rewrite this from someone else's example as they are very complicated. Please help!
Great video! Ho would I go about adding my signature at the end of the email?
what if we need to add the signatures in the body?
Mr Tugwell if our company email has a signature that is usually applied to any new email that gets sent is there a way it will still be included when the emails are sent using this automation?
Hi Chester, I have a question - if I put only one row of e-mail addreses (just for sending one email), the VBA makes it an infinity loop. Do you know the solution to this problem?
How do I bold out some of the strings in the body of the mail?
Hi Chester, thank you very much for this excellent video. Could you tell me how to do it so I can send through Gmail?
Great one! Thanks Chester!!
Awesome. How to skip a row if cell is empty?
Well done!
wow. love it. thanks
Great Tutorial! Thanks!
Two questions:
1. I have two email accounts at work and need to use a specific acount to send these emails from. how can I add this to the code so it is selected automatically?
2. When I add .Send to the code it returns a Run-time error '287' Application-defined or object-define error. My code is exactly like yours and with .Display it works perfectly, any tips to solve the issue with .Send?
Many Thanks!
Is there a way to fully automate the process since with this code I still need to open excel and push a button.
Is there a way to handle the email classification using vba before sending email , as my org has Microsoft Azur protection classification for emails we send
Can you help me? I am facing a problem with the aforementioned attachment file. Can you help me with the way to link the name to the attachment and the MBF of the attachment
Thanks
How. To do it if same attachment sent to multiple mail IDs. Like 2000 of em
How would you do this if you want to send the email to multiple people?
This is great, but we have a problem because we are using Microsoft default mail from Microsoft store. (not outlook).
New outlook email vba macros does not work in mail app. Any suggestion.
Hi I am getting below error.
file path error , verify the file and path name is correct
This was really helpful. Thanks
Is it possible to add multiple email in TO section of Outlook instead of send emails seperately to each individual person?
How would you make this work if you would like to have more then one file as an attachment to one email? And also if you would like to have this sent to more then one email address or with a CC. Does anyone have any good suggestions/solutions?
You are great, I am very very newby on excel and I was able to do mostly everything. I ran into an error in the end, Ru-time error 438, anyone else went thru this and now how to fix it? The email is not sent, but it does record in the Record of invoices as sent.
Thank you, very useful. but if we need to add cc email. where to but the code. thanks.. I added .Cc = "email" after .To line and it is working😃😁😁😁
. display works perfectly. .send gives me a run-time error. Can anyone help?
I get the same problem. If I replace the word 'Display' with 'Send' and leave everything else the same, I get a runt-time error. Changing the word back to Display resolves the problem... but I don't want it to Display :( Great tutorial otherwise, thank you.
Ecellent Vba code Sir, please can you share the code wihere we can add several attachment base on a cell reference , this will complete my weekly issue
I wonder if there is a way to change colour of the message (partly)?
I searched over the internet and most of them are dealing with HTML. But i have no knowledge in this field enough to apply them to this version :(
I want VBA code for sending different files by selecting folder to different email. could you please help me out?
Hi, question - what if I added new entries but I just need only those new entries to send via outlook., what code should apply?
Can you show how your folder looks like with the attachments?
the Attachments.Add (path & R.offset (0, 3) triggers an "cannot find this file, verify the path" and yet if i step thu the code it shows the path and the offset. Help please
what is your outlook Version
great sir, thanks
Hi.. small question. I'm sending an email using vba, with data in the body that comes from my excel list. Unfortunately when it comes to numbers, it loses it's formatting. For example; In excel is written 1.500,70 in the email it writes only 1500,7. How can i solve this that it also writes as 1.500,70 in the email? Thanks a lot for your help!!!
Great videos! One question - how do I add my email signature to the above code? I have tried a few different things, but I have so far been unsuccessful. Any help would be greatly apprecaited.
I am getting a bug: "I cannot find this file. Verify the file and path name."
To get the path name of my desired Excel document, I clicked on the document and clicked " copy path" in the folder.
Does the cell need to be the name of the, document or a link to the document?
I tried this, everything is working perfect while displaying but when i changed it to send then only blank email is going to customer with attachment
Thank you
Watching the video, I still find it difficult to refer to the emPL software that sends receipts and salary slips automatically via email or Zalo.
Hi Sir can you please tell me how to add more than 3 person in CC of sending email
@gurumoorthy5282 Did you figure out how to add one email or more as CC?
My script made it so it keeps sending emails to nothing and it does not have the name or email in it, but the body text does indeed work. Whatever it is, its not grabbing the input data from the excel worksheet. I did not include the attached script in mine , I do not need it.
Sir Can you help me my ex company has auto mail sender
sheet 1 was same as your but Sheet 2 has Full Table and automatic match customer code and separate file and attached automatic
Great video, thanks!
If I want to send email with two attachments I will just have to add another line like this one:
.Attachments.Add (path & R.Offset(0, 3)) but instead "3" I should put number of column with name of another attachment right?
did it work?
if i want to end the same pdf attachment via whatsapp with message. pls share code
Help me to make a VBA code to send 20 files. Just like you did it need to add up a little bit more. Let me give details a little bit. Each mail has a different attachment and mail body. Like if I am sending my 1st mail. I will open that excel file, go to a particular sheet, copy data, paste it to the email body, and attach that same file as an attachment. Once the mail is ready then that file gets closed. And then with 2nd mail and it will go on for 19 times.
Thanks
Everything works fine until the button which wont send, but if i say run in the vba module it does. Anyone any ideas
Pls can u help on this
Hi sir can please same create in Google drive please