How to send BULK EMAILS using VBA in Excel and sending it via Outlook | VBA

[@yashmitsingh4315]

I am not macro expert but i look for ways how to send Auto email, i tried with many you tube vedios but it was your who helped me to send. Thank you very much and the way you explained is really helpful.

[@excelspreadsheetsupport]

Thank you for your comment

[@epark9925]

Great step by step video. How would I change the EmailTo when one email is being sent to multiple recipients with one attachment. I have emails in range B and the email addresses may increase or decrease. Your suggestion will be appreciated.

[@bzb23]

Great video and well explained, I do have a kind of use case where I need this kind of functionality, but to go forward in my case the recipient can have more than one line so how I can avoid to send multiple mail to the same person ? Secondly I want to log all mail sent in another spreadsheet, how is it possible?

[@Muiz_Ismadi]

Hi, is there any way to use this tips using Outlook(PWA)? Not the installed software but website version. Appreciate if you could reply me. Thanks :)

[@ahchinliao4890]

Hi. Please assist Can I add a if statement based on a value of a cell? Thanks

[@robbybohl8500]

So I’d like to send emails from excel in much the same fashion but rather than going through the row counter, I’d like to be able to send an email for one row at a time. How would I change the script so that I could just select the row I wanted to email? Could I just change the outlook variable sheet1.range(“A”).value rather than including the cell number? The spreadsheet I work on lists individuals that have already been emailed and those that still need to be emailed so I need the ability to email each row individually

[@excelspreadsheetsupport]

Inside the For Loop before "EmailTo =" variable you need to add an IF statement, such as " If Sheet1.Range("E" & RowCounter) = "X" then " the column E in this example being where you will place the X to indicate an email must be created. DOnt forget to close the IF statement with "End if" before the line "Next RowCounter". If you did this correct then you now jus tneed to place an X in the relevant column for the lines you wan tot email before you press run macro. Good luck

[@MrProactiveman]

How to link sending emails by specific variable date

[@abdulhaji1017]

how to bold and font format the body?

[@shubhamrajpure3474]

Did you know now how to do formatting

[@saichaitanyabachina1999]

Hey... Can we send delayed outlook mails using vba?

[@excelspreadsheetsupport]

Hi Sai, yes you can - add the following: Dim DateSend As String DateSend = Sheet1.Range("A1") 'or any other cell Then add within the With block above ".send" .DeferredDeliveryTime = DateSend place your date/time in the cell then run code. Your emails will then be sent to your Outlook OUTBOX and will stay there till the time is reached (just remember OUTLOOK can only send the emails when the program is open/running)

[@saichaitanyabachina1999]

@@excelspreadsheetsupport Thank you so much This helped me.

[@excelspreadsheetsupport]

@@saichaitanyabachina1999 my pleasure

[@shubhamrajpure3474]

How to make email body Bold,Font

[@shubhamrajpure3474]

What about email body formatting

[@ivanbarrera3]

It shows the following message: Microsoft Excel is waiting for another application to complete an OLE action.

[@excelspreadsheetsupport]

This could be happening due to so many reasons. See the link provided to hopefully help you troubleshoot the issue. Perhaps you can close all your Microsoft apps and restart your computer. Hope this or the link provided helps. softwarekeep.com/help-center/excel-ole-action-waiting

[@ivanbarrera3]

Thanks! Do you know if the same "Outlook.Application" part of the code works as well for the New Outlook? I thought that might be part of the issue@@excelspreadsheetsupport