Using Dates with Excel VBA to Automate Email Reminders

[@paulsthingsauto3225]

9 years later and this is still helpful, thank you sir!

[@luisrangel3458]

6 years later and people are still using your code, thank you!

[@Exceltrainingvideos]

Great to hear! Please share the VBA tutorials with your friends also on social media.

[@SGH-rt6ci]

I put it like this : I have about 300 contracts with different dates for review or renewal. I have applied Your solution and no more headaches, I just wait for an email -)))) . Great stuff ! Mr Dinesh Kumar Takyar !!

[@Exceltrainingvideos]

Great 👍 Please share with your friends.

[@MuhammadSafwan-lr5ou]

Dear sir, I am new to VBA, thanks for the sharing. Please continue helping

[@Exceltrainingvideos]

Thank you, I will. Please share with your buddies also.

[@EmekaOgbu-lz6bk]

Thank you so much sir. God bless you and your family and generations!!

[@wendy-mu4tw]

Thank you! I have been finding a good VBA class for a while. This is the best one!

[@Exceltrainingvideos]

Glad it was helpful! Please share the Excel tutorials with your friends too.

[@PunnyGuy]

Just loved it.... Thanks Dinesh ❣️

[@OkayChannel-q7s]

Very useful. Thank you so much for your creating this video.

[@Exceltrainingvideos]

Glad it was helpful! Please share this channel with your friends too in case they need Excel VBA solutions.

[@jjcutemy]

hir sir, can i use this method for sending sms to phone

[@balajiparthasarathy3168]

Thanks so much again. This is fixed and the macro is working fine.I went to VB - Tools - References - and checked in the Microsoft Outlook 14.0 Object Library

[@Exceltrainingvideos]

+Balaji Parthasarathy Great!

[@victorvallim9538]

Amazing explanation, thank you!

[@Exceltrainingvideos]

Glad you enjoyed it!

[@jslaybaugh902]

Thank you for this explanation. 1. I have used a version of this code but would like to know how to make the emails stop if the reminder column is already formatted red and has the text "yes" in it. Every time it opens it displays all the emails again. 2. how can i put multiple email in the "to line" in the email that it sends.

[@Exceltrainingvideos]

1. Use an IF condition 2.You can use a loop as shown in this link: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@ParthPatel-md4be]

Thnx sir... Wonderful lesson....

[@blueroselacandula]

Thank you so much for creating this video.. it helps me a lot... really.. super.. it works for me ..

[@vallr-humans9121]

Thanks Sir for this useful video. I tried the same and it works fine too. But I have some questions. 1) Does the Excel VBA script run automatically? 2) Will the automated emails be sent even if I don't open the excel file? 3) It also asks for outlook email id password each time it sends email. Please help.

[@gargimitra2010]

Same doubt from me also....

[@mohsinjessa8951]

Dinesh excellent videos - presentation, clarity, quality and content. I was struggling with a problem - and now I should be able to achieve it using vba. I had two sheets - in one I'd keep date in A col and the closing NAV of a mutual fund in B. The latest value would always be in range: A2,B2. In another sheet - I'd calculate my current portfolio balance using the latest value. I tried using a formula that linked the NAV cell (using relative and direct address of the cells) but every time I added a row of the latest NAV the cells with older values would be pushed down to A3:B3 and the formula referencing that range would be updated as well. Using VBA I should be able to solve it. Thanks.

[@sankalppotdar9950]

great tutorial, very useful. Thank you.

[@shallontukamushaba4980]

Thank you so much. this actually got me promoted

[@Exceltrainingvideos]

Wow! Please share these Excel tutorials with your friends too.

[@andreaduignan4020]

Hi there. These have been incredibly useful and I have let people know they are available! One thing that I am probably doing wrong isit works perfectly up until the formatting part and getting the date but the send email part will not work for me. It states the first line of the code is incorrect? Am I doing something wrong as evidently it works well for everyone else first line of code is marked in yellow. Many thanks

[@andreaduignan4020]

Just to let you know I solved it! It was my set up in Tools. This has been invaluable to me!! Many many thanks!!!!!!

[@karlapalemsurya9052]

Hii sir, i'm getting "object variable or with block variable not set", can you please suggest me the correction which I have to make in order to compile the macros, thanku

[@juliestelzner]

Awesome presentations.

[@MuraliPariyarakaran]

