How to send Email through Outlook at Specific Tme

[@datadev1]

What a great tip. I work with a group that needs to send out the results of inspection reports every week. I have the data in an worksheet so this technique would work perfectly. The only difference I have is that the pictures reside in another worksheet in the same workbook but I should be able to go back to the original image folder. Thank you so much for sharing this technique.

[@vksfuntoon]

Nice and helpful vdo sir,Thanx

[@barryfitzpatrick4987]

Another good video. One thing to mention though is that if the timer is a long time into the future then the instance of Excel from which the Timer was set needs to remain open. I prefer to use the Windows Task Scheduler to invoke the macro which is now in the Workbook_Open routine, as well as the Timer function just in case that instance of Excel is still open. I have several reports that run overnight some daily, some alternate days and another weekly all using the Task Scheduler, I add the code Application.Quit at the end of the routine to close Excel once the Task Scheduler has opened it.

[@Exceltrainingvideos]

Thanks for sharing!

[@sallytong241]

It is a fantastic idea. I am wondering if it is possible to send a list of email not all at once, but each mail should be sent out in 30 seconds apart. For example, 1st email send at 00:00:30, 2nd email send at 00:01:00 etc.... Thank you.

[@Exceltrainingvideos]

Yes you can! Use a time value with the wait function. This link will guide: www.exceltrainingvideos.com/tag/automatically-create-message-box-with-timer/ You can search this channel or www.exceltrainingvideos.com

[@goldensidex]

Hello,another perfect video.But i have a questions. How can i set for send automatically email in every day at a specific time. Examples: 6 days per week, send automatically in everyday at 08:00 morning. Thanks you a lot.

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/tag/using-timer-to-automate-getting-data-from-closed-workbook/ Take care of the remarks using an apostrophe.

[@djdino3213]

I m getting an error as sub function not defined

[@davidmosedale4586]

Hi I would like to know how to add a Microsoft Data Source like Microsoft Outlook in excel some version have it but my office 365 has not

[@Exceltrainingvideos]

This Excel VBA tutorial on Outlook will guide: kzbin.info/www/bejne/aWbKaX1oot-Xi7s You can also search my channel.

[@guweizhao3430]

Sir, your example only send email once after click "run" Macro. if I want repeatedly send email at specific time everyday , how can write the code?

[@Exceltrainingvideos]

These Excel lessons will guide: kzbin.info/www/bejne/e3i7gYSpZbdoj6s kzbin.info/www/bejne/epbah5WvgKiembM

[@suralasika]

Sir I want this code to run as per a True match. Once its TRUE excel would filter a list where I have email ids, and it would send to them.. Note: Nothing as per specific time, but as per True Match criteria with multiple email ids . And all of them to be shared a separate email

[@md.mahmudulislamhillol2585]

How can I format the body of the mail? Like - bold font, big font, colored font

[@DJdavefromlondon]

thanks indeed. on my 2nd module called sendreminder, VBA puts it in red text , when I run I get "Compile Error: Expected: Inentifier" . Even when I remove the code from 2nd module, then start again simply typing Sub sendreminder (0) it doesnt allow it. Perhaos I need to do something to tell VBA I have 2 modules ?

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/run-multiple-macros-excel/ You can also search my channel or website.

[@rajnishkumarthakur2498]

👌👌👌this is very helpful👍👍thanks

[@philmarsh7523]

Hi there, Do you have a video or the vba code to be able to send an email with an attachment when a outlook reminder goes off at the same time each day? As i used to have this functionality as a colleague who has now left coded it - I have now changed Pc and lost this so have been trying to code myself but i'm still very new at VBA coding. I have been able write it to send if i press the macro button, but this allows me to forget if i'm in a meeting that overruns etc. If you have something that would be great!

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/how-to-send-email-through-outlook-at-specific-tme/

[@SyedMuzammilMahasanShahi]

Thanks Dinesh for this wonderful video

[@mahadevshirodkar9878]

thank you sir.. one question. The excel that contains the macro need to remain open right to work this macro?

[@barryfitzpatrick4987]

Mahadev Shirodkar Yes it has to be open. What I do is use Windows Task Scheduler to open the Workbook on certain nights (c. 2am) and set the macro to run from the Workbook_Open macro then automatically Quit Excel once it has finished. That way I don't have to rely on leaving the Workbook open when I finish work for the day.

[@r27td48]

@@barryfitzpatrick4987 Hi dear, that's amazing, can you explain how to use the task manager to open a specific excel file, at an expecific hour?

[@barryfitzpatrick4987]

BTW when opening the workbook for editting hold down the Shift key whilst opening, otherwise the macro will run and then Excel will close.

[@mahadevshirodkar9878]

