email

  1. V

    Unable to return the range but only the word "true"

    Here below is the code to create a draft email from excel, the current region is correctly selected but it doesn't show in email body correctly, it only shows a word "True", please see attached 2 pics. Please help as I have googled for days and cannot sort out the problem, thank you so much...
  2. S

    Extract Last Name from Email Address

    There is a similar thread to this that was not answered. I would like to extract just the last name from an email address. My email naming format is First.Middle.last@email, or First.Last@email. Basically, I want the name between the @ and the ".". I found this formula online...
  3. F

    Send multiple PDFs in a folder to email addresses within a sheet from one of your email accounts in outlook

    Hi there, I need to send multiple PDFs from payment folders to email addresses within an excel file. I have a macro set up to pdf all the individual sheets into PDFs, and I have a sheet set up with all the email addresses in column A and the destination path in column B. In addition to this...
  4. R

    Display wrapped cell into outlook E-mail

    I can't find the answer anywhere. I have an automated E-mail template. In one of my cells there is text that is wrapped. I want it to display that way in my E-mail. This is my current code. Its cell C4 I want displayed properly. Sub Email1() ' Working in Office 2000-2016 Dim OutApp As...
  5. D

    VBA remove margin before bulletpoint/unordered list in email

    Hello! I am using VBA to send out emails containing a text body made up of bullet points with varying lengths (using the code from smozgur in this thread: Use VBA to enter a varying range of bullet points into body of email). Which creates a reference to the bullet list in the body text instead...
  6. H

    VBA Prompt to Send Email

    Hello all! We're currently using a spreadsheet to record and track training requests, and have a column (W) to note if a learning request form has been completed. I'd like to add a VBA to send an email if the cell in column W says "Yes" - Would also like a pop up box to prompt this ("Would you...
  7. T

    VBA Code to Copy Data from Cells to Email if Another Cell Equals Current Date

    Hi all, I'm new to VBA but am trying to automate a spreadsheet to automatically send out an email when a cell value equals "Complete". The flow I have in mind is that when a dropdown value is selected "Complete", then the data from another cell will be copied into an email body and...
  8. Jyggalag

    Merge cells of emails into one cell - possible?

    Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...
  9. Jyggalag

    Merge multiple email cells into one cell?

    Hi all, I currently have this setup: My VBA code is this ( credits to @RoryA :) ) Option Explicit Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...
  10. Jyggalag

    Object out of range VBA error?

    Hi all, I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error: and debug highlights this: Did I not do it correctly? What do I need to fix? Thank you all! BR. Jyggalag
  11. P

    Scrubbing Mass Email List

    Hi Excel Gurus, I've been working on this problem for days and tried numerous different formula to no avail, any help is appreciated! Problem: I have a list of 250,000 emails that needs to have all emails associated with lawyers removed (ex. info@lawofficexyz.com). Attempted Solutions: In...
  12. P

    Send an email when a cell says something specific

    Hey! This forum has been a huge help thus far, and I am coming here again with a potentially tough one. Here's what I would like to do: When a cell says the word "Active" or "Service Active" it sends my coworker an email letting them know to add it to quick books. Here is what it looks...
  13. A

    How to send email based on Filtered Row while using Macro

    Hi All , I need your expertise in how to send Email based on a table. I have a table that contain user name , email , cc , subject and location. I would like to filtered out location and expect the macro to loop in the filtered row instead of capturing all row when i pressed the "Send Email"...
  14. C

    Excel VBA for Outlook

    Hi All, I have a spreadsheet which works well but my leadership have asked to expand it's capabilities (If it's possible). Unfortunately I'm useless at VBA coding and had to seek help on the code I'm currently using. At the moment I have a text box which is transfered into the email body, but...
  15. M

    Multiple CopyRangeToJPG functions HELP!

    I have built a project to copy a range of cells and paste them as a picture into an Outlook email. The issue is that the Excel doc has 52 tables on one sheet representing each week, and I want to have a button on each table to copy that specific range and create the email. Sub...
  16. Jyggalag

    Save file as PDF in VBA (macro)?

    Hi all, I currently have the following setup: I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF. However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
  17. C

    Bulk Emails with multiple variations

    Hi All, I have an idea of what I would like the spreadsheet to do however I have ZERO experience with VBA or coding and I've relied heavily on formulas in the past. I've created an example spreadsheet to try to explain what I'm trying to achieve but basically, I'm looking for a spreadsheet...
  18. Jyggalag

    Change my email macro to email multiple recipients in different rows

    Hi all! I currently have this setup in Excel: And the code is this: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim...
  19. Jyggalag

    Email multiple emails at once with macro/VBA

    Hi all, I currently have the following setup: The macro will send out an email to the 1st contact and BCC with this VBA code: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t865934\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As...
  20. Jyggalag

    Make email macro send out separate emails

    Hi all, I currently have this setup in Excel: Sub send_email_complete() Dim outlookApp As Outlook.Application Dim SendEmailTo As Outlook.MailItem Dim source_file, to_emails, bcc_emails As String Dim i, j As Integer Set outlookApp = New Outlook.Application Set SendEmailTo =...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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 MrExcel.com.
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 "mrexcel.com".
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
Top