Hello Mr. Dinesh. I tried the code, but I'm getting an error 'Type Mismatch' for mydate1 = Cells(x, 4).Value. Could you pls advise what is wrong in the code. Thank you.

[@Exceltrainingvideos]

+Murali Pariyarakaran This link will help: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@bheemeshmanikonda8181]

hello sir, i follow your videos regularly.regarding automate email remainders , i cannot define variables like Outllook.application in this code . i cannot find them as auto drop down while defining variables. Could you please me out if i need to do any outlook confirmations settings before this code?

[@Exceltrainingvideos]

These links will help: www.exceltrainingvideos.com/how-to-use-automation-to-send-ms-outlook-mail-using-excel-vba/ www.exceltrainingvideos.com/tag/automate-email-via-outlook-using-excel-vba/ Or search www.exceltrainingvideos.com

[@balajiparthasarathy3168]

Thanks so much for the video. When I tried, "Dim myApp as Outlook", I was not getting "Outlook" in the drop down. Still I wrote the code and when I tried to run, I have got a compile error. "User-defined type not defined" Appreciate your advise in this regard.

[@rinkideep]

even i am getting the same error, have you got the answer, please share if yes

[@sankalppotdar9950]

@@rinkideep hope this helps- While in the VB Editor, select Tools | References from the menu bar. Scroll through the list of available references until you find the one for Microsoft Outlook x.0 Object Library (where x will depend on what version of Outlook you have installed.) Check it, then close the dialog.

[@413sneha]

Hi Dinesh,This is really very helpful, I have one more question? Do we have a way to keep the excel in sharepoint location and that triggers an email or I need to have this in the local desktop only?

[@schauhan2007]

How this code work automatically in the background? Do we need to run it manually?

[@Exceltrainingvideos]

You can try using a VBScript as shown in these VBA tutorials: www.exceltrainingvideos.com/tag/run-macro-with-a-a-visual-basic-script/ www.exceltrainingvideos.com/tag/launch-vb-script-using-task-scheduler/

[@rickbissoondyal2358]

Hello sir i found your videos very helpful, however i am using excel 2016 and having some trouble .... i am getting a "compile error: User -defined type not define. Sub datesexcelvba() Subject = " Action Alert” .Body = “This is a reminder for you to Pull samples in three days ” & vbCrLf & cells (x,3).value vbCrLf & “Kindly ignore if pulled” vbCrLf & “Info.”

[@Exceltrainingvideos]

Check your code again.

[@rickbissoondyal2358]

Yes i got it working thank you. A reference was not enabled in tools. Also can i add a code to this for it to trigger outlook to follow up in 15 days or so. Again thank you.

[@naveenpareekk]

Hi Dinesh, wanted to know this will send the reminder automatically? or do we have to schedule this?

[@swapnilpanchal1578]

hi i learned lot from this video, can you please show me a macro which reminds me break time reminder, i.e- if i want to take breaks in office for three fix times every day i want to learn macro which popup's three times to take break reminder

[@jraricheta3301]

Hello, This script continues to send an email after the due date has passed. Is there any way to only send an email if the date is in between 0 and 7 days ahead? Thank you

[@Exceltrainingvideos]

You can use specific dates.

[@mechanicmike311]

If I have a first and last name in the same row, is there a way to include this name in the body of the email? Thank u for the videos they have been very useful.

[@Exceltrainingvideos]

mechanicmike311 Yes. Just use the cell addresses.

[@williamharrison1885]

i entered the code in the example but I get the following error for line "mydate1=cells(x,6).value". The error I get is "runtime error 13, type missmatch". How do I go about solving this?

[@faisalyousaf6802]

Sir, very useful video. What if there is a column having job order numbers and we want to include that particular job order number in subject line as well. Please advise

[@Exceltrainingvideos]

Use the range or cells property to use the value.

[@anandchaudhari834]

Dear sir..I love your teaching way...need some help....I have one Excel workbook..in which I have put ..kill function..macro...to delete the file on mention date..but what I want is that ..2 or 3 days before the mentioned date..the VBA msg will started to show when the person open the workbook..for remainder or warning kind of thing.......

[@Exceltrainingvideos]

Use an IF condition like so: IF mydate>-somedate and mydate

[@abiodunodeleye7534]

Thank you for the video. Really Helpful. However, is it possible to reference the content of a cell in the body of the email? (.Body = cell(x, 5) or something).