@@barryfitzpatrick4987 Thanks

[@r27td48]

@@barryfitzpatrick4987 Wow thank you, that's nice.... But one doubt, to make this vba code works automatically even when the file is not open... You have to put the code and press the green play button on top and save? And you have to use the task scheduler to open the file and run? It's possible to run only that process, that VBA code without open the Excel file xslm?

[@guweizhao3430]

what is your outlook email address in your program? there only gmail?

[@PranL_datzme]

We need to run this Macro everyday?

[@Exceltrainingvideos]

That depends on you!

[@abuabou7679]

Thank you sir for the video , it will automatically run on daily basis at specific time or need to open excel and run it

[@Exceltrainingvideos]

You'll need a VB-Script to run it automatically. Just search my channel to find the Excel solution.

[@abuabou7679]

@@Exceltrainingvideos ok sir thank you❤️

[@drs10301]

Hi sir Any video on task scheduler in detail as I am looking for tasks to run automatically at scheduled time which will help me in reducing some man-hours

[@Techreviwer]

I want to take a screenshot of the data in Excel by Excel screen shot function and send that screen shot in email with data how do I do that

[@Exceltrainingvideos]

1. Select the data 2. From Home --> Copy --> Copy as Picture... 3. Paste the screenshot in your mail 4. If you wish you can paste the data in Paint and save the file as a 'jpg' file.

[@Techreviwer]

@@Exceltrainingvideos Thanks Sir got it

[@shalinimenon6248]

Great learning sir thank you. Pls help how to report out whether email responded or not?

[@Exceltrainingvideos]

That's not an easy project!

[@krn14242]

Thanks Dinesh. Since you checked the Microsoft Outlook Object Library you really don't need to declare Outlook Application as an object like you did. You could simply DIM yr Outlook variable as Outlook.Application and then yr Mailitem as DIM xxx as Outlook.MailItem.

[@madhusudhan5384]

Hello Sir , This vedio is really helpful. Sir I need your assistance to send auto email from excel on specific day and time with ppt attchemen in the other folder, a recurring auto email for whole year..please assist

[@lijumon6414]

I have a request sir, Can you please advise me that how can I attach an excel page to outlook directly from excel in one touch .I am not asking for the whole workbook just one tab how can I attach.. that's the only page I need to attach instead of whole workbook

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/how-to-use-automation-to-send-ms-outlook-mail-using-excel-vba/ Or search www.exceltrainingvideos.com

[@tusharchauhan4435]

Hello sir, I need to send weekly reports at morning 11 am using vba... Can you please help me on this...

[@Exceltrainingvideos]

This VBA tutorial will guide: www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/

[@barryfitzpatrick4987]

For Users who do not run MS Outlook there is a code available to use a GMail account directly instead.

[@Exceltrainingvideos]

Could you share the code with the community?

[@djdino3213]

hi sir I am getting a compilation error for this coding pls can u advise wht needs to be done

[@barryfitzpatrick4987]

The default Body is plain text, to send formatted text you need to use .HTMLBody instead of .Body, and then use standard HTML Tags to format the text

[@sunnyduseja3197]

Hi sir , can you please help in fetching multiple cells data from Excel to outlook. Thanks in advance

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/import-excel-data-into-outlook/

[@suyashpalande7667]

Sir, i have outlook 2016 installed and i'm geeting debug error message on following code. Set OutLookMailItem = OutLookApp.CreatItem(olMailItem) Can you please guide to send email through outlook 2016.

[@Exceltrainingvideos]

Check your 'References'.

[@neetshil1434]

Hello sir, Can i create vbs file to send email reminder at specific time without opening vba excel file? actually im trying to run vbs file but its not sending any email

[@Exceltrainingvideos]

Just try it out!

[@neetshil1434]

@@Exceltrainingvideos I think u forgot to add link..can u please send

[@ahmadzarif3912]

Hi sir, I have one question for you. My boss ask me to find a solution to create pop up notifications based on due date which means 1 month earlier before the due date, can you suggest me the best way to get it done ?

[@Exceltrainingvideos]

www.exceltrainingvideos.com/using-dates-with-excel-vba-to-automate-email-reminders/ or search www.exceltrainingvideos.com and this KZbin channel goo.gl/5Jx1NP

[@ravindrashinde707]

My tiger imge is not coming on body its getting aatached with mail😕

[@Exceltrainingvideos]

Can you share your code here?

[@HarishReddyVennapusa]

Hi Sir I have gone through many of your videos and all are good and interesting.. Could you please help me for comparing two different sheets which will be having dynamic key fields and dynamic rows and columns. Comparison should be done based on key fields. After comparison the output is needed in a separate file with key fields and their values along with the headings... Thanks in advance sir.

[@robertbrede6199]

