Excel VBA Introduction Part 29.1 - Creating Outlook Emails

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co... to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here www.lulu.com/s...
By Andrew Gould
www.wiseowl.co.uk - Writing VBA code in Excel doesn't only allow you to control Excel, you also have access to all of the other Office applications. This video looks at how to create emails in Microsoft Outlook by writing code in Excel. You'll learn how to reference the Outlook Object Library, several methods for creating a new instance of the Outlook application and how to create new emails. You'll see how to set basic properties of an email, such as the address and subject and also how to add attachments and make sure that the email includes a signature. The video spends a lot of time talking about the different email formats and how to set the body text of the email according to which format you've chosen; this includes how to write plain text emails, and how to construct basic HTML emails including how to format them. Towards the end the video also shows how to write emails using the Word Editor, allowing you to copy and paste information directly from Excel.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

[@patttkaaa92]

We should appreciate not only the videos' worth but also your charismatic and affecting tone of voice. Many thanks for the videos :)

[@WiseOwlTutorials]

Ahh thank you Patrycja!

[@yp4577]

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.

[@AntoniWroblewski78]

Andy, I got so many gold stars at work today after using this video to band-aid an IT issue. Thank you.

[@WiseOwlTutorials]

That's great to hear, happy that it helped!

[@David-iq1kd]

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.

[@WiseOwlTutorials]

That's a great tip, thanks David!

[@andrewnolan180]

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.

[@WiseOwlTutorials]

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!

[@maurocastagnera8949]

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!

[@oleksijm]

I cannot express how grateful I am for this tutorial. Thank you so much Andy.

[@enrikekasijas705]

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 KZbin.

[@WiseOwlTutorials]

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?!

[@enrikekasijas705]

@@WiseOwlTutorials I guess we would do WiseOwlTutorials then;D really you are doing God's work. It's just overwhelmingly useful knowledge there.;)

[@WiseOwlTutorials]

@@enrikekasijas705 😀 thank you so much!

[@totalzack5000]

You have a very good way of explaining things and I love your videos. THanks for doing a great job !

[@chuchaqui1000]

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.

[@bhar2855]

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!

[@WiseOwlTutorials]

Happy to hear that the video helped! Thanks for watching and taking the time to write a nice comment!

[@tylerziomkowski54]

I cannot even tell you how much your videos have influenced my project management. Thank you so much Andrew!!!!

[@abhishekpandey190]

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.

[@Learning_With_Larry]

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.

[@WiseOwlTutorials]

Thanks Larry! Pleased to hear that you're enjoying the videos! Thanks for taking the time to leave a comment and for watching!

[@davidcarpenter4881]

Quite possibly the best VBA videos I have watched. I subscribed to the channel quickly after watching. Thank you for providing such detailed explanations.

[@yashchawla8360]

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!!!

[@WiseOwlTutorials]

Thanks!

[@letslearnexcel]

Really amazing and very professional. The way you are explaining it is really simple to understand and not complecting like other videos.

[@yasinwarsame3282]

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!

[@gunjanautomation]

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....... :)

[@info2satish]

really brilliantly explained all the aspects of writting code to access outlook...great!!

[@techsalesforce]

Thank you so much for this video! Helped me out so much!

[@WiseOwlTutorials]

Happy to hear it Cassio, thanks for watching!

[@ОлесяРоманівна-р6ч]

Amazing video! thank you so much! You explain complicated things in such an easy way, great job! Oh and that amazing British pronunciation!!!!

[@WiseOwlTutorials]

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!

[@lpohlmeyer]

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.

[@AGASGASDGEWQ2646]

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.

[@cooeee1234]

Thanks so much! your vba tutorials are BEYOND AWSOME!!!

[@Kickassng]

Actually, Never mind. I watched one of your other videos and figured it out. YOU ARE A GENIUS!!! Thanks for making me look good. ;)

[@Kickassng]

Very. Love your videos

[@kumar-manoj]

Very well demonstrated, most needed for me. Thank you....

[@WiseOwlTutorials]

Happy that you found it useful Manoj!

