Automatic emails

Copper Contributor

Hi all,  How do I create an automatic email to myself , when the word 'overdue' appears?



2 Replies

Hi @Jella510,


you said:


@Jella510 wrote:

when the word 'overdue' appears?


Are we talking about an Subject of an E-Mail or what? 


If so, I would recommend to automaticly move it to a folder created by youself named "alarm name overdue" or however.


Otherwise provide more informations please.


Best regards,



"First, No system is safe. Second, Aim for the impossible. Third no Backup, no Mercy" - Schnittlauch


My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved. :)



@Schnittlauch I mean in the body of the worksheet. 


This is what I have written so far but i know nothing really about coding.  Do I select the full sheet to link the coding, or what should I do? 

Sub Email_from_Excel_Basic()

Dim emailApplication As Object

Dim emailItem As Object


Set emailApplication = CreatObject (“Outlook.Application”)

Set emailItem = emailApplication.CreateItem (0)


emailItem. To =

emailItem.Subject = “Overdue Documents.”

emailitem.Body = “Please check the for overdue items.”

amailItem.Attachments.Add ActiveWorkbook.Overdue