email

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

Hey Guys, I have a really annoying manual task I do everyday for work: Receive an email (always same subject and body format) into a shared mailbox in Outlook. In the body of that email it has a client name (again, always same format). I look up the client against the account manager name in...

Hello - I receive an email every day with a link that takes to me to folder. That folder houses a PDF I need to share with colleagues. I've asked that the email contain the PDF rather than the link but have been told it will take some time. Is there a way I can run a macro in Outlook to click...

Hi, I'm trying to get the following code to only attach a pivot table on the page as the pdf. Private Sub CommandButton1_Click() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As Object ' Define PDF filename PdfFile =...

Hello, I made an active X button that takes a range and turns it into a jpeg and then sends it by e-mail. I need this selection to be conditional as the range will vary since it is based on a pivot table. Here is the code: Private Sub CommandButton1_Click() Dim xOutApp As Object Dim...

Hi, I am hoping someone could please help me. My situation: I have to send information from excel via email, individually to different recipients. The subject lines change every day but are constant for across all recipients. The body of the email is always individualized. Example: email...

I am using the Ron de Bruin macro to send automatic emails to various users and that is working perfectly. As below: Sub Send_Files() 'Working in Excel 2000-2016 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm Dim OutApp As Object Dim OutMail As Object Dim sh...

I have a code built that, upon clicking a command button, displays an email to a coworker when a cell in column P is "X". When a cell in column P is updated a date stamp is automatically entered into the adjacent cell in column Q. How do I update my code so the email displays only if the...