[@AC-cv5zz]

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.

[@WiseOwlTutorials]

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!

[@UmamaheshwarAskula]

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.

[@Abhishekyadav-mo6py]

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

[@FanMaoyi]

What a great tutorial video! Organized and clear!

[@WiseOwlTutorials]

Thanks for watching!

[@Smartieboks]

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!

[@Raidon88]

Thank you very much for this tutorial. It's extremely informative and a useful tool. Keep up the good work!

[@Abhishekyadav-mo6py]

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

[@dsdlonyer]

Very informative, and help me to create a nice little excel procedure for sending some pre-defined emails.

[@WiseOwlTutorials]

Happy to hear that you found it useful! Thanks for watching and for commenting!

[@dsdlonyer]

@@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.

[@colorfulhandmadedreams2207]

Detailed explanation on each concept with great examples! Thanks for making and sharing them :) very helpful.

[@Shaan0112]

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

[@NaimaEchalhi]

As always, fun & learn ! Thank you, Andrew !

[@WiseOwlTutorials]

You're very welcome Naima, glad you enjoyed it!

[@guillaumepaquet1551]

Awesome explanations! THANK you!

[@WiseOwlTutorials]

Thank you for watching!

[@mjjmagicc]

Thank you, you made it very easy to understand and helpful

[@rahulapte2433]

You are awesome, great programming and teaching skills... Thanks a ton!!

[@kamalkumara5338]

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

[@InteligenciadeNegocios]

excellent tutorial. 2020 and the code is still working fine . Thank you

[@cmrobinsDJ]

This tutorial helped me SO very much. Thank you!

[@leeblack2103]

Kudos WiseOwl......your video was very helpful! Cheers bro

[@AmjadMuhammad13]

absolutely brilliant, I couldn't thank you enough!

[@divyal5852]

How Did I miss this one?! Amazing info..thank you Andrew! :)

[@wadduz]

Great Tutorial! exactly what I needed!

[@WiseOwlTutorials]

Happy to help, Artur! Thanks for watching!

[@annamuszynska6106]

What a great video! You helped a lot :) Thank you so much!

[@tiffanyhathaway3429]

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?

[@WiseOwlTutorials]

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 kzbin.info/www/bejne/Z6LFc3yOe9uEmtk Good luck!

[@prasanthk.p6751]

Wise Owl you are the best

[@MV-cv6hz]

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.

[@WiseOwlTutorials]

You might find videos 29.10 and 29.11 in this playlist useful kzbin.info/aero/PLNIs-AWhQzcleylKSN4MS-tJloReq0XcK

[@RoflRAWR1337]

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!

[@RoflRAWR1337]

I figured it out! I used an r.Offset instead of the r.end :)

[@OutForABlast]

Super informative. Excellent video thank you!

[@Texaskids62]

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.

[@accountsoffice2943]

Thank you very much. very helpful

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@paulvarley6872]

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.

[@yutn512]

Thank you so very much!

[@WiseOwlTutorials]

You're very welcome, thank you for watching!

[@mrob5150]

1:19:17 - Choosing a Specific Signature

[@fadge316]

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!

[@marcinkrawczyk4437]

Goooood job Andrew ! Thank you

[@rameshsatkurilinksolutions130]

Am very happy sir am improved my skill

[@TheBanjaara]

Hi Andy, I found your videos quite helpful. Thank you for all the efforts you put in to help people by sharing your knowledge. Could you please help me on how to send email from a particular email account, if I have multiple accounts mapped in Outlook? Thanks in advance! God bless! ❤️😊

[@bradhodge8981]

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

[@tannertucker22]

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.

[@fengfuxu4822]

great video. thanks

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@ericdunham8835]

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.

[@rajeshashok2226]

Thank you so much sir. I need to send e-mail on lotus notes using vba. please add video on how to send an email from lotus notes and how to add attached files, bitmap image's.

[@Timjim77]

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

[@lezerlezerlezer001]