[@Exceltrainingvideos]

Yes. Have a look at this link: www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/

[@eflexi88]

Hi Dinesh thank you very much for the tutorial. if i want add one more day difference. what is the code? i mean 3day difference and onday.

[@Exceltrainingvideos]

Visit www.exceltrainingvideos.com There is a revised video on the subject which will help.

[@edspressomartini]

Hi Dinesh, great guide. I run a sheet which contains a number of suppliers we use, and the date their agreement expires with us. I want to set a reminder to happen for each supplier, that when there's 3 months left till the agreement expires, myself and my manager get a notification listing the company name, and a message after that name to say the agreement has 3 months till expiry. The only problem is, I want this to happen without needing to open up the sheet and run a macro, just want it to happen behind the scenes... is this possible? let me know if it is

[@salemkraidi3530]

Hello Sir, thanks for this thorough explanation, my code comes with message "Compile Error" "User-defined type not defined" and highlighted this syntax (myApp As Outlook.Application). is there anything I can do to fix this one, bare in mind when I was writing this variable it wasnt automatically filling like your one? please help if you can. thanks a lot

[@Exceltrainingvideos]

Did you activate the relevant libraries from Tools -> References in the Visual basic Editor. Example: Microsoft Outlook Library. This tutorial will guide: www.exceltrainingvideos.com/get-data-from-outlook-address-book-automatically/

[@salemkraidi3530]

@@Exceltrainingvideos omg, you are legend Sir, thanks a lot. Very very helpful.

[@LukeFigliozzi]

Hello Sir, I want to be able to only send a singular email to myself once the loop meets my condition of 20 days until the event is. How can I end the loop once this condition is met?

[@kellydebruyn9501]

Dear Dr. Takyar, I need to alert 2 employees when they are behind on a project. 1. the project sponsor and 2. the account clerk; the project sponsor will change but the account clerk will remain constant. I must automatically generate email reminders when the project is 30, 60 and 90 days behind. Can you please help me? Thank you, Kelly

[@rashmibalpande8834]

Hello Dinesh Kumar Sir,your video is very good,but I hav issue with second line,because I m using lotus notes.i add reference but still not cmg.Dim MyApp As lotus. but after that when I press "." application not cmg

[@JapanTalker]

Sorry. Just a quick question. I see that outlook has been opened with the message and all. But was the actual email sent? If so, wouldn't outlook close the email editing window? I'm looking to implement this to something I'm working on and wish to see if the contents of this tutorial is exactly what I need to know.

[@Exceltrainingvideos]

This link with with a downloadable sample file will help: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@juliuspilybas3727]

Hello, i write reminder code by your exemple, but it doesn't work correct i guess, because it don't send me reminder automaticaly. In macros i run programe it's work fine, but when i close it and the reminders day come, i don't get no message(email). Could you help me with this problem?

[@vijaykulkarni7724]

Hi Sir Thanks for this great video. I also want to know that did you already prepared any video on reply to bulk emails with original arrangements. Please share me the link or else can you help me get the Code to prepare the same

[@Exceltrainingvideos]

This VBA tutorial will guide: www.exceltrainingvideos.com/tag/auto-acknowledge-receipt-of-mail-with-a-unique-tracking-number/

[@vijaykulkarni7724]

@@Exceltrainingvideos Hi Sir, Thanks for sharing such valuable video. However I have query. I already have a macro which is displaying msg but it's not getting send can you help me in this

[@ghulamrasool726]

Sir can u please share the VBA code again the link is not working

[@Exceltrainingvideos]

This Excel VBA tutorial will guide: www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/ It's a good idea to do such searches on your own. It is more satisfying and results in confidence building!

[@hemanthsharma62]

Hi sir, Whenever the reminder is Yes,Email body should include the name.Can you suggest me the code.I'm entirely new for vba.Thank you in advance.

[@srivatsagrandhi]

Hi sir, thanks a lot, the video is very helpful.. Do i need to run the macro everyday for reminders? Or if i run it for once i will be notified whenever the due date is nearby?

[@Exceltrainingvideos]

You can create a Vb Script to further automate the process to run at specific times. If you don't wish to code, you can use the task scheduler.

[@hmtexpert5137]

Brother can any tutorial to get such type alert for such type due date on excel file as notification bar until see or open the file as like facebook messenger / text message on mobile .

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/how-to-perform-tasks-in-excel-at-specific-time/

