email

Hi, I have a substantial (and dynamic) list of names that I'm needing to transform into email addresses. For names like Bob Smith, and even those with hyphens (Sarah-Jane Brown), it's no issue: =LOWER(CONCAT(SUBSTITUTE(SUBSTITUTE(C16342," ","."),"-",""),"@abc.com")) End result =...

Hi there, I'm looking for some help with drafting an email to Outlook from excel. The Image below shows a typical sheet information. Each column has different data which is needed in one of the email fields. I would like to be able to press a button and have a draft email appear to the...

Good afternoon, Hoping to get some help on this one. I have a file that has a list of jobs, my boss will then put a % to each one of these jobs in E starting from E6. Once that percentage hits 100%, I would like it to send an email to our billing person, that says something along the...

Hi, I keep getting Compile Syntax Error when trying to run the following Macro. Please Help! Sub Give_Feedback() Dim EmailApp As Object Dim EmailItem3 As Object Dim xStrBody As String xStrBody = "Good Morning/Afternoon" & "<br>" & "<br>" _ & "My feedback is about:" & "<br>" & "<br>" & "Kind...

Hi i hope you can help me since i have been trying this for weeks. I need to find a way for excel to send an automatic email to a specific adress IF any value from a column changes its value to a specific text. The value in question is text, so for example: - If C5 changes to "Done" then an...

Trying to exclude sender when recipients hit Reply All, in Excel generated Outlook email. I have: EmailItem.To = "email2@email.com" EmailItem.CC = "email3@email.com" I think I can do: EmailItem.ReplyRecipients.Add "email2@email.com; email3@email.com" But how do I do that without...

Hi, I am trying to create an email in outlook using VBA. In the email i want to include text and a formatted table from the spreadhseet. In addition i want to add an image/shape to the BOTTOM of the email, but I can't seem to get it to land there. Here is the code i have managed to put...

Hi, I am totally new to VBA but have been trying to piece together code to send an email to specific people based on non-numerical cell value, I have been all over the map, emails sending now they aren’t, but they were sending to everyone, not just the intended recipient, the attachment only...

Hi, I would like to send multiple worksheets based on a control sheet. I have put together an example (attached)..... ideally would like the vba to loop through the various Rows till it reaches the end of the table. Thanks JSF

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

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

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

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

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

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

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

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

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

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

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