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