[@bharathbharath2362]

HI, Please tell me to run the macros without opening of excel file on schedule dates. Ex: I need to send one report through outlook on every friday. I created autocreation of Report. But this report auto send to my manager without opening of file. Awaits for your reply.

[@partners3511]

Have you got solution???.. If yes.. Please share with me.

[@SowdharyaSowndharya-dj2iy]

No i didn’t. But i have an idea. Use vbs script to run this macro without opening file. Put that vbs file in startup folder on windows. So that it auto open and execute, when ever u login to windows.

[@Smehta182]

When i run VBA in the same program as guided noting happens in excel Sheet only the cells 9 & 10 appears . tell me how to execute further

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@mariahughes1047]

Sir, this is most helpful. I am getting an error. It says " The following features cannot be saved in macro-free workbooks" •VB project. How do I resolve this problem? Respectfully, Maria

[@Exceltrainingvideos]

Save your file as a macro-enabled file. The standard file in Excel has the name abc.xlsx. The macro-enabled file is abc.xlsm.

[@mariahughes1047]

@@Exceltrainingvideos Sir, thank you! My employer uses Gmail for communication. How do I make this work for gmail? I keep getting an error. Thank you

[@alwllms1]

so can you share the code for automating the email on specific dates + different times of day on the same date?

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/tag/how-to-send-email-through-outlook-at-specific-time-using-vba/

[@drs10301]

Hi Sir, I want to know how to copy range from excel and paste as image format(bitmap) in outlook body of email using VBA. Please help me

[@donalfullerton4950]

Hi Dinesh, I have a compilation error, invalid use of property on '.To' and the sub is highlighted? I assume this is because I don't have a reference library imported. Could you please advise as to what libraries I need to tick from references? Many thanks in advance.

[@TheSardOz]

How can I add a value at every end of month to a table.. ? Let’s say I have a few subscription and I want keep track of the costs

[@Exceltrainingvideos]

These links will guide: www.exceltrainingvideos.com/tag/automate-multiple-rows-insertion/ www.exceltrainingvideos.com/get-data-from-userform-into-table/

[@auntmarykk]

How do you set Excel to send you an email reminder with Outlook when, instead of a due date, the value of the cell becomes greater than a certain value?

[@SIRJITechnical]

how to copy excel range and paste to outlook body with full format please send me vba code of that

[@aliawead7071]

Dear sir this great work and my issue I not have outlook account ,so can do this notification from gmail.

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/send-email-using-gmail-with-excel-vba/

[@bala6238]

sorry to trouble you as per your instruction first part is working fine, problem is second part merge with outlook, first and second line giving error, please help me.

[@Tom-fi8lr]

Hi there, what code would I add to use the name of the person we are sending email to as the subject?

[@amitkalra8774]

Question - my code is working fine but problem is with if condition. During debug its not reading the if condition. If I commented on the condition, it's working fine. Please suggest.

[@rinkideep]

Hi Amit, i too facing the same issue, it is only considering Lessthen formula, and when i am simply writing equals-to formula, it is not working, neither the result of Lessthen is commend correct, program is considering all the values, even if it is more than 3 days

[@karlapalemsurya9052]

hii sir, can we add specific credit card number which is going to expire in the subject of the mail which we are sending??

[@audiencemudenda2782]

Hello Sir, kindly help me with the vba code that looks at the first date and the expiry date of a product were if the product is almost expiring it sends a mail notification. Kind Regards, Audience Mudenda

[@aamirmomin669]

Will this automatically send a reminder without excel program being open on the computer?

[@Exceltrainingvideos]

Can you go for a jog without waking up? Also note, the computer cannot dream!

[@omprakashthakur4515]

Hello sir we can take more than one email id in a cell and send email.

[@Exceltrainingvideos]

kzbin.info/www/bejne/e4iXdHh9e7-ZjLc

[@amanbeersingh4261]

hello sir, i used this vba code to send notifications for inventory items that are exiring in 60 days but i also want to send row details in email body can you please help me in this

[@Exceltrainingvideos]

This link will guide:www.exceltrainingvideos.com/tag/how-to-send-email-through-outlook-at-specific-time-using-vba/

[@amanbeersingh4261]

@@Exceltrainingvideos this one is good but it only send selected cell. is there any way it automatically changes according to the date that is selected

