send e-mail;conditions

Hi, I have a spreadsheet which I will require to attach and send PDF files. I need to create some functionality that a command button (or anything functional) will review a value of a particular cell and will attach the corresponding PDF files to an outgoing email. For example, if a customer...

GoodDay....I need some help...I have the below code which works for the most part. I use this code for about 30 different sheets. So, if the someone's email changes or someone new comes in I have to go in and change it individually. This becomes daunting after a while. What I trying to...

Thanks for helping me out...I need help. I am trying to send an email if there is an X in a specific column. So send an email to all Chair committee who have an "X" in the EMP column. And be able to switch it up for the other Units. The Email attachment would be another sheet in the...

Hi I'm looking for some help with a macro that my colleague has created. Rather than sending the email from my default outlook profile i'd like the email to be sentonbehalf of another mailbox. VBA code below needs to be amended so that it is sending from the specified mailbox rather than my...

Sub email() Dim myOutlook As Object Dim myMailItem As Object Dim FName As String Set otlApp = CreateObject("Outlook.Application") Set otlNewMail = otlApp.CreateItem(olMailItem) FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name With otlNewMail .To = "xxx@www.com;xxx1@www.com" .CC = ""...