VBA code to send auto emails from Outlook App based conditions set in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2805082%22%20slang%3D%22en-US%22%3EVBA%20code%20to%20send%20auto%20emails%20from%20Outlook%20App%20based%20conditions%20set%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2805082%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20VBA%20code%20to%20automate%20a%20reminder%20sending%20emails.%20For%20Ex%2C%20I%20sent%205%20emails%20consisting%20of%20XYZ%20details%20%26amp%3B%20i%20got%20response%20for%202emails%20which%20I%20sent%20and%20rest%203%20didn't%20responded%20so%20I%20want%20to%20create%20a%20VBA%20so%20that%20a%20reminder%20should%20be%20sent%20to%20those%20recipients%20who%20have%20not%20responded%20yet.%3C%2FP%3E%3CP%3EI%20maintain%20a%20tracker%20in%20a%20spreadsheet%20which%20has%20column%20A%20to%20M%20%26amp%3B%20column%20M%20has%20the%20recipients%20email%20ID%20and%20column%20L%20has%20the%20status%20as%20%22%20Send%20Reminder%22%20for%20which%20rows%20I%20need%20to%20send%20the%20reminder.%3C%2FP%3E%3CP%3Ewhile%20sending%20this%20reminder%20i%20want%20all%20the%20details%20from%20column%20B%20to%20J%20should%20be%20there%20as%20HTML%20body%20of%20the%20email%20with%20with%20%22XYZ%22%20comment%20before%20those%20HTML%20body.%20It%20shouldn't%20be%20a%20separate%20email%20for%20each%20rows%2C%20For%20Ex%3A%20If%20rows%20number%202%20%26amp%3B%205%20has%20the%20same%26nbsp%3Brecipients%20then%20a%20single%20should%20be%20sent%20consisting%20of%20those%20rows%20as%20HTML%20Body%20in%20the%20mail.%3C%2FP%3E%3CP%3ECC%20will%20have%20the%20fixed%26nbsp%3Brecipients%20as%20%22XYZ%40yahoo.com%22%20%26amp%3B%20%22ABC%40gmail.com%22%3C%2FP%3E%3CP%3ESubject%20will%20be%20fix%20as%20%22MNO%22%3C%2FP%3E%3CP%3EIf%20each%20rows%20is%20having%20different%26nbsp%3Brecipients%20then%20a%20separate%20email%20should%20be%20sent%20to%20them.%3C%2FP%3E%3CP%3EI'll%20have%20such%201%20to%20300%20rows%20in%20my%20spreadsheet%20for%20which%20this%20VBA%20need%20to%20be%20designed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20my%20way%20to%20design%20this%20but%20getting%20fail%20in%20making%20it%20as%20single%20email%20if%26nbsp%3Brecipients%20are%20same%20in%20some%20of%20the%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20someone%20who%20can%20help%20me%20over%20here.%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I am looking for VBA code to automate a reminder sending emails. For Ex, I sent 5 emails consisting of XYZ details & i got response for 2emails which I sent and rest 3 didn't responded so I want to create a VBA so that a reminder should be sent to those recipients who have not responded yet.

I maintain a tracker in a spreadsheet which has column A to M & column M has the recipients email ID and column L has the status as " Send Reminder" for which rows I need to send the reminder.

while sending this reminder i want all the details from column B to J should be there as HTML body of the email with with "XYZ" comment before those HTML body. It shouldn't be a separate email for each rows, For Ex: If rows number 2 & 5 has the same recipients then a single should be sent consisting of those rows as HTML Body in the mail.

CC will have the fixed recipients as "XYZ@yahoo.com" & "ABC@gmail.com"

Subject will be fix as "MNO"

If each rows is having different recipients then a separate email should be sent to them.

I'll have such 1 to 300 rows in my spreadsheet for which this VBA need to be designed.

 

I tried my way to design this but getting fail in making it as single email if recipients are same in some of the rows.

 

Looking for someone who can help me over here.

0 Replies