Hi, Andrew. Your videos are awesome! Very helpful! It will be great, if you will make subtitles for all your videos. I'm live in Russia, but unfortunately my knowledge's in English is not good. Can you do subtitles for Russian language?

[@lezerlezerlezer001]

***** +WiseOwlTutorials it sounds great! Just I saw, that there are 3 methods. And I thought, that it will be great to watch your videos with Russian subtitles. Then I could better understand. Thanks for your answer;)

[@alisonwaltrick2002]

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.

[@mroth09]

Hey Andrew, First off this is one of the best KZbin VBA tutorial I've ever seen. Very clear and very helpful. I'm having a hard time with formatting text after copying the table using the wddoc method. I thought I could use wddoc.range(start,end).bold to make to make the text after my table bold but I can't define the length of my table and as a result I can't seem to bold the text I want. Any ideas on how to make a certain sentence or string bold after the table? if I was using an HTML body it would be easy but I'm using a wddoc body so that I can keep my table formatting.

[@mroth09]

***** Thanks for the reply, I did find this method but for some reason it kept placing the bold text after my signature. I tried adjusted the position of the display command like you had done in the tutorial but to no avail. I did find a way around this though. All the writing I needed formatted I created in excel then copied it over as a separate range. Either way this tutorial was a big help and got my project done.

[@jalalkasmani2575]

Very informative. Thanks!

[@cxvoiqw9917]

Hi, These videos are amazing! I just download every VBA tutorials. I was hoping you have something about JAVA by the time I finish all of this. I would download everything if have plans of doing it.

[@somanathalegaon9574]

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..!! :)

[@NidishVashistha]

Dear Mr. Gould The video is fantastic. I learned a lot. Thanks for your efforts. Can you please answer my question, If i have to modify my macro to send Particular Rows from Excel to Outlook E-mail, then In what case, What should I do. I'm stuck. Pls help.

[@tuyoexcelypowerbi]

Really good! same as all videos that you have created. Can we also bring images included in the different signatures? What about if we do not want to show body´s e-mails avoiding the .display in case that we want to send 50 or 100? Can we create or bring signatures with images? Many thanks

[@excelbear6860]

this is absolutely brilliant. i've been searching for excel vba to outlook resources but can only find plain codes but no books or courses. wish there are more to come! what would you recommend if the email body has many components such as different font type, size, bullet points, etc? Is there an easy way to get the html code and place in the vba code?

[@petrov5765]

Great video! Great explanations. Where can I find out more about html body formating? 10x.

[@samriddhtuteja7371]

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 ? ?

[@luluprieto2317]

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?

[@vincentvuong7641]

This is a very good tutorial. Just want to know how does .htmlBody in htmlBody would show a signature?

[@danishali10]

Thank you for all amazingly explained videos. I have learned VBA coding by started watching your videos. I have a quick question regarding creating outlook email. When copy multiple tables into email body how do I find next empty range so my second table goes below the first pasted table? Thank you once again.

[@danishali10]

Thank you for the quick response. I also, created a variable for an empty line so it keeps the space between multiple tables in the email body. Thank you.

[@darrylmoore3772]

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.

[@josemariaabecassis5324]

Very useful, thank you!

[@Carvecrete]

Hi, First, Thanks for putting together some very concise video's, they've been very helpful in getting started. my query is 'how do I put the contents of a cell (say a house number) into the middle of the Subject line?, Also, I get the Word editor version to work fine with my Outlook, but when I try it at work with outlook365 I just get a blank E-mail, s the vb code needed different? I'm a total novice at this. thanks

[@davidwhitey]

HI Andrew, thanks for the tutorial, I have found it extremely useful and your way of presenting is informative and easy to follow and learn from. I have a question regarding inserting hyperlinks into rich text (word editor). Do you know how to do this? In HTML email it's extremely easy, but I can't seem to find out how to add a URL bookmark into the message body of a rich text email. I.e. Click HERE to go to link (where HERE would be a hyperlink off to a URL, but still say the word HERE). Hope that makes sense. Thanks again!

[@vinhthai93]

This is great. Thank you.

[@vinhthai93]

