Automatic emails

%3CLINGO-SUB%20id%3D%22lingo-sub-2360689%22%20slang%3D%22en-US%22%3EAutomatic%20emails%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CU%3EHi%20all%2C%26nbsp%3B%20How%20do%20I%20create%20an%20automatic%20email%20to%20myself%20%2C%20when%20the%20word%20'overdue'%20appears%3F%3C%2FU%3E%3C%2FP%3E%3CP%3E%3CU%3EThanks%26nbsp%3B%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360750%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20emails%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360750%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047782%22%20target%3D%22_blank%22%3E%40Jella510%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20said%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047782%22%20target%3D%22_blank%22%3E%40Jella510%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3E%3CU%3Ewhen%20the%20word%20'overdue'%20appears%3F%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EAre%20we%20talking%20about%20an%20Subject%20of%20an%20E-Mail%20or%20what%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%2C%20I%20would%20recommend%20to%20automaticly%20move%20it%20to%20a%20folder%20created%20by%20youself%20named%20%22alarm%20name%20overdue%22%20or%20however.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%20provide%20more%20informations%20please.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ESchnittlauch%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360814%22%20slang%3D%22en-US%22%3ERe%3A%20Automatic%20emails%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045823%22%20target%3D%22_blank%22%3E%40Schnittlauch%3C%2FA%3E%26nbsp%3BI%20mean%20in%20the%20body%20of%20the%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Jella510_0-1621256322495.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281056i4C2BEBB49BF12EEA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Jella510_0-1621256322495.png%22%20alt%3D%22Jella510_0-1621256322495.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20what%20I%20have%20written%20so%20far%20but%20i%20know%20nothing%20really%20about%20coding.%26nbsp%3B%20Do%20I%20select%20the%20full%20sheet%20to%20link%20the%20coding%2C%20or%20what%20should%20I%20do%3F%26nbsp%3B%3C%2FP%3E%3CP%3ESub%20Email_from_Excel_Basic()%3C%2FP%3E%3CP%3EDim%20emailApplication%20As%20Object%3C%2FP%3E%3CP%3EDim%20emailItem%20As%20Object%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESet%20emailApplication%20%3D%20CreatObject%20(%E2%80%9COutlook.Application%E2%80%9D)%3C%2FP%3E%3CP%3ESet%20emailItem%20%3D%20emailApplication.CreateItem%20(0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EemailItem.%20To%20%3D%20%3CA%20href%3D%22mailto%3Ajella.hyde%40nacwl.com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ejella.hyde%40nacwl.com%3C%2FA%3E%3C%2FP%3E%3CP%3EemailItem.Subject%20%3D%20%E2%80%9COverdue%20Documents.%E2%80%9D%3C%2FP%3E%3CP%3Eemailitem.Body%20%3D%20%E2%80%9CPlease%20check%20the%20for%20overdue%20items.%E2%80%9D%3C%2FP%3E%3CP%3EamailItem.Attachments.Add%20ActiveWorkbook.Overdue%3C%2FP%3E%3CP%3EemailItem.Send%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

Thanks 

 

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,

Schnittlauch

 

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

Jella510_0-1621256322495.png

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 = jella.hyde@nacwl.com

emailItem.Subject = “Overdue Documents.”

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

amailItem.Attachments.Add ActiveWorkbook.Overdue

emailItem.Send