email

Not strictly Excel, but I guess you folks know VBA. At work, I receive steel test certificates by email, and want to automate saving them onto my PC into folders based on the subject of the email, it uses a rule in Outlook to identify the email, then this code to save the attachement(s). At...

Hi all, I have the below code which saves the current worksheet as a PDF file and then sends the worksheet out, but I would rather it send the PDF, can someone help? Thanks, Karl Dim OutApp As Object Dim OutMail As Object Dim saveLocation As String Set wb1 = ThisWorkbook saveLocation =...

Hi all, I have a macro that will send an email automatically, but I can't get it to include the CC. I am guessing I have to "get" the value in Worksheets rather than just set it :/ Any help greatly appreciated. Sub A2_Decline() Set Authoriser1 = Worksheets("Process").Range("B5") Set...

I'm trying to insert a table whose content are contained on a spreadsheet (Let's say within the range A1:D4 as an example) into an email. I've written the body out in HTMLBody format and have followed the instructions from this guide to insert the table: Convert Excel Range Into HTML Table...

Hi All, I'm trying to get a script that will send a pdf to a specified list of email addresses from within Excel 365. The main kicker is that the Mac version doesn't function the same as a PC version. I've broken this down into 2 pieces. 1) Attached the pdf : If I go to the menu item "Share"...

I have a sharepoint list where items are input from a form (List1) and another list with users and emails (List2). I want the flow to check whenever an item is created in List1 and look up in the List2 and get all the emails that are classified as Admin in the column Profile and send an email...

I really don't know how to state this one better. I'm creating a spreadsheet that will take a customer's email address and Generate an email to inform them who the contacts for their selected job area are. I designed a sample spreadsheet: And my goal is to produce the email so it has a link...

I'm trying to add an image into an email in vba. I've inserted the image into a sheet as I couldn't get the file location method to work. Here's my code for the relevant section in the email body: EmailBody = HelperSheet.Shapes.Range(Array("Picture 2")) It's highlighting the whole row and...

I need to use an if statement to add an attachment to an email if cell G5 contains specific text (e.g. "Specific Text"). I've tried using If Range("G5").Value = "Specific Text" Then .Attachment.Add "C:\Documents\MadeUpFileLocation\ImageName.JPG" End If but the debug is highlighting the...

Hi guys, i have threshold sheet and i want to excel send me an email about any material it will be out of stock so, i want a vba prompts to execute this issue to send me an email if there is a material is out of stock automatically. best regards

I'm currently trying to set up an automated email system. The system is supposed to go down a list of email addresses and email every customer. The code I have so far in vba is: Sub Email() Dim EmailSubject As String Dim SendTo As String Dim EmailBody As String Dim ccTo As String EmailSubject =...

Greetings to all, I am a beginer in VBA, looking for your help to use VBA to generate a daily email about daily production report from PDF file. Email containes a table highlighting production plan vs actual production and remarks column as such : Products Daily Actual production (from...

Hi all Learning VBA slowly on my own and I have managed to write a script for me to send multiple emails weekly, however there are 2 things I would like to do…. when referencing a cell in the email body which is a negative value, I would like that text to be red, and a positive value the text...

Hi all, I have the below code, currently I have hard coded the email to address but I have a list on a "Variables" tab, range J2:K10 (also below) with where the report should go. Rather than updating the code, I was wondering if I could lookup to this list and return the right to person...

Hi all, Hoping this is a simple fix. I have the below script that I found on another forum that runs as a rule in Outlook to save .pdf email attachments with a timestamp that come from my printer. That part all works fine. The problem I'm having is that it will save the file with the .pdf as...

Hello, I do found a VB formula in order to extract a set of email addresses from Excel to an Outlook email draft, so email drafting will be way easier especially if we maintain a lot of distribution lists for different email communications. My problem is I want to implement this to a...

Hi! I have a macro that fetches a file from an email in Outlook every day, and then runs a number of other vba codes on it. The macro runs great, but only gets the file from "today" and if there is multiple emails it only collects the oldest one. As a workaround, I sometimes have to email...

Trying to add all files specific types to an Email with a procedure at the moment it does a induvial email for each file type. Sub Send_Email(EmailTo As String, EmailCC As String, EmailBCC As String, EmailSubject As String, EmailBody As String, EmailAttachment As String) Dim EmailApp As...

Hi, I have been given a new task as I'm the most IT literate in the office. I've done a small bit of VERY basic VB coding/Macros. I've stumbled across a code here and wanted to know how I could edit it and implement it to work for my use case. I need to: Export a PDF to the same location...

I am using Office 365, and am storing Excel files in the shared OneDrive. I would like Excel to send automated emails, either based on a dynamic schedule (e.g. storing a list of dates in one of the sheets), or being triggered by some data in one of the sheets that gets updated dynamically based...