🚀 *Update* : I've released an *upgraded version* of this tool with awesome new features! Now you can add *HTML signatures* , use *HTML formatting* , enjoy improved *error handling* , more *font settings* , and even add *delays* for sending emails-and much more! Please note, this new version is now a *paid template* , but it offers a lot more flexibility and customization. 🌟Get the template here: pythonandvba.com/gmail-excel-blaster
Is there a way to still do this but with outlook? I really like the concept. I would assume the vba would just need to be changed over to a Microsoft Outlook account. Any help would be greatly appreciated.
Amazing Excel template. Works like a charm. Never had any issues. It's also the only Excel template I've found online that lets me add an Excel range to the email, which is super helpful for me. Thanks a ton, Sven! 👍
Thanks for the email video.... If possible can you give the tutorial on how to download and save attachments from gmail and fill up the necessary details in excel.
Thanks so much for watching the video and leaving a comment! Your request is definitely noted. However, I get a ton of requests for custom solutions and, as much as I'd love to help everyone out, I just don't have the time in my schedule to develop and test all of them. I hope you can understand. Happy Coding!
Thanks for you great job. I have one question for you: it's possible to add one image in the email body text? Because I have to show the logo of my company in the email body".
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Hello, This is Suresh, Firstly Its very much useful Template you have done, I want to add my signatures selection in excel file like attachment. is this possible? Because I want to send multiple types of Emails in which i have set that mail template in my multiple signatures.-if possible pls share me the VBA Code for the same.
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Fantastic job! I have 3 questions please: Question1: Is it possible to paste an HTML email template in the body (I have built my templates in Gmail and would like to use them with all the links, pictures, design, etc)? Will the template appear at the end? Question 2: I have link professional email to my Gmail so when I send a message it looks more professional. Since it is linked to my Gmail, is it possible to have the option of which sender email will appear? Question 3: I have my database on excel and I have a different email template to send. Is it possible to include conditions so the right email is sent? Very passionate about your work. Looking forward to here from you
Thank you for watching the video. Regarding your questions: 1) Unfortunately, that is not possible without any modifications to the template. You would need to adjust the 'EMAIL' worksheet to match your current template. 2) If I am not mistaken, you can choose a default sender email (in your Gmail settings) if you have multiple addresses linked to one Gmail account. 3) Also, this is not possible without any further modifications to the template. As a workaround, you could save this template multiple times. For the different messages, you could use a separate Excel file then. That said, the source code is freely accessible in the VBA module. If you feel comfortable, you could adjust it to your needs. Hope this helps!
Hi, its superb work, but have one problem that in "Compile Error: Can't Find Project or Library", Format indicate in this line wsPanel.Cells(i, MailCols.Status).Value = Format(Now, "mm/dd/yyyy HH:mm:ss") & " | " & "ERROR: Invalid RANGE Placeholder" how to solve this please reply soon which microsoft office version you use 2010 or above please be specify thank you
I done know if u see my previous comment but this video is great it helps me so mush, thank you for this content. I have question could I show my name in name fields ... since now when I send an email it does show my name just the email
Thanks for watching the video. Glad you like the Excel template. Regarding your question, kindly try to change your Gmail settings: support.google.com/mail/thread/13357684/how-do-i-change-my-gmail-display-name?hl=en I hope this helps!
I have just checked: It seems that Google does not allow third-party apps to log in: support.google.com/accounts/answer/6010255?hl=en For now, I do not have a solution to this.
Nice video sir.. sir i have multiple employee salary slip in pdf file in my folder.. i have send individual salary slip on individual email.. how can do that on your excel template software
Hello! I am working with the exact thing where I am trying to attach 3 Excel worksheet with one table range and send an automated multi-recipient email. Have you found a new solution without any plug ins?
Hi, due to recent change in GMAIL security politicies,,, I am unable to send email using this macro. It is showing error...any suggestion on that would be great
I cannot get the template to work and I think it is because on my less secure window it says 'To help keep your account secure, from May 30, 2022, Google no longer supports the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password.' Is there a way round this?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
Thanks for watching. I can recommend all videos from the YT channel 'WiseOwlTurorials': ru-vid.com Currently, there is also a FREE Udemy VBA course available, but you need to hurry. The course will be only available free until tomorrow: www.udemy.com/course/excel-vba-from-beginner-to-hero-real-world-business-examples/?couponCode=7590295C684B7037C19C Related Reddit post: www.reddit.com/r/vba/comments/pijhiu/i_created_a_free_vba_course_to_teach_excel_vba/ I hope this help!
Hi, I want to ask how to make status to be like it can detect if the receiver read and unread the email? I have a task to that but until now still unsuccessful. Really need your help
Hey...I have some Excel files and each file contains multiple sheets with same names... let's say each file have some 5 sheets as AUS, IND, US, CA, GB....now when I merge these Excel files, I want all the data of the Excel files to be shown in their respective sheets...instead of creating a new sheet (like AUS(1), IND(1)..etc..)...if this is possible you'll be my saviour...love from india❤️
Thanks for watching the video. Do you want to append the data (adding more rows) to the respective worksheet? E.g. *Input:* 3 workbooks. Each workbook contains AUS, IND, US, CA, GB. Each worksheet (AUS, IND, ..) has 10 rows of data. *Output:* 1 workbook with 5 worksheets (AUS, IND, US, CA, GB). Each worksheet has 30 rows Is my understanding correct?
Thanks for watching the video & sorry for my late reply. Yes, that would be possible. Yet you would need to tweak the code a little, see the example below: www.screencast.com/t/iQaE3kpAJ I hope it helps!
Thanks for watching the video. Yes, that would be possible. Yet you would need to tweak the code a little; see the example below: www.screencast.com/t/iQaE3kpAJ I hope it helps!
@@CodingIsFun Thanks was going through that. And, a quick question, is there a way you can modify the from names in the tool? For instance, I want to use Multiple from names while sending the email. Can we do this?
Thank you very much for watching the video and your comment. Your requirements are well noted. Yet, I receive many requests for creating individual solutions. As much as I want to help, I simply do not find the time in my daily schedule to develop & test all the different requests. I hope you can understand. Thank you!
I've been using this successfully for the past 2-3 months, but recently ran into an issue. Now when I try to send emails I get the following error code regardless of how many emails I try to send. Check your login credentials and try again. -2147220975: The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available. My gmail login credentials have not changed, nor have they been changed in the excel file, and less secure apps is still enabled. Any thoughts?
I think he took it down due to the issue of Google no longer supporting the use of third party apps, thus breaking the template functionality. However, I just posted a fix for this so hopefully he will see it and re-post the template.
