Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

auto send mail if

0

Hello, i have this macro:

Sub Enviar_correo()
    ActiveSheet.Range("Tabla4").Select
    ActiveWorkbook.EnvelopeVisible = True
    With ActiveSheet.MailEnvelope
       .Item.To = "correo@gmail.com"
       .Item.Subject = "Asunto: Envío rango de Excel por email"
       .Introduction = "Ejemplo de rango adjunto con formato..."
       .Item.Send
    End With
End Sub

And I want it to be running continuously, and when O3 = <> "" send me the email. How can I build the VBA?

Thank you

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login