[@edisonareis]

Dinesh Great video ! Just one question. How can we do the same routine for several columns ? For example I to track expiry dates for several courses (each training subject / column) by employees (Rows) so is there a way for the VB look all (or an given number of columns) on the spreadsheet ?

[@Exceltrainingvideos]

Loop.

[@kalyanireddy7906]

Hello sir,How to send the email before 10 days ,15 days and 30 days of the due date ?

[@alnaseri3622]

I have question, there is anyway tovsend a notification email while the Excel file closed??

[@jordonwong959]

I wish to added more parameters such as product, Maker, due date. one month before due date the email should automatic send to the email.

[@Exceltrainingvideos]

+Jordon Wong That shouldn't be a problem.

[@Dr.Shreekant_Naik]

Hi Sir, is it possible to add Follow up flags in Excel from outlook for 'Mark Complete' or any other colored flags?

[@Exceltrainingvideos]

Yes, you can.

[@amitkumar02]

Sir, I'm trying same code (till 11:20 - not included email part) in my system, but when I hit Run - nothing happens in my Sheet1. I'm using MS Office 365 ProPlus. Any help would be appreciated.

[@Exceltrainingvideos]

This link with a sample file for download will help: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@alnagreen]

I entered the data just as you have on the email. I am not getting the red object of the reminder to show up. I assumed that it was based on the fact that the dates are from 2014 and its using todays date but I am still not getting the reminder to show up. Any ideas on why that is?

[@Exceltrainingvideos]

Alicia Greenberg If you are working in 2015 how can you write the same dates?

[@alnagreen]

Dinesh Kumar Takyar I tried both ways with todays dates and the ones on the file. I understand that the code is written for "today date" but even after I changed to current dates I wasn't getting the reminder columns to work.

[@Exceltrainingvideos]

Alicia Greenberg You can download the original Excel file here and try it out: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@IvyPlans]

Hi Sir, How would you add code for a personalized greeting in the email body, a personalized subject and personalized email reference number, for example I have added a column for all three but I am not sure how to insert the code. Kindly advise.

[@IvyPlans]

Hi Sir, I was able to find the answer to my question and have implemented this code at work. I have 2 questions 1-Is there a way to add an if then or else statement that allows you to clear the reminder column when days are not equal to 3. 2-Is there a way to add HTML, so that you body equals a cell you can style the email with preferred attributes. Thank you the original code worked perfectly!!!

[@hillba11]

Sir, The code works great if I have dates in all the rows, but there are a few that will have "N/A" written in them. Is there any way to skip those rows that have "N/A" written in the cell? I keep receiving errors and I have tried several ways to fix it. I know it is probably something simple, but I cannot figure it out.

[@Exceltrainingvideos]

Using an IF condition you can set N/A to blank.

[@Exceltrainingvideos]

Cells.SpecialCells(xlCellTypeFormulas, xlErrors).Clear

[@Ivy-qq7iy]

Hi Sir, how can we personalize the email, for example adding a column for first name and a column for a possible message. For example using VBA replace code.

[@Exceltrainingvideos]

Did you write some code?

[@Ivy-qq7iy]

Yes, I have code that is personalized which I use daily, but I have to use two workbooks one with the data and the other one has the VBA code which I then enter the emails for that day manually based on the dates of the first workbook.. I would like to consolidate into one workbook and automate.

[@anoopdeb]

Thanks very helpful but stuck in I want to use .send but showing "run time error '287':

[@Exceltrainingvideos]

Visit www.exceltrainingvideos.com to learn more.

[@satyenderjangra3426]

hello dinesh sir I tried to run this VBA program with my excel file but facing some compile error that user defined type not defined. I just followed the codes you provided in this vedio. I want to know whether there are some more steps before or after the instructions in this vedio which has not been provided. regards satyender

[@Exceltrainingvideos]

Visit www.exceltrainingvideos.com or www.familycomputerclub.com

[@billpeng5441]

When I run this VBA, it comes out that: the user defined type is not defined. Which part I should define on your VBA code?

[@Exceltrainingvideos]

Have you activated the Microsoft Outlook Library from tools --> References.

[@billpeng5441]

@@Exceltrainingvideos No. I did tool-references--and give ticket to all outlook related library. Then click OK. but still saying the user defined type is not defined

[@billpeng5441]

