send email from excel

Hello and thanks for helping. I am very new to VBA. I have a spreadsheet that needs to be emailed to different reviewers at different intervals based on the text in the cell. For example, if column O = "Y" then send email to userA@outlook.com; if column P = "Y" then send to userB@outlook.com...

Hello everyone! I have a problem with a macro that I'm using to send emails automatically with a button ... I'm not an expert, so I am looking for your help ? (this drives me crazy ... and btw I speak spanish) The macro is the following: Sub Enviar_Correo2() ' ' Enviar_Correo2 ' Enviar por...

Hi Dear All, I found following code to send email from Excel using a specific account. But the thing is I am using two different accounts in Outlook and want to send some emails using the account that I specify in a cell in the excel sheet. Can anyone please can make this 1 in Set...

I'm using Excel 2016 to register guests in at a Trade Show. (I know it may not be the best option, but no budget for other software) The trick is, I'm trying to find a way to notify a sales rep when one of their VIP's arrive. SMS would be ideal, but understand email may be the best option...

The table below shows the expiration dates of employee certificates: <tbody> Name Email Cert 1 Cert 2 Adam adam@email.com 30/7/2016 30/8/2016 Henry henry@email.com 29/6/2016 13/7/2016 Karl karl@email.com 13/7/2016 14/9/2016 </tbody> I would like to run a macro that will then email all...

Hi all, I am new in VBA, I am trying to attached those files in a folder which their filename start with date format (eg : yyyymmdd_filename1.pdf, yyyymmdd_filename2...etc ), is it possible to attached the file with correct date? says when I run the marco today, it will attached the filename...

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

Dear guys, I have been trying to create a macro for a while that can save and send as XPS but without any luck. I'm using relative references and this is the results: ActiveWorkbook.ExportAsFixedFormat Type:=xlTypeXPS, Filename:= _ "C:\Users\itshewe\To do.xps"...

I'm currently working on a Ron deBruin VBA email code and wonder if there is a way to protect the copied workbook being sent off?? This is the code that I'm working with, and the copied workbook being sent off is not protected - hence the various formulas is accessible to the person receiving...

Have looked at all VBA code I can find, and each one fails when I hit F5 to send. Have spreadsheet of 300+ rows for 300+ individuals per row. Want to send email to email address in row and include their information in Column C-J in the body of the email. Using Outlook 2010. This is my 1st...