+WiseOwlTutorials More like thanks for sharing your wealth of knowledge. The training within your tutorials has helped me not only with my development but also with my everyday work. Mixing and stringing multi VBA coding into something I wouldn't have thought about doing on the past.

[@priscillaschmidt4849]

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.

[@alanelston2330]

Hello Thanks very much for sharing. I am wanting to learn the “Excel VBA - Outlook way” of automating Email sending as a possible alternative to the “CDO Message way” which I have just mastered. I have the “CDO Message way ” working well and I think I understand it quite well. In fact, some of the general stuff you explained here was helpful to me already. As others have commented, you are very thorough, and I like the way you explain some of the background theory and ideas. I prefer to understand as much as possible about the codes that I am using. So I have the “CDO Message way ” working well, but I would like an alternative. It appears that I must have a “working” Outlook in order to use the “Excel VBA - Outlook way”? Is that true? I have no experience with Outlook and am just a computer novice. Can you recommend a good tutorial which will show me how to set up the minimum that I need with Outlook to allow me to use the “Excel VBA - Outlook way” Thanks Alan

[@alanelston2330]

Thanks for the reply. OK, I need to get clued up on the basic Outlook and get an Email account up and running on it. I’m OK with Excel ( and Word ), but need to look at that Outlook link Thanks again Alan

[@sanjaykanojia3336]

You are awesome... Can you please share Gmail automation vedio...

[@jorgeenriquequinonezmoncad588]

Nice explanation! But I have a question, How could you do the code to send an email every monday and wednesday?

[@jathinsarang]

Hi Andrew, This video was awesome! I want to know how to change the font size and font style if i am using Rich text format with word editor. Can you help me out in this?

[@GARREOLAH]

This tutorial is absolutely awesome!!! I would like to ask regarding this video. Is is possible to mix the formats? I would like to show a HTML greeting, pasting afterwards a table from Excel with its format and then include the HTML signature. I would really appreciate any clue. Congratulations for your great Videos!!!

[@GARREOLAH]

So sad. That's the only thing I am missing in my code. Thanks for taking some time to reply.

[@joskabouw]

THX very much !!

[@franciscolara9462]

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??

[@kashifkhanspecial]

Thanks Andrew! For this knowledgeable tutorial, I have one question, how can I fetch the value from the property/column "Mention" from a mail? like we fetch Sender, Subject etc. Thanks in advance for your help. Thanks Kashif

[@WiseOwlTutorials]

Hi Kashif! I'm not familiar with how to do that in Outlook but perhaps this will point you in the right direction? stackoverflow.com/questions/58214117/create-outlook-email-with-an-mention-for-a-contact-in-the-body

[@ahmedali2512]

NIce Video. Thank You!

[@sriramiyer3558]

Good video. is it possible to add a picture to the outlook email body through a VBA macro?

[@adriandorland4074]

Hi Andre, Thank you for these amazing videos they have taught me a lot and I have not finished all of them yet. I have a question can you open a email template and fill the table with values from the values that are displayed within the excel form? Thank you and great job

[@adriandorland4074]

I mean Andrew

[@adriandorland4074]

Hi Andrew Thank you for your reply. I have worked out away to create an email using the the template and then to use the replace method for example: .HTMLBody = Replace(.HTMLBody, "Some Text Within The Template", "Some Text You Want) or you could use a variable from a form Form1.VariableName.Text I will complete these videos as they are very helpful thank you for your time and dedication to answering our questions Kind regards Adrian

[@DittoGlen]

Andrew, well done as usual. Everything works fine with my Excel and Outlook 2010 until I try to use Len(strGreeting) in the wdDoc.Range Paste call, I get Out of range error when I try to use for start and end, or just start even though its returning 14. At this point I'm not too worried about it, but just off-hand any idea? Thanks EDIT: Sorry its "Method 'Range' of object'_Document' failed Run-time error '4608' EDIT 2: Got it, its because I don't use a signature, so the document ended at the place I was trying to insert the table. Added a signature, and it works fine now.

[@zzLazaruszz]

Function named "GetHead" cracked me up lol