Thank you for the video. My Excel is communicating with PLCs... 24 hours a day. Excell cells have constantly changing values. HOW can I automate emails? when the VALUE IN A CELL suddenly reaches ... 10. I already have the macro that send out the email. (example)- I just need it to AUTOMATICALLY SEND the email (if the value in cell A5 becomes.... 7...0r 17... or 32767. No one here on KZbin seems to know how to do this. Thank you so much!!!

[@Exceltrainingvideos]

Try using an 'IF' condtion.

[@vishalthakral1470]

Please send the workbook with both the modules written. I will change fields as required. Thanks in advance

[@vinaynagaonkar8592]

Need to know how to send many emails one after another at an interval of say 2 to 3 minutes, when you need to send 100 emails in a day, thanks for your video, I learnt a lot

[@Exceltrainingvideos]

You can try and add a looping process to the video you just watched.

[@vinaynagaonkar8592]

I need to learn the loop process, I don't know visual basic and computer programming, well let me learn, Thanks a lot

[@AnandSingh-cv1qw]

Nice videos

[@kiranbainade9737]

How to send SMS to mobile number using Excel macro only to desired numbers from list

[@Exceltrainingvideos]

Ask your service provider.

[@mkchannel557]

Hai..can you share about vba how to automation send bulk email with scheduling delay ?

[@Exceltrainingvideos]

Bulk email as in spamming?

[@mkchannel557]

@@Exceltrainingvideos i mean if I want to send automatic e-mails with a lot of birthday data, e-mails are automatically sent and automatically each e-mail has a delay schedule on the outlook for each person's birthday..is it possible if we do that with vba?

[@parmarpankajkumar7958]

Thanks it's useful

[@AnkitSharma-xy7st]

Hi sir, this is very good and useful video. Sir, I am facing a problem that I have to fetch data from outlook to excel on daily basis for my daily reports. For example we have a group email id "WFM" and get one file from that email and copy that file into my main file which have monthly record. I get multiple emails per day and copy that file into different sheets. Please sir help me this to automate.

[@Exceltrainingvideos]

kzbin.info/www/bejne/aWbKaX1oot-Xi7s

[@Viji_nkl]

Thanks lot sir.............suberb

[@PiXpilot_Shridhar]

Dear Sir, Very helpful. Kindly help me to send an Email using Thunderbird. Kindly suggest.

[@Exceltrainingvideos]

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

[@officialbaryar2017]

Dear Sir thia very useful video but can you tell me how can i send reminder on specific date and time

[@Exceltrainingvideos]

This link will help: www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/ Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/

[@siva.dhanaraj1710]

Sir, I want to send multiple work book with at a same time basis. If it is possible kindly post the video about it... Thanks

[@Exceltrainingvideos]

You can send them as attachments.

[@siva.dhanaraj1710]

I maintains ten workbooks. every day I will modifying(Some date add or Clear) those and send to concerns(more then 10 peoples) I need your valuable suggestions....

[@abulhasan7776]

Thank you sir

[@abhijitbhandari621]

Didn't work. Please help

[@Exceltrainingvideos]

Try again: www.exceltrainingvideos.com/how-to-send-email-through-outlook-at-specific-tme/ Watch the video carefully.

[@mohamedayoub9278]

Ilike it thanks for this video

[@taoli5497]

测试通过， 谢谢。

[@kashankhan3137]

Wonderful! You are a great teacher. I want your proper online tuition. Is it possible? Regards. KASHAN

[@Exceltrainingvideos]

I conduct only corporate trainings in New Delhi and NCR.

[@kashankhan3137]

@@Exceltrainingvideos .... my misfortune.............. Can you help me in an excel vba problem? If you allow i can e-mail you. Plz reply. Thanks. Kashan

[@drgood2000]

Thank you Mr. Dinesh I have question about whatsapp, i want to send msg or data from excel sheet to whatsapp. Some videos show ways. But i think it's not correct. Could you give me code explain that, please.

[@islamaly7624]

Hi sir Thanks alot for wonderful vedios Pls i want to help me for sending email to multi persons , like the example in down To: a,b,c Cc:d,e,f Best regard,

[@Exceltrainingvideos]

You are welcome. This link will help: www.exceltrainingvideos.com/how-to-use-automation-to-send-ms-outlook-mail-using-excel-vba/ Or search www.exceltrainingvideos.com using the keyword 'outlook'. Please share with your friends also on social media to spread the knowledge.

[@siva.dhanaraj1710]

i = last row Like To :- A2 & i value Cc :- B2 & i value Sub :- C2 & i value Body :- D2 & i value Path :- E2 & i value

[@Exceltrainingvideos]

Example: Range("A"&i) You have to set the value of i properly.