Thought you'd like to know that even now, after all these years your videos are still tremendously helpful for me. I can't count the times I had to look up something Excel VBA related and eventually ended up with WiseOwl.
I can't believe I am 7 years behind. This would really simplify my life back in the days. Need to roll up my sleeves finally. I watched almost all of your VBA tutorials last year and created some epic macros but I already forgot all tricks I used there. On the one hand when you guide us through the video it is so cool , logic but then when I face the issue myself I keep returning to each video of yours xDDDD to figure out the solution. I need second life to Reach those SQl videos from last weeks. I caught a glimpse of them and they opened my eyes and inspired and show possibilies but it takes a lot of effort to master those VBA skills. 7 years ago you were making such transcending videos. I just can't believe that. Best channel on TH-cam.
I know the feeling Enrike! It's easy to forget if you're not using a skill regularly and there never seems to be enough time to practise everything! But then, if we already knew everything, what would we do then?!
J'm sorry don't understand all you say in your videos, because J don't speak English very well, but J really think your tutorials are the best people can found on internet about VBA. Thank you, thank you, thank you!
Seriously amazing tutorial, thank you so much. For those needing a trick for quickly finding file paths to your attachment is to hold the shift button while right clicking on your file, then choosing "copy as path." Sometimes navigation to the desktop through the windows explorer to get the path can be hard on networked work computers and this simplifies it.
Quite possibly the best VBA videos I have watched. I subscribed to the channel quickly after watching. Thank you for providing such detailed explanations.
Incredible lesson. I would have preferred to have it broken into 3 or 4 separate lessons. It took me several hours to get through it but I now understand how to generate emails from Excel with VBA better than I would have with any other teacher.
Thanks Andrew! Agreed about the length: it turned out to be a lot longer than originally planned. The other videos in the playlist on using Outlook with Excel VBA are a little more manageable I think!
Your videos are the best and very well explained. I'm learning so much about all the different libraries and enums and more. Thank you very much for this video.
I am watching all the videos and i can say its really ultimate also the way you are teaching anyone can understand and learn easily .....hats off to you....... :)
Thank you very much for this. I had coding like this I obtained from someone else over a year ago but it wasn't attaching signatures to any of my files. I had to have additional coding that would do that saving my signature as an image and then attaching that to an email only for the files where only I was the one emailing. It didn't help the shared ones that others would also email. I've only recently started learning code so I don't yet have the understanding that I want, but with this, I was able to tweak my existing code and now EVERY file I use it for is attaching signatures no matter who is sending the email. Thank you again!
Andrew, I really know my stuff because of this series! I ran into a DLL error and knew approximately where to go. Thank you for the early vs late binding info.
this video is really awesome.... I get all my answer in this video. presentation is too good. looking fwd for more videos.... thanks for superb work. Grt work done
@@WiseOwlTutorialsan I ask a question though, I have Microsoft Office Professional Plus 2016 at home and work. It works fine at home, but at work, I get an error of Run-time error ‘287’ Application-defined or object-defined error. It doesn't like the .HTMLBody at the end of .HTMLBody = Email & GetDataHTML & Emailpt2 & .HTMLBody. Only difference between home and work is work we have exchange server. Is this something you are aware of? If I remove the end .HTMLBody, it reads in the data but doesn't add my signature, if I comment out the line, it creates the emails with signature, but obviously no data is read in from excel.
Wickus Koster how do I copy single cell value from excel sheet and paste it to outlook I mean how do I manipulate your getmovie function to get single cell value from excel and paste it to outlook using hrmlbody
Hi Andrew, Your tutorial is awesome!. I have learned a lot & implemented in my daily work. It works fantastically. Thank you once again. Looking more classes on VBA.
Umamaheshwar Askula how do I copy single cell value from excel sheet and paste it to outlook I mean how do I manipulate your getmovie function to get single cell value from excel and paste it to outlook using hrmlbody
I'm pretty sure that I "liked" every video in this VBA - Outlook sub-series as my job deals a lot with Outlook. Based on what you've taught here (and the typical hopping around on the net), I've created some nice email sorters (one using a rather lengthy keyword list on an excel sheet) as well as some email counters that report various data to my colleagues. My only wish is that you would add a few more videos to this Outlook playlist as it seems like there is so much more that can be done in Outlooks using VBA than most people realize. Another series that I'd be interested in is VBA for SAP GUI automation. Though some SAP VBA automation videos already exist, your teaching style, flow, and knowledge of VBA would help tons of people in finance careers that use SAP accounting software. Anyways... thanks again for your videos and the work that you put into them.
Hi AC, sounds like you've made some cool solutions, great stuff! I think at this point Outlook deserves its own playlist and tutorial series rather than squishing more into the Excel tutorial but I'm not sure when that's likely to happen. If you have some specific ideas for topics please do feel free to share them here. On the subject of SAP, sadly we don't use it here at Wise Owl so it's pretty unlikely we'll create a tutorial for this product I'm afraid. Thanks for the suggestions though, and for taking the time to leave a comment, it's much appreciated!
Great tutorial! I knew absolutely nothing about VBA prior to watching this. You're very thorough. I'd like to also know how to attach the current Excel sheet to the email. I want to attach this macro to a button defined in the sheet. Or to create a PDF of the sheet and attach it to the email. Both of which I believe are macros in Excel that are shown on the File tab. I'm using 2010.
Hello every one, I am getting error 4608 "value out of range" when trying to paste an excel table into the email using the Word editor (1:16:50) The thing is it works for me but it does not work for a colleague, both have the same office version and we both have the Word library checked on references. Any idea??
Hi Andrew, your tutorials are fantastic! I've watched almost everything on SQL and VBA. Just 2 months ago my SQL knowledge was absolute zero and my VBA was shaky at best. Would love to see one on how to run SQL query from VBA. As a newbie I find the ADODB object difficult to understand. Thanks and keep up the good work!
Thank you for this Tutorial! This has saved me loads of time at work. My one Question... What if one of the values in my table is a dollar value, how do I get it to populate in my email as currency?
Hi Tiffany! The easiest way is probably to apply formatting in the Excel worksheet and then use the Word editor to generate the email which allows you to copy and paste into the email. This video will help I think th-cam.com/video/1qbBIXFvQdw/w-d-xo.html Good luck!
21:30 Why does displaying body text prior to changing format prevent the signature from displaying? Is there some internal mechanic in .BodyFormat that just rids the signature?
This is by far the most complete. Thank you. Do you know how to hard code the sent from email account from an account other than the default email account? Thank you.
Great Tutorial !!! Is it possible to have predefined body messages , and we get to choose which body need to be used in emails before sending each of them ? ?
Hi Andrew Fantastic explanation of the different ways to generate a signature on email using VBA.if you ever have time I would like an easy way generate a PDF save to my desktop dynamically so it doesn't over right the original and email to a group. I have it working at the moment by recording some of my own macros however I recon there would be an easer way
Hello, this was a great tutorial. do you have a tutorial that would show how to add items from a listbox to the .body of the email? I can't seem to figure out a way to do this.
Hello, Thank so much for that explanation. I follow each comment step by step and I would have one question. I'm at 21:30 and I'm trying to use the code you are using to create the email but I get an error message.In my macro, this line of code is not accepted (when you are trying to get back the signature at the bottom of the email) :.Body = "Dear Someone" & vbCrLf & .BodyThe error message is : "Run-time error '287' : Application-defined or object defined errror"Could it be because I'm using Excel 2016 ?I'll continue watching the video, and see how/if I can get around this.Again, thank you very much!
Thank you for your answer. I don't get this error message when setting the body to a simple string. I got the error message only when I'm concatenating .body to get the signature. Worst case scenario I'll add it manually. Thanks for the link ! I'll watch this video as well. Have a great day =)
Fantastic video! Tons of helpful info. Having a challenge with formatting the emails generated. Everything looks fine in an Outlook client but a gmail client doesn’t recognize table formatting. Your Outlook Sub’s utilize .Display to append the default signature. When I replace .Display with .Send I lose my default signature as expected but I also lose some formatting of a table that resides in my .HTMLBody. I am declaring .BodyFormat = 2. Example: .HTMLBody = “” & myStr & myStr2 & MyTbl & .HTMLBody & “”. The only HTML tags I have in my strings are ’s. Any quick thoughts on what tags might be missing to keep the table formatting? The table is being generated using Excels publish as a web page wizard.
Andrew - many thanks for this video. My code looks identical to screen 12:51 (I've referenced the Outlook 14.0 Object Library), yet on line "Set olEmail = olApp.CreateItem(olMailItem)" I get a runtime error 91 Object variable or with block variable not set. Any ideas?
***** Andrew - Wow what a speedy response. Many thanks! I managed to get that issue sorted out (human error on my part). I've now adjusted my code such that I have a sub that looks like "sub SendEmail(Address as string, cc as string,.... etc)", and I call that subroutine from another subroutine. The SendEmail subroutine (as well as the whole code) works when I step through the code by hitting F8, but when I try to run the whole code, it gives me the following error: "The operation failed. the messaging interfaces have returned an unknown error. If the problem persists, restart Outlook" when the code hits olEmail.Display. Things I notice: 1.When I receive the error message at olEmail.Display, hit debug and mouseover "olApp", nothing pops up. However when I step through the code, by the time I hit olEmail.Display, Mousing over "olApp" will display "Outlook". 2. If I comment out the .send, the code will work like a charm, no issues. 3. No issue if Outlook is manually opened and running while excel code is executed. 4. I beleive issue occurs on the 2nd time the subroutine is called in the main code What may help you diagnose is the info that when I view the locals window after hitting debug when I get the error described, both olApp and olEmail display Code can be viewed here: shrib.com/o3wPSFEU SendEmail sub is at the bottom. (i used slightly different vaiable like olMailMeeting instead of olEmail) Any Ideas? Thanks a mil!
***** Thanks for the response. The things I noticed (ie code working when send is commented out or when outlook is running, or issue occuring during 2nd run of the loop or variables being null, etc) don't ring any bells to you then?
Hi Andrew, How can i format the HTML table in the codes that you have shown. To be precise I want the header (top row) to be bold with light blue fill and along with that I also want the table to have a outline border. Thank you in advance.
This is really helpful, especially for a beginner! I do have one question though, say I wanted to send different emails to different email addresses based on certain criteria being met...how is that done? So almost like the subroutine will check a table row by row, if a row contains say "send reminder" then it will use the email address listed in that row using data in a cell as the body, then continue the subroutine until all entries in the table have been completed. Thanks!
Hi Andrew, this is a great and informative video and just about covers all I need. The one bit I need more help on is more table formatting. I have been brushing up on HTML code but its where to insert it correctly in the VBA code that has me stumped.
Amazing Tutorial! Thank you so much! First time messing with VBA in Excel... The possibilities are endless! I'm working on a file very similar to this one; Excel sheet with some activeX radial options and a submit button. It emails out a formatted HTML email and works great until I try to create a table that has blank spaces in it. the For loops and .end functions are not picking up everything. I've looks around all of today for a solution and even watched a few more of your tutorials, and I can't seem to figure it out. The Columns are not Dynamic, they have 4 Cells to put data in. The rows are Dynamic however in terms of how many entries are put in. Thanks a Million!
Is it necessary when reverting to the Late Binding to remove the OL reference? If not I can leave the reference alone to make it easier to code in future emails.
I would have to say that your videos are the most helpful i have come across. Thank you. I am getting and error at the wdDoc.Range.InsertBefore "Dear Someone" Run-time error'91': Object variable or With block variable not set
Hello, Thank you for all your explanations. I really appreciate your step by step. I'm pulling some information from excel and sending it by email. However, I want to remove my signature. How can I remove the signature from the email without affecting the information I pasted from excel?
Hi !! That's an amazing tutorial. What if I want to attach a picture into email body ? How could I do it ? Also what if I want to set up the picture with hiperlink ? Thank you so much.
Hello Andrew, what if I have one account and two mail addresses in it. The second one is a shared account. I am able to send emails from that one programmatically, but the sent items appear in my primary Sent folder. Could you elaborate on that, too?
Hi Andrew, I want to know how to get senders name, subject and date sent of all mails in inbox or any folder to an excel sheet. Can you help me with that?
Hi Andrew, Thank you for the wonderful tutorial, Its very helpful. I wanted to know do you have any tutorial on filters and selecting the data and copy to another sheet. Any guidance will be appreciated..!! :)
Great tutorial! But how can I insert something via WordEditor method AFTER an otherwise HTML body? When I try to use the Range (Len.....etc method, it overwrite all my HTML.
hi, after creating a table in the body of the e-mail and everything is said and done there is a drastic lag and "thinking time" for the computer (37 seconds to be exact) is there anything that can be done to speed up this process. I have created this worksheet and copied it 31 times (each day of the month) and after doing that it started to lag? any information would be appreciated... thank you
Is there a way to put a date variable on the subject line? For example, the subject line would be “box office for the week of 2/1/21”. And every week you send out the email, the date would change for that week.
Hi Vincent, you certainly can! If you want to use the current system date you can say something like this: mi.Subject = "Info for the week of " & Date You can format the date using the Format function, for example: mi.Subject = "Info for the week of " & Format(Date, "ddd d mmm yyyy") I hope that helps!
Thank you for sharing your knowledge with us, I have learned so much by watching your videos. Question, if email is displayed but I decide not to sent it but close it, is there a condition I can use to let the user know with an msgbox that email was not sent but closed or cancel? Thank you.
I am receiving an error which says "The requested operation requires elevation" when I am trying to create an outlook object either by early binding or late binding method with below statements "Set olApp = New Outlook.Application" OR "Set olApp = CreateObject("Outlook.Application")" It only works when I open this Excel file with "Run as Admin" mode and run my macro. Can you help me to resolve this issue? I do not want to run my Excel with "Run as Admin..." mode to execute my code. I am using MS-Office professional 2013.
Hi Andrew! I hope you are doing good and staying safe and healthy, I am facing a very strange error in outlook attachment and I need your expert help/advice on this. I have an Excel template with ".xlsm" extension, and through excel vba code I am attaching this file in an outlook mail item and then calling the method ".Display" to display the mail and then user put some mail address and then manually send the mail, and when the end user received this mail and when the end user try to open the attached excel file from the mail there is an error message showing that "file is corrupted" something like that and the attach file is not opening. Now the strange part here is that when I attach the file in the mailitem through code and then calling the method ".Display" to show the mail, now the trick is that when the user manually open the attached ".xlsm" file through double click on the file and then close the file without doing anything and then put the email address in the mailitem and then send the mail, and then now when the end user who received the mail try to open the attached ".xlsm" file and this time the file opens without any error. So the trick part here is that open the attached file directly from the display mailitem before sending the mail. My Requirement: I want to find a method or code through that after attaching the file in the mailitem can open the file directly from the display mailitem and then close the file without doing anything, through the code, and then user can manually put the mail address and then send the mail. Is it possible to open an attachment file directly from a display mailitem without saving the attach file? mean I want to open the attach file directly form the display mail item, like we open the attached file through double click on the file. Thanks & Regards Kashif
I really like your Channel and implementing some of your examples in particular this example. I have ten users running your code. Seven of the users have no problem. However, there are three users who are receiving "Run-time error 4608 Method 'Range' of object _Document' failed. It is failing at wdDOC .Range(Len(strGreeting), Len(strGreeting)).Range Thank you for your help and enlightening videos.
Anyone know why you need .Display in order to send a selected range? The code in which he cut and paste a range into an email--if you run that with .Display commented out, the body will be empty.
Hi, I am able to generate email but my challenge is I want to add some more text after table and before signature so any suggestion? The following is to paste table now how to added text after table and then signature should come. wdDoc.Range(vbody_length + 2, vbody_length + 2).Paste Thanks
Hi ther, I think that you might find these two videos useful th-cam.com/video/1qbBIXFvQdw/w-d-xo.html th-cam.com/video/aHOWhxDa7XI/w-d-xo.html I hope that helps!
We should appreciate not only the videos' worth but also your charismatic and affecting tone of voice. Many thanks for the videos :)
Ahh thank you Patrycja!
Thought you'd like to know that even now, after all these years your videos are still tremendously helpful for me. I can't count the times I had to look up something Excel VBA related and eventually ended up with WiseOwl.
Andy, I got so many gold stars at work today after using this video to band-aid an IT issue. Thank you.
That's great to hear, happy that it helped!
I can't believe I am 7 years behind. This would really simplify my life back in the days. Need to roll up my sleeves finally. I watched almost all of your VBA tutorials last year and created some epic macros but I already forgot all tricks I used there. On the one hand when you guide us through the video it is so cool , logic but then when I face the issue myself I keep returning to each video of yours xDDDD to figure out the solution. I need second life to Reach those SQl videos from last weeks. I caught a glimpse of them and they opened my eyes and inspired and show possibilies but it takes a lot of effort to master those VBA skills. 7 years ago you were making such transcending videos. I just can't believe that. Best channel on TH-cam.
I know the feeling Enrike! It's easy to forget if you're not using a skill regularly and there never seems to be enough time to practise everything! But then, if we already knew everything, what would we do then?!
@@WiseOwlTutorials I guess we would do WiseOwlTutorials then;D really you are doing God's work. It's just overwhelmingly useful knowledge there.;)
@@enrikekasijas705 😀 thank you so much!
I cannot express how grateful I am for this tutorial.
Thank you so much Andy.
You have a very good way of explaining things and I love your videos. THanks for doing a great job !
YOU ARE AMAZING ANDREW!! i have watched most of your videos and you have a great skill for teaching. Thank you for sharing your knowledge.
J'm sorry don't understand all you say in your videos, because J don't speak English very well, but J really think your tutorials are the best people can found on internet about VBA. Thank you, thank you, thank you!
Seriously amazing tutorial, thank you so much.
For those needing a trick for quickly finding file paths to your attachment is to hold the shift button while right clicking on your file, then choosing "copy as path." Sometimes navigation to the desktop through the windows explorer to get the path can be hard on networked work computers and this simplifies it.
That's a great tip, thanks David!
Sir, your VBA series videos are very good. My vba skills and knowledge grown exponentially after watching your videos. Keep doing such a great work.
I cannot even tell you how much your videos have influenced my project management. Thank you so much Andrew!!!!
Quite possibly the best VBA videos I have watched. I subscribed to the channel quickly after watching. Thank you for providing such detailed explanations.
Incredible lesson. I would have preferred to have it broken into 3 or 4 separate lessons. It took me several hours to get through it but I now understand how to generate emails from Excel with VBA better than I would have with any other teacher.
Thanks Andrew! Agreed about the length: it turned out to be a lot longer than originally planned. The other videos in the playlist on using Outlook with Excel VBA are a little more manageable I think!
I am so grateful for your videos! I have recently been introduced to the VBA and coding world and I am hooked. Thank you soo much!
Your videos are the best and very well explained. I'm learning so much about all the different libraries and enums and more. Thank you very much for this video.
Thanks Larry! Pleased to hear that you're enjoying the videos! Thanks for taking the time to leave a comment and for watching!
Amazing video! thank you so much! You explain complicated things in such an easy way, great job! Oh and that amazing British pronunciation!!!!
You're very welcome! Happy to hear that you enjoyed the video (and the accent!), thanks for watching and taking the time to leave a comment!
Wow, I always used dim as new in my all applications. I learned something new and I will always use set a new after that. You are really amazing!!!
Thanks!
I am watching all the videos and i can say its really ultimate also the way you are teaching anyone can understand and learn easily .....hats off to you....... :)
Really amazing and very professional. The way you are explaining it is really simple to understand and not complecting like other videos.
Actually, Never mind. I watched one of your other videos and figured it out. YOU ARE A GENIUS!!! Thanks for making me look good. ;)
Very. Love your videos
really brilliantly explained all the aspects of writting code to access outlook...great!!
Thank you very much for this. I had coding like this I obtained from someone else over a year ago but it wasn't attaching signatures to any of my files. I had to have additional coding that would do that saving my signature as an image and then attaching that to an email only for the files where only I was the one emailing. It didn't help the shared ones that others would also email. I've only recently started learning code so I don't yet have the understanding that I want, but with this, I was able to tweak my existing code and now EVERY file I use it for is attaching signatures no matter who is sending the email. Thank you again!
Happy to hear that the video helped! Thanks for watching and taking the time to write a nice comment!
What a great tutorial video! Organized and clear!
Thanks for watching!
Andrew, I really know my stuff because of this series! I ran into a DLL error and knew approximately where to go. Thank you for the early vs late binding info.
Thanks so much! your vba tutorials are BEYOND AWSOME!!!
this video is really awesome.... I get all my answer in this video. presentation is too good. looking fwd for more videos.... thanks for superb work. Grt work done
Very well demonstrated, most needed for me. Thank you....
Happy that you found it useful Manoj!
Very informative, and help me to create a nice little excel procedure for sending some pre-defined emails.
Happy to hear that you found it useful! Thanks for watching and for commenting!
@@WiseOwlTutorialsan I ask a question though, I have Microsoft Office Professional Plus 2016 at home and work. It works fine at home, but at work, I get an error of Run-time error ‘287’ Application-defined or object-defined error. It doesn't like the .HTMLBody at the end of
.HTMLBody = Email & GetDataHTML & Emailpt2 & .HTMLBody. Only difference between home and work is work we have exchange server. Is this something you are aware of? If I remove the end .HTMLBody, it reads in the data but doesn't add my signature, if I comment out the line, it creates the emails with signature, but obviously no data is read in from excel.
As always, fun & learn !
Thank you, Andrew !
You're very welcome Naima, glad you enjoyed it!
Thank you very much for this tutorial. It's extremely informative and a useful tool. Keep up the good work!
Wickus Koster how do I copy single cell value from excel sheet and paste it to outlook
I mean how do I manipulate your getmovie function to get single cell value from excel and paste it to outlook using hrmlbody
Hi Andrew, Your tutorial is awesome!. I have learned a lot & implemented in my daily work. It works fantastically. Thank you once again.
Looking more classes on VBA.
Umamaheshwar Askula how do I copy single cell value from excel sheet and paste it to outlook
I mean how do I manipulate your getmovie function to get single cell value from excel and paste it to outlook using hrmlbody
¡Gracias!
In 15 minutes I've understood much more than in hours in other courses. Than you.
In 15 minutes I've understood much more than in hours in other courses. Than you.
Thank you so much Alejandro!
I'm pretty sure that I "liked" every video in this VBA - Outlook sub-series as my job deals a lot with Outlook. Based on what you've taught here (and the typical hopping around on the net), I've created some nice email sorters (one using a rather lengthy keyword list on an excel sheet) as well as some email counters that report various data to my colleagues. My only wish is that you would add a few more videos to this Outlook playlist as it seems like there is so much more that can be done in Outlooks using VBA than most people realize. Another series that I'd be interested in is VBA for SAP GUI automation. Though some SAP VBA automation videos already exist, your teaching style, flow, and knowledge of VBA would help tons of people in finance careers that use SAP accounting software. Anyways... thanks again for your videos and the work that you put into them.
Hi AC, sounds like you've made some cool solutions, great stuff! I think at this point Outlook deserves its own playlist and tutorial series rather than squishing more into the Excel tutorial but I'm not sure when that's likely to happen. If you have some specific ideas for topics please do feel free to share them here.
On the subject of SAP, sadly we don't use it here at Wise Owl so it's pretty unlikely we'll create a tutorial for this product I'm afraid.
Thanks for the suggestions though, and for taking the time to leave a comment, it's much appreciated!
Great tutorial! I knew absolutely nothing about VBA prior to watching this. You're very thorough. I'd like to also know how to attach the current Excel sheet to the email. I want to attach this macro to a button defined in the sheet. Or to create a PDF of the sheet and attach it to the email. Both of which I believe are macros in Excel that are shown on the File tab. I'm using 2010.
Thank you so much for this video! Helped me out so much!
Happy to hear it Cassio, thanks for watching!
Detailed explanation on each concept with great examples! Thanks for making and sharing them :) very helpful.
Hello every one, I am getting error 4608 "value out of range" when trying to paste an excel table into the email using the Word editor (1:16:50)
The thing is it works for me but it does not work for a colleague, both have the same office version and we both have the Word library checked on references. Any idea??
Awesome explanations!
THANK you!
Thank you for watching!
Hi Andrew, your tutorials are fantastic! I've watched almost everything on SQL and VBA. Just 2 months ago my SQL knowledge was absolute zero and my VBA was shaky at best. Would love to see one on how to run SQL query from VBA. As a newbie I find the ADODB object difficult to understand. Thanks and keep up the good work!
Thank you, you made it very easy to understand and helpful
Thank you so much for your reply. I got the point, also this tutorials are very good and we can learn everything. Thank you so much again
Kudos WiseOwl......your video was very helpful! Cheers bro
You are awesome, great programming and teaching skills... Thanks a ton!!
Thank you for this Tutorial! This has saved me loads of time at work. My one Question... What if one of the values in my table is a dollar value, how do I get it to populate in my email as currency?
Hi Tiffany! The easiest way is probably to apply formatting in the Excel worksheet and then use the Word editor to generate the email which allows you to copy and paste into the email. This video will help I think th-cam.com/video/1qbBIXFvQdw/w-d-xo.html
Good luck!
How Did I miss this one?! Amazing info..thank you Andrew! :)
This tutorial helped me SO very much. Thank you!
Thank you so very much!
You're very welcome, thank you for watching!
21:30 Why does displaying body text prior to changing format prevent the signature from displaying? Is there some internal mechanic in .BodyFormat that just rids the signature?
Hi Roger! This is one of those things that I'm sure has an answer but which I've just come to accept must be done!
Great Tutorial! exactly what I needed!
Happy to help, Artur! Thanks for watching!
Wise Owl you are the best
excellent tutorial. 2020 and the code is still working fine . Thank you
This is by far the most complete. Thank you. Do you know how to hard code the sent from email account from an account other than the default email account? Thank you.
All works fine but not very sure why my signature does not appear when it display new email. Any suggestion?
Great Tutorial !!! Is it possible to have predefined body messages , and we get to choose which body need to be used in emails before sending each of them ? ?
Hi Andrew Fantastic explanation of the different ways to generate a signature on email using VBA.if you ever have time I would like an easy way generate a PDF save to my desktop dynamically so it doesn't over right the original and email to a group. I have it working at the moment by recording some of my own macros however I recon there would be an easer way
Hello, this was a great tutorial. do you have a tutorial that would show how to add items from a listbox to the .body of the email? I can't seem to figure out a way to do this.
with this vba code can you set up to pull data from an excel worksheet for the "to:", "subject:", "from:", etc.
Hello,
Thank so much for that explanation. I follow each comment step by step and I would have one question.
I'm at 21:30 and I'm trying to use the code you are using to create the email but I get an error message.In my macro, this line of code is not accepted (when you are trying to get back the signature at the bottom of the email) :.Body = "Dear Someone" & vbCrLf & .BodyThe error message is : "Run-time error '287' : Application-defined or object defined errror"Could it be because I'm using Excel 2016 ?I'll continue watching the video, and see how/if I can get around this.Again, thank you very much!
Thank you for your answer.
I don't get this error message when setting the body to a simple string. I got the error message only when I'm concatenating .body to get the signature.
Worst case scenario I'll add it manually.
Thanks for the link ! I'll watch this video as well.
Have a great day =)
Hi
Is there any options to call vba code for one outlook application to another out look application
Fantastic video! Tons of helpful info. Having a challenge with formatting the emails generated. Everything looks fine in an Outlook client but a gmail client doesn’t recognize table formatting. Your Outlook Sub’s utilize .Display to append the default signature. When I replace .Display with .Send I lose my default signature as expected but I also lose some formatting of a table that resides in my .HTMLBody. I am declaring .BodyFormat = 2. Example: .HTMLBody = “” & myStr & myStr2 & MyTbl & .HTMLBody & “”. The only HTML tags I have in my strings are ’s. Any quick thoughts on what tags might be missing to keep the table formatting? The table is being generated using Excels publish as a web page wizard.
Andrew - many thanks for this video.
My code looks identical to screen 12:51 (I've referenced the Outlook 14.0 Object Library), yet on line "Set olEmail = olApp.CreateItem(olMailItem)" I get a runtime error 91 Object variable or with block variable not set.
Any ideas?
***** Andrew - Wow what a speedy response. Many thanks! I managed to get that issue sorted out (human error on my part). I've now adjusted my code such that I have a sub that looks like "sub SendEmail(Address as string, cc as string,.... etc)", and I call that subroutine from another subroutine. The SendEmail subroutine (as well as the whole code) works when I step through the code by hitting F8, but when I try to run the whole code, it gives me the following error: "The operation failed. the messaging interfaces have returned an unknown error. If the problem persists, restart Outlook" when the code hits olEmail.Display.
Things I notice:
1.When I receive the error message at olEmail.Display, hit debug and mouseover "olApp", nothing pops up. However when I step through the code, by the time I hit olEmail.Display, Mousing over "olApp" will display "Outlook".
2. If I comment out the .send, the code will work like a charm, no issues.
3. No issue if Outlook is manually opened and running while excel code is executed.
4. I beleive issue occurs on the 2nd time the subroutine is called in the main code
What may help you diagnose is the info that when I view the locals window after hitting debug when I get the error described, both olApp and olEmail display
Code can be viewed here: shrib.com/o3wPSFEU
SendEmail sub is at the bottom. (i used slightly different vaiable like olMailMeeting instead of olEmail)
Any Ideas? Thanks a mil!
***** Thanks for the response. The things I noticed (ie code working when send is commented out or when outlook is running, or issue occuring during 2nd run of the loop or variables being null, etc) don't ring any bells to you then?
***** Bummer. But thanks for the help nonetheless.
Hi Andrew,
How can i format the HTML table in the codes that you have shown.
To be precise I want the header (top row) to be bold with light blue fill and along with that I also want the table to have a outline border.
Thank you in advance.
This is really helpful, especially for a beginner! I do have one question though, say I wanted to send different emails to different email addresses based on certain criteria being met...how is that done? So almost like the subroutine will check a table row by row, if a row contains say "send reminder" then it will use the email address listed in that row using data in a cell as the body, then continue the subroutine until all entries in the table have been completed. Thanks!
Hi Andrew, this is a great and informative video and just about covers all I need. The one bit I need more help on is more table formatting. I have been brushing up on HTML code but its where to insert it correctly in the VBA code that has me stumped.
Amazing Tutorial! Thank you so much! First time messing with VBA in Excel... The possibilities are endless! I'm working on a file very similar to this one; Excel sheet with some activeX radial options and a submit button. It emails out a formatted HTML email and works great until I try to create a table that has blank spaces in it. the For loops and .end functions are not picking up everything. I've looks around all of today for a solution and even watched a few more of your tutorials, and I can't seem to figure it out. The Columns are not Dynamic, they have 4 Cells to put data in. The rows are Dynamic however in terms of how many entries are put in. Thanks a Million!
I figured it out! I used an r.Offset instead of the r.end :)
How to Attach a file with a different name each time? Any code to instruct to look for a certain name given certain rules?
absolutely brilliant, I couldn't thank you enough!
Is it necessary when reverting to the Late Binding to remove the OL reference? If not I can leave the reference alone to make it easier to code in future emails.
1:19:17 - Choosing a Specific Signature
What a great video! You helped a lot :) Thank you so much!
Hi, I want the table to have borders in each cell. How can I do? (in html) thanks!
I would have to say that your videos are the most helpful i have come across. Thank you.
I am getting and error at the
wdDoc.Range.InsertBefore "Dear Someone"
Run-time error'91':
Object variable or With block variable not set
Good video. is it possible to add a picture to the outlook email body through a VBA macro?
Is there a way to modify the "adding attachment" portion to where you add the current/active workbook instead of pulling from a directory?
+WiseOwlTutorials This worked perfectly! Thank you!
This is a very good tutorial. Just want to know how does .htmlBody in htmlBody would show a signature?
How can I add multiple range from different workbook in the email body
You should make a video explaining how to change the session in Outlook with VBA. It is useful if we have 2 mailboxes on the same computer.
You might find videos 29.10 and 29.11 in this playlist useful th-cam.com/play/PLNIs-AWhQzcleylKSN4MS-tJloReq0XcK.html
Hello, Thank you for all your explanations. I really appreciate your step by step. I'm pulling some information from excel and sending it by email. However, I want to remove my signature. How can I remove the signature from the email without affecting the information I pasted from excel?
Hi, Is there a codeto personalise the attachment? I really would like to hear from new in the near future. big thank you in advance.
Hi !! That's an amazing tutorial.
What if I want to attach a picture into email body ? How could I do it ?
Also what if I want to set up the picture with hiperlink ?
Thank you so much.
Hello Andrew, what if I have one account and two mail addresses in it. The second one is a shared account. I am able to send emails from that one programmatically, but the sent items appear in my primary Sent folder. Could you elaborate on that, too?
Hi Andrew,
I want to know how to get senders name, subject and date sent of all mails in inbox or any folder to an excel sheet. Can you help me with that?
Hi Andrew, Thank you for the wonderful tutorial, Its very helpful. I wanted to know do you have any tutorial on filters and selecting the data and copy to another sheet. Any guidance will be appreciated..!! :)
Xldown is taking all blank cells with formula. How can I correct that?
Great tutorial! But how can I insert something via WordEditor method AFTER an otherwise HTML body? When I try to use the Range (Len.....etc method, it overwrite all my HTML.
thank you for your prof explanation , i want to replay to an email with body. how it can be done ?
Goooood job Andrew ! Thank you
hi, after creating a table in the body of the e-mail and everything is said and done there is a drastic lag and "thinking time" for the computer (37 seconds to be exact) is there anything that can be done to speed up this process. I have created this worksheet and copied it 31 times (each day of the month) and after doing that it started to lag? any information would be appreciated... thank you
Dear Andrew, How can I send an outlook email automatically at a predefined date and time?
Super informative. Excellent video thank you!
Is there a way to put a date variable on the subject line? For example, the subject line would be “box office for the week of 2/1/21”. And every week you send out the email, the date would change for that week.
Hi Vincent, you certainly can! If you want to use the current system date you can say something like this:
mi.Subject = "Info for the week of " & Date
You can format the date using the Format function, for example:
mi.Subject = "Info for the week of " & Format(Date, "ddd d mmm yyyy")
I hope that helps!
Thank you for sharing your knowledge with us, I have learned so much by watching your videos. Question, if email is displayed but I decide not to sent it but close it, is there a condition I can use to let the user know with an msgbox that email was not sent but closed or cancel? Thank you.
I am receiving an error which says "The requested operation requires elevation" when I am trying to create an outlook object either by early binding or late binding method with below statements
"Set olApp = New Outlook.Application" OR "Set olApp = CreateObject("Outlook.Application")"
It only works when I open this Excel file with "Run as Admin" mode and run my macro. Can you help me to resolve this issue?
I do not want to run my Excel with "Run as Admin..." mode to execute my code.
I am using MS-Office professional 2013.
Thank you very much. very helpful
You're very welcome, thanks for watching!
Hi Andrew! I hope you are doing good and staying safe and healthy, I am facing a very strange error in outlook attachment and I need your expert help/advice on this.
I have an Excel template with ".xlsm" extension, and through excel vba code I am attaching this file in an outlook mail item and then calling the method ".Display" to display the mail and then user put some mail address and then manually send the mail, and when the end user received this mail and when the end user try to open the attached excel file from the mail there is an error message showing that "file is corrupted" something like that and the attach file is not opening.
Now the strange part here is that when I attach the file in the mailitem through code and then calling the method ".Display" to show the mail, now the trick is that when the user manually open the attached ".xlsm" file through double click on the file and then close the file without doing anything and then put the email address in the mailitem and then send the mail, and then now when the end user who received the mail try to open the attached ".xlsm" file and this time the file opens without any error.
So the trick part here is that open the attached file directly from the display mailitem before sending the mail.
My Requirement:
I want to find a method or code through that after attaching the file in the mailitem can open the file directly from the display mailitem and then close the file without doing anything, through the code, and then user can manually put the mail address and then send the mail.
Is it possible to open an attachment file directly from a display mailitem without saving the attach file? mean I want to open the attach file directly form the display mail item, like we open the attached file through double click on the file.
Thanks & Regards
Kashif
How to write the vba script as a executable file and not inside the Excel sheet?
I really like your Channel and implementing some of your examples in particular this example. I have ten users running your code. Seven of the users have no problem. However, there are three users who are receiving "Run-time error 4608 Method 'Range' of object _Document' failed.
It is failing at wdDOC .Range(Len(strGreeting), Len(strGreeting)).Range
Thank you for your help and enlightening videos.
HI Andrew, how do we email a specific sheet in a workbook?
Anyone know why you need .Display in order to send a selected range? The code in which he cut and paste a range into an email--if you run that with .Display commented out, the body will be empty.
Hi, I am able to generate email but my challenge is I want to add some more text after table and before signature so any suggestion?
The following is to paste table now how to added text after table and then signature should come.
wdDoc.Range(vbody_length + 2, vbody_length + 2).Paste
Thanks
Hi ther, I think that you might find these two videos useful th-cam.com/video/1qbBIXFvQdw/w-d-xo.html th-cam.com/video/aHOWhxDa7XI/w-d-xo.html I hope that helps!