I went there, and pick microsoft outlook 16.0 object library. then click OK. is that right?

[@dancingninja4597]

Dear Mr Takyar, I am trying to build an Automate Email reminder for my own. Everything works well except on the .Send command The outlook mail to send we use the command - .Send When i save and run the VBA code, it prompts an error as below: Run-time error "-2147467259 (80004005)': Outlook does not recognize one or more names. The error is pointing towards the .Send command. I am using MS Excel 2013. How can i get this fixed? Hope to hear from you soon.

[@Exceltrainingvideos]

Check your code. Also check whether you've activated all the required libraries as shown in the video.

[@dancingninja4597]

Dear Mr Takyar, Thank you for responding to me. When i type .Send the dropdown box appears which allows me to click on the .Send command. But when i run this VBA script its still showing me the same error. If i put .Display it is working as per your video shown, but if i put the .Send its showing error. I have followed exactly as your video. I went to Tools > References > and activated Microsoft Office 15.0 Object Library Microsoft Outlook 15.0 Object Library Could you please advice me which tool exactly do i need to activate from the libraries?

[@Exceltrainingvideos]

Check this link with a downloadable sample file: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@vickietran6714]

Dinesh Kumar Takyar, can you please help me on a worksheet I am currently working on? Can I contact you via email?

[@SkionMars]

Will this scrip run every time I open the file? Thanks

[@dancingninja4597]

Dear Mr Takyar, .Subject = "Contract end date nearing" .Body = "Please be informed that there is a candidate Contract End date is approaching for." & vbCrLf & "From Admin" For the above .Body message i would like to put in as the message above but instead of being Candidate, i would actually prefer the actual name of the candidate which is in Column A do be inserted into the email message. Please help me? Sincerely, Prasath

[@Exceltrainingvideos]

Try this: .Body = "Please be informed that there is a " & Range("A2").value & "Contract End date is approaching for." & vbCrLf & "From Admin". Here I've assumed that you've a header in Range A1. For all values in column A, you'll have to create a loop. Alternatively do a search at exceltrainingvideos.com

[@durgajain5997]

Hi Dinesh, How to use Notes instead of outlook in the code...

[@Exceltrainingvideos]

Haven't worked on this idea.

[@maheshbandaru9096]

Dear Sir I want to use this same logic for lotus notes, how it is possible. Pls reply me.

[@DatGuyHobbies]

hi, i was wondering. what if i wanted to add in the body of the email information from a customer. lets say a creditcard is due and it sends an email would it be posible for that email to have the customers info taken directly from the excel sheet?

[@Exceltrainingvideos]

Yes. Just refer to the range(s) in your code:

[@ashrafunnisaanwar7227]

Hello Dinesh, Will this Macro check the non responded emails on outlook and then send a auto reminder based on number of days condition,, IF no is there a possibility to do this Looking forward for your valuable inputs. Thanks Ashraf

[@Exceltrainingvideos]

Interesting and important question.

[@sannu1007]

Is this same formula for excel 2013 also ,please clarify

[@Exceltrainingvideos]

Search www.exceltrainingvideos.com or Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V If you are from India you can get this book here: amzn.to/2jzJGqU

[@Deepak33002]

Dear Sir, I need your help i have many line items in excel to send one customer please help how to do this

[@SachinSingh-fj5je]

Sir i am getting error while running the above code , can you plz tell the prerequisite and the correct code for this ASAP.

[@Exceltrainingvideos]

Have a look at this link: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@GUGASELVAM-z5v]

Any of them ready to share my error and to sort immediately

[@bala6238]

sir i followed your commends but i am getting user-defined type not defined error message how to fix it please help me to fix it thanks in advance.

[@Exceltrainingvideos]

At which line of code are you getting the error?

[@AkshitGupta29]

+Dinesh Kumar Takyar Sir In the second line where you have written Dim myApp As OutLook.Application, mymail As OutLook.MailItem

[@saifhasan107]

Hello Sir, I've followed the entire code you've suggested here but when I push the run button the following massage appears, pls suggest, "Compile Error: user defined type not defined."

[@Exceltrainingvideos]

+saif hasan Check you code line by line!

[@saifhasan107]

Sir, thanks & I've figured it out by your help but afterwards faced an error which is "subscript out of range" & the debugger is showing yellow mark on below "lastrow =Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row" can you pls help on it. thanks, saif

