email

Hi everyone, Happy New Year! I've got the following code below however I can't seem to code it to copy and paste the tables / formats (as per header), only words get exported onto email outlook. Can someone help me to tweek it please? Super appreciate it! Code in question: Private Sub...

Hello, How would I be able to send an email containing who the change is for, and what the change was. For example, if I am changing the date from 12/6/21 to 12/7/21 for Patient X, how would I include that information in the email automatically? Your help is greatly appreciated!

Hello, I have looked through a few of the other threads for this but I have a command button that i want to display an email once the button is clicked. I kep getting an error that says variable not defined. Also in the second image, the two regions of vba keep getting highighted. Overall i am...

I am having issues with the below VBA code that's used to send out invoices via Excel. It does not skip the cells that are blank in the "attachment" columns of the worksheet, instead, it gives me the "File does not exist error" for the first blank and stops the loop completely. Can someone...

Hi, I am trying to create a VBA macro that will generate outlook emails based on unique information in the cells. Every email is different and is going to different people. I need it to be able to generate numerous emails at a time without having to rerun the script. My file is set up so that...

I created a button that takes selected table, copies and pastes it into an email between a note & my HTML signature. Here is the code that was working yesterday but isn't today. ???? Sub Mail_Outlook_With_Signature_Html_1() Dim outlook As Object Dim newEmail As Object Dim xInspect As...

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

Maybe this information exists somewhere but I have searched and searched and come up with nothing that I can actually understand. Here are the basics: 1. I have a spread sheet containing customer information. 2. Among each customer's information is an email address in it's own cell. I...

Hello, I am trying to set up a reminder system for a duty that is to be done everyday by a different person. I have a spreadsheet that looks like this: Name Email Day of month John A john.a@gmail.com 01 Sarah F sarah.f@gmail.com 02 ... ... ... Mike K mike.k@gmail.com 31 I would...

Hi there, I am using the code below to email out a report (using task scheduler & macro launcher to email our daily). The report I'm emailing out contains macro buttons, relating to two modules (Module1 and Module2). The code below works as far as sending the workbook as an attachment, but...

Hi Everyone, I am trying to create a VB with very little VB experience. I would like the VB to create an email for each different email address that is on “sheet 1” with the data relating to their customer code if it has a ‘x’ in the send price advice code column. Each email would need to show...

Greetings, I have a PO log sheet in excel. I want this excel sheet to automatically e-mail a user a list of open PO's, as long as conditions are met. The sheet has many columns, but of importance is column A, column C, Column O, and Column Q. In column A, the date the PO was submitted is...

I'm looking send to specific email addresses by looking for header "Fund Email" and then sending email to first cell beneath matching header. the email address column is not always the same which is why i need it to return the cell beneath (which is where the email address is, eg email header...

Hi. I have this VBA code that copies the current range starting from A1 and emails it out. It works however, the body text gets put below the pasted info and there is no signature. If I remove the body text the signature is there. How can I edit this to put the body text on the top and still...

Hello Everyone! I hope you are all healthy and safe! I wrote a VBA so that Excel will send out email if the value in a cells range changes (days countdown). The VBA write-up works just fine! However, I need to take it a step further! Eventually, I would like my VBA to do the below additions...

I'd like to be able to customise my automated email with font type, size and colour. I understand .Body needs to be .HTMLBody but not sure how to do the rest. Any assistance would be fantastic. Sub EmailAll() Dim OutApp As Object Dim OutMail As Object With Application...

Hello, I am beginner with VBA in Excel. I've just started to use VBA just month ago. Do me a favor? How can I send to the list of e-mail recipients with button provide reminder attachment, such as a series of reminder, so I just need to click one button following the automated reminder set...

Goodevening, I am trying to make some coding in VBA for a certain excel file containing due dates, for which I would like to press a button in the sheet that checks two specific columns for values (remaining days - columns L and P) to be < 15, then sends an email to a specific recipient...

I use Office 365, Windows I would like to send an e-mail with one sheet as a body html, and another sheet attached to it. Was able to find online two vba codes by Ron de Buin working on their own, and I was able to merge them together. The only problem I am facing is that the HTML part is...

Hi all need a help here. So i have a an excel dashboard about a team performance, i have a macro to set excel to send a "screen shot" of the performance dashboard for the agent that is selected on the slicer, but the thing is, i have around 200 agents and doing this one by one is a little by...