Automatically send multiple emails based on calculated cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-2248578%22%20slang%3D%22en-US%22%3EAutomatically%20send%20multiple%20emails%20based%20on%20calculated%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2248578%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spread%20sheet%20that%20counts%20down%20automatically%20the%20days%20left%20on%20clients%20service%20agreements.%20I%20would%20like%20to%20send%20automated%20email%2Femails%20every%207%20days%20in%20the%20pink%20and%20yellow%20ranges.%20Each%20email%20would%20detail%20how%26nbsp%3B%20many%20days%20are%20remaining.%20In%20the%20Red%20and%20the%20Black%2C%20the%20same%20but%20sending%20every%202%20days.%20I%20am%20using%20Windows%2010%20with%20Office%20365.%20I%20have%20found%20a%20site%20by%20a%20person%20called%20De%20Bruin%20which%20works%20on%20his%20spreadsheet%20but%20won't%20work%20if%20I%20copy%20and%20paste%20the%20code%20to%20my%20workbook.%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3EAs%20always%20my%20thanks%20and%20gratitude%20in%20advance%20to%20the%20amazing%20excel%20community...%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2248578%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2248616%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20send%20multiple%20emails%20based%20on%20calculated%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2248616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421224%22%20target%3D%22_blank%22%3E%40Cambosity100%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CH2%20id%3D%22toc-hId--496367472%22%20id%3D%22toc-hId--496393319%22%3EMail%20from%20Excel%20and%20make%2Fmail%20PDF%20files%20(Windows)%3C%2FH2%3E%3CH3%20id%3D%22toc-hId-194194002%22%20id%3D%22toc-hId-194168155%22%3EVBA%20mail%20macro%20examples%3C%2FH3%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs1%2Foutlook%2Fmail.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMail%20from%20Excel%20with%20Microsoft%20Outlook%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs1%2Fdiv%2Fmail.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMail%20from%20Excel%20with%20Outlook%2C%20Outlook%20Express%2C%20Windows%20Mail%2C%20Windows%20Live%20Mail%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs5%2Fpdf.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECreate%20and%20Mail%20PDF%20files%20with%20Excel%202007%20and%20higher%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs1%2Fcdo.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMail%20from%20Excel%20with%20CDO%20(no%20mail%20program%20used)%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.rondebruin.nl%2Fwin%2Fs1%2Fnotes%2Fnotes.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMail%20from%20Excel%20with%20Lotus%20Notes%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20find%20there%20many%20Examples%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have a spread sheet that counts down automatically the days left on clients service agreements. I would like to send automated email/emails every 7 days in the pink and yellow ranges. Each email would detail how  many days are remaining. In the Red and the Black, the same but sending every 2 days. I am using Windows 10 with Office 365. I have found a site by a person called De Bruin which works on his spreadsheet but won't work if I copy and paste the code to my workbook.

Any ideas?

As always my thanks and gratitude in advance to the amazing excel community...

3 Replies

@Cambosity100 

Mail from Excel and make/mail PDF files (Windows)

VBA mail macro examples

Mail from Excel with Microsoft Outlook

Mail from Excel with Outlook, Outlook Express, Windows Mail, Windows Live Mail

Create and Mail PDF files with Excel 2007 and higher

Mail from Excel with CDO (no mail program used)

Mail from Excel with Lotus Notes

 

You find there many Examples

 

Hope I was able to help you with this info.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Thank you for your reply Nikolino. Yes I have already visited Ron de Bruin. But I cannot get the copy/pasted code to work in another workbook. I will post screen shots. Also unlike other similar code I have explored I cannot find how to change the text of the email or the frequency of the resending.

@Cambosity100 

I have looked at and tried the Ron de Bruin code but it wont allow me to copy and paste to another work book. Also I cannot find where to adjust text for the email or anything else except the final calculated number. Have spent hours on it to no avail. It comes up with the following when pasted into another workbook. Please find attached his workbook and snippets of the error plus my experiment worksheet (that doesn't work...) that produces the error with the copy and pasted VBA code. 

Help !!