1. E

    VBA to send email based on cells' value to recipients in excel sheet and include cell's value in the email's body

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

    VBA - email body to allow font type, size and colour

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

    How can I send to the list of e-mail recipient with button provide reminder attachment, such as a series of reminder from expired date?

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

    Excel VBA - Button that sends email containing specific range of cells based on value

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

    e-mail sheet in html and attach a spreadsheet

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

    macro to send emails from slicer

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

    Automating Simple Email Forwards using VBA

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

    VBA in Outlook (Office 365): pull PDF from link in email into a new email

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

    VBA attach pdf to email (pivot table)

    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 =...
  10. A

    VBA conditional range selection for jpeg

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

    From excel rows to email

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

    Macro used to send automatic emails

    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: Dim OutApp As Object Dim OutMail As Object Dim sh...
  13. R

    VBA code to send email when two cells in adjacent columns are contain specific data

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


    Hello, I found a code in MREXCEL that works very well but I need to tweak it a bit but I am not able to do so. This code generates an email based on 2 different types of text in column L: "Expiring Soon" and "Expired". 1) This code inserts the text in Column A and puts it in the email body...
  15. C

    Getting value to email

    Hello!, How can I get the value to populate into an email of row 1?. I can get row 2, 3 and so on, but since row 1 it Dynamic Serial number. If I copy "=Row() -1" into .Htmlbdoy it wont work. THanks
  16. D

    Send email using specified data from table, I have tried mail merge but there are too many characters

    Hi i am using this tracker below , I am trying to automate some processes as much as possible , so as it stands the hyperlinks work and bring up outlook with the fields required , i was trying to get it to populate them as well based on the values in the repsective cells. But i get a value...
  17. N

    VBA Email Automation

    Hello Guys Im new here and seeking some help in VBA okay so I have a report that I usually do, and I already made a macro that splits the report to pages depending on the country name. I want a vba that reads the sheet name, and send the sheet only to the assigned email for this sheet, the...
  18. S

    Pull a number from a cell and add to the subject of an email.

    I have a button on a workbook template that will save the work book and attach it to an email. I want to incorporate the ID number into the subject of the email. This number is changed each time the template is used. For example: If the ID number is 000001, I want the email subject to read...
  19. M

    VBA to give an error message when button is clicked and some cells are empty

    Hi Folks, I'm trying to insert a code into my file that performs a check for empty cells. The idea is that this macro should check Cells C3:C16 C19:C21 if any of them is empty and return an error if that's the case. This macro is assigned to a Button1 that displays text 'send request' I tried...
  20. F

    Dynamic Email with Pivot as body

    Hello, Im trying to make a VBA macro there will send a dynamic range based on the recipient. The recipient mail should be text, and there is no need for filtering. The data is presented like the picture below. Recipient AHJ needs an email with the following table: Recipient LFE: The...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back