[@Exceltrainingvideos]

+saif hasan Check the name of your worksheets or exact number of worksheets.

[@saifhasan107]

Sir, I've checked & input it correctly nevertheless it shows the massage, I presumed it is my lacking to understand "Cells(Rows.Count,1).End(xlUp).Row" this portion of the code, pls help if possible. thanks, saif

[@saifhasan107]

Hi Sir, I've Managed to run the code but pls need to know does this work automatically ? or I have to press the run button each time I open the worksheet ? If possible let me be clear. Thanks, Saif

[@waseemmehar219]

Kindly tell me how to send mail automatically from two different sheets

[@Exceltrainingvideos]

What's the idea?

[@kewalprakashdoshi8768]

sir, can we send auto emails through lotus notes?

[@Exceltrainingvideos]

www.rondebruin.nl/win/s1/notes/notes5.htm

[@amynelson7579]

Is there a way to add HTML to the message? My test didn't recognize it, but we're hoping to stylize it. Also, is there a way to send a unique email to every email address? If I'm trying to remind someone to send me their Invoice and I have a reference number to give them, it would be extremely awesome and convenient to have it automatically inserted into an email. IE: "To whom it may concern: Invoice ### is due."

[@Exceltrainingvideos]

+Amy Nelson This link might help: www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/

[@amynelson7579]

I'll check it out, thanks for the prompt reply!

[@amynelson7579]

Unfortunately, the link provided doesn't address any of the questions I had. I did figure out how to use HTML for the email on my own (.HTMLBody instead of .Body), but still can't send a unique email to each email address in the list. I want to refer to each customers' unique Invoice Number automatically. It can be in the body or the header, it doesn't matter, but it IS important to reference an Invoice#. Is there a way to do this? The set up of my sheet is as follows: A1 - CUSTOMER, B1 - FOLLOW UP DATE, C1 - REMINDER, D1 - EMAIL, E1 - INVOICE# Thank you in advance!

[@avijitnov]

Hi Sir, in my sheet this line is not working "Dim myApp As Outlook.Application, mymail As Outlook.MailItem". I discovered that whin I am typing out "Dim myApp As Outlook" the Outlook app is not appearing in the dropdown list....Thanks sir

[@Exceltrainingvideos]

Have you selected the appropriate references (Microsoft Outlook Object Library) from Tools in the VB Editor?

[@naveednak5113]

sir mujhe ek confusion he confusion ye ke mai excel main ek active x list box select karta ho jis mai automatically saari sheets ki naam ajae or mai active x listbox mai se ek sheet ko select karo or oos mai ye pata chale ke oos sheet mai 2 pages he or mai os ko apne marzi ke mutabiq print kya ye ho sakta he plz es pe ek tutorial banae.

[@Exceltrainingvideos]

Sub PopulateListBox() Dim ws As Worksheet 'clear contents Sheets("Sheet1").ListBox1.Clear For Each ws In Worksheets Sheets("Sheet1").ListBox1.AddItem ws.Name Next End Sub Private Sub ListBox1_Click() With Sheets(Me.ListBox1.Value) 'for hidden sheet ' .Visible = True .Select .PrintPreview End With End Sub

[@phoonelatyoone]

Dear Sir, when i do test run with VBA porgram, the program run perfetly. (no Error). But after i close and open the file, the program not running automatically. i need to run manually. Why? Couly you please explain?

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/ A sample file is also available for download.

[@phoonelatyoone]

​@@Exceltrainingvideos Dear Sir, is it VBA version is 7.1.1080 doesn't regoinze ".Display" format? because my program straight away send email without display first. Please kindly advise.

[@hazembizri4998]

hello, Sir, I don't have office 365 is it possible that it's debugging for that its debbuging in the email Dim section please waiting for your reply

[@Exceltrainingvideos]

This link with a downloadable sample file will help: www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/

[@ubaidkhan-wx6qc]

sir how can i write a command in VBA Module to take range suppose if the value of the parameter is up-to 1000 than interest rate = 5.3 , if value is up-to 10000 then interest rate = 6.5 and so on ?

[@Exceltrainingvideos]

+ubaid khan This link will help: www.exceltrainingvideos.com/sample-project-in-vba/

[@ubaidkhan-wx6qc]

+Dinesh Kumar Takyar Thank you so much sir. this link is really helpful ... .