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...
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 =...
Hi all,
I have the following code for HTMLBody:
SendEmailTo.HTMLBody = "Dear all,<br/>" & "<BR>" & _
"bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text ""bunch of insignificant text"" bunch of...
Hi all,
I currently have the following VBA code attached to a macro that sends out an email and attaches a word file to it when I click it and sends this out to a list of emails (and also BCC's a list of emails):
Now I want to edit this file so I can target a list of emails in the emails...
Hello, I have not posted here before but if someone could help me resolve this problem I would really appreciate it, as the other posts I have referenced have not been successful for me. I will lay out what my VBA form currently does.
-User submits info into a request form...
-This information...
Hi all, please help
I have the below code that creates a an email with subject and email address, I do not need/want a signature so its all good, but i cant get it to Copy and paste a set range from the Active Sheet in Excel. it has to be as text, not a picture as it needs to be read in by...
Dear all,
I currently have this code:
However, it seems that me highlighting it with bold and underlining it through the use of "<b><u>" (which has worked for me before), does not work anymore.
Does anybody have any idea how I can either fix or change my code?
It would be greatly...
Hi All,
I am having an issue in Excel. My current setup looks like this:
However, if I put range("O2") it works fine and it sends out the email to my email address. But once I try to increase the range and make it send out to multiple emails, it comes with the following error (highlighting...
Hi all,
I am facing an issue with an email macro. Specifically, I used the one from this website:
https://www.wallstreetmojo.com/vba-send-email-from-excel/
However, when I run the code, it says the following:
Can somebody please help me fix this issue?
Thank you!
Kind regards,
Jyggalag
Dear all,
(Please note that I am using the Outlook program in Windows).
I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format):
I was wondering if it would be possible to...
body text
conditional formatting
email
excel
formula
help
insert
macro
mail
pdf
shape
subject
subject and body in vba
subject and message body
vba
vlookup
Hi all,
I have this VBA code to write an email body text:
eBody = "Dear person," & "<BR><BR>"
eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...
Dear All,
I currently have a setup that looks approximately like this:
I would like to know if there is some record macro / VBA solution to separate the emails so email 1 goes into Column K, email 2 into column O and email 3 into column S?
I tried to record a macro and use "text to...
Dear all,
I am currently working on a spreadsheet that looks like this, albeit the real one is much larger:
I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...
Hi everyone, Happy New Year!
I've got the following code below however I can't seem to code it to copy and paste the tables / formats (as per header), only words get exported onto email outlook.
Can someone help me to tweek it please? Super appreciate it!
Code in question:
Private Sub...
Hello,
How would I be able to send an email containing who the change is for, and what the change was.
For example, if I am changing the date from 12/6/21 to 12/7/21 for Patient X, how would I include that information in the email automatically?
Your help is greatly appreciated!
Hello,
I have looked through a few of the other threads for this but I have a command button that i want to display an email once the button is clicked. I kep getting an error that says variable not defined. Also in the second image, the two regions of vba keep getting highighted. Overall i am...
I am having issues with the below VBA code that's used to send out invoices via Excel.
It does not skip the cells that are blank in the "attachment" columns of the worksheet, instead,
it gives me the "File does not exist error" for the first blank and stops the loop completely.
Can someone...
Hi,
I am trying to create a VBA macro that will generate outlook emails based on unique information in the cells. Every email is different and is going to different people. I need it to be able to generate numerous emails at a time without having to rerun the script. My file is set up so that...
I created a button that takes selected table, copies and pastes it into an email between a note & my HTML signature.
Here is the code that was working yesterday but isn't today. ????
Sub Mail_Outlook_With_Signature_Html_1()
Dim outlook As Object
Dim newEmail As Object
Dim xInspect As...
Hey all,
I hope I can get some help here.
I have looked around for a solution and have gotten close but not there, it is a tricky one.
This is the closest I have gotten: Send email based on date
I have an excel spreadsheet stored on onedrive
It has 4 sheets with employee details, 3 sheets...
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.