vba email macro

I'd be really grateful if some one could help me with this, I've been trying to work it out for a while but I'm not getting anywhere. I have a VBA to send an email based on individual rows and the data they contain. I'd like a way of sending individual emails to all recipients and the data on...

Hey all, I hope I can get some help here. I have looked around for a solution and have gotten close but not there, it is a tricky one. This is the closest I have gotten: Send email based on date I have an excel spreadsheet stored on onedrive It has 4 sheets with employee details, 3 sheets...

Hi, I have created a macro that sends emails to multiple people. This macro opens an email template from my computer local drive then copies data from a filtered range in excel and paste in a specific location of the email template. I was using the following code to specify the exact location...

Hi Guys, I have a few issues with a userform. It used to work fine but after I made a few changes it stopped working. When you fill out the form it should open 2 emails ans display them before sending them to make sure they have the necessary attachments but it only displays the second email...

Hi Guys, So I am a complete novice in Excel VBA. I want to send email using Excel VBA. I have excel sheet in following format Column A - Name Column B - To Column C - Subject Column D - Path of attachment Now, each row of this excel should open a new email. I have modified a code to suit...

So I have this code: Sub Mail_Sheet_Outlook_Body() 'For Tips see: 'Don't forget to copy the function RangetoHTML in the module. 'Working in Excel 2000-2016 Dim rng As Range Dim sch As Range Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim A As String...

I am building a Macro to create and send emails with a range that changes for each email address. The body creation and addressing work fine, however, when I use SENDKEYS to paste from the clipboard, the command is ignored. I know that the image is on the clipboard as I can manually paste it...

Hi Guys, I hope you are all well today :) I have been using the below to fire off emails to customers. So their Account number appears in Column A & their email in Column B and it then sends off information row by row (C3:I3) to each customer. What I was wondering if anyone knows how I may...

Hi there, I've got an email code that produces and sends an email. I was wondering if it would be possible to IF condition the email so that it sends only under certain conditions. What I would like to have is: If day = Friday and Time = 4:00pm then email code...