Dear Dr. Takya, I believe I now have a good understanding on how to send emails from Excel through VBA, thanks for that!! The next set for me would be to get Outlook to talk back to Excel to highlight the email recipients my "automated" email did not reach, due to either the email recipients not being in existence anymore (i.e. the individual has left the organization) or due to the attachment sent being too heavy for the email to go through or due to any other reason... Not quite sure this is possible, but would appreciate your assistance in case it is
Great Video! I was wondering if there was a way to set the outlook email address to send the email from? Currently the emails are sent from my default email but I want the messages to be sent from another email address.
Hi Dr. Takya could you pls help us in writing the code for the below said requirment i have some names in A column and its value in B column. i would like to know whether i can lock the respective cell whose value is equal to or greater than 0. thanks Ram
Hi Dr.Takya i want your help on outlook automation. I have to select each and every time from option to send email to customer. u have group mail box and i need to send mail from that inbox so i need to select from option and then select my group mail box. is there any sort cut or automation that can help me?
Hi Dinesh. how to Automate Excel from Outlook (e.g. each arriving outlook email should be managed automatically without interfering of user) ? Please help. Thanks for attention.
Hello Dinesh Sir, I have a requirement where I need to send tabular data from outlook mail to excel for a given time period (need to capture data from 12AM to 11.59PM). Do you have any tutorial for the same?.
Dr. Takya, I have created an outlook email with outlooks macro having attachment, subject, and body of the email. I have list of email and name of my customer, and i need to send the same email to different name and different email. I do not know how to connect this outlook email to excel file. can you please guide me?
Hi Dinesh, I am trying to send an email from Excel 2007 using Outlook/Office 365 when a certain date value has be hit on the spreadsheet. All the videos I have found so far use the Outlook client on the PC. I am using Outlook/Office 365 and having a little difficulty. Can you assist? Thanks
Good day Dr. Takyar, Thank you for the tutorial. Please advise on how to send emails from outlook with tables contained in the body. Thanks in anticipation.
Yes I have same problem. I need a specific range of cells of a spreadsheet to be copied from excel into outlook. Currently it is copied & pasted manually into outlook. I dont know if it is even possible
Thank you very much just a small problem i am getting an error 1004 it says "application define or object defined error" in this line "eRow = Sheet1.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row" what can be done?
Hello Sir, Could you help me how to add the "Signature" using Excel VBA, in the outlook mail as the signature will be changing from person to person. Please assist me.
dear Mr. dinesh is there any way i have excel log sheet for contract and i have updated along with expiry of contract date with notifications but when notifications shows that contract expiry it should send email to the person which i have mentioned email id in log so the reminder should go to that person saying that this date contract is going to expire plz could you help me for this problem
Have a good look at these links: www.exceltrainingvideos.com/how-to-create-notifications-or-reminders-automatically-in-excel/ www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/ www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/
But from outlook if suppose I have 80 bounce backs when I am exporting it into excel the output is missing emails but the text is large so it’s not taking emails which is in the end.. If u got what I am asking then please Help..
Dr. Takya, You are one of the dependent person in the World for excel VBA. It seems that you make video tutorial on the topics which is asked by your followers. As a follower, I have a question- I have 100 email addresses in column A. I want to send a single message to every persons. Have there anything you can help? and/or it is possible or not?
Hello Dr Takyar Thanks very much for sharing your knowledge, and for taking the time to educate others. . I enjoyed watching many of your videos when I was learning VBA a few years ago Just now am wanting to learn the “Excel VBA - Outlook way” of automating Email sending as a possible alternative to the “CDO Message way” which I have just mastered. I have the “CDO Message way ” working well and I think I understand it quite well. ( I watched and found your Video on this helpful ) So I have the “CDO Message way ” working well, but I would like an alternative. It appears that I must have a “working” Outlook in order to use the “Excel VBA - Outlook way”? Is that true? I have no experience with Outlook and am still just a computer novice. Can you recommend a good tutorial which will show me how to set up the minimum that I need with Outlook to allow me to use the “Excel VBA - Outlook way” Thanks Alan
Hello Dr Takyar Thank you for the quick response. I have seen this and your other 5 similar videos using the VBA Excel / Outlook Email way. My problem is that it appears that I must have a “working” Outlook in order to use the “Excel VBA - Outlook way” I have Outlook installed but have never used it. I believe therefore that no codes of this form will work. I need to get informed about how to make the minimum in Outlook that I must in order that such a code will work. I have found not tutorials on this yet. I think it is always assumed that a person considering such a code is already competent in normal Outlook work. I have never used Outlook I will keep looking further for information on Outlook basics Thanks anyway. Alan
Hello Dr. Takyar Please having problem in automating my outlook 2013 mails with excel 2013. Complaints are made by customers so all i want to achieve is; 1. The date of event and numbers reported from the body of the mail. That is picking only the numbers and leaving out the alphabets.(Narrations). Kindly help
Hello Dinesh, Sequel to my previous question. This is a sample of a mail I want you to help me out with. I want to group this on an excel sheet by the sent date and am only interested in the numbers in the body of the mail. From: Sent: 31 July 2017 23:27:38 (UTC+00:00) Casablanca To: Subject: MAY I REMIND YOU THAT UR REGISTERED SIM NO IS A WINNERS OF PMC PROMO AWARD OF 27,888 UK POUNDS &I PHONE 7, PIN 9939 CALL MR BEN IN GHANA O275664357& 055043318 TO RECEIVED Thank you.
Use SentOnBehalfOfName as long as your Exchange account has SendAs permission for the shared mailbox or distribution group .SentOnBehalfOfName = "email-address"
Sir I want to know how to code the vba to open a specific folder in different drive? Like I am using a macro enabled workbook for stock tracking purpose. When I issue a bill it converts to pdf format and save in a folder named PDF INVOICES in D: drive. Sir I want a macro button by which I can open that D drive pdf invoice folder to attach in outlook mail... I mean to say by clicking that button outlook mail will open along with D drive Pdf Invoice folder so that I can attach my required file. I will enter recipient manually.
Dear Dr Takyar, Good afternoon!! Thanks for the very great video tutorials. I am trying to send an email (via Outlook web access) from excel, is there a macro that can be written to automate this process? There will be multiple emails to be sent, hence looking forward to automate them. Many thanks in advance. Regards, Deepak C
Have a look at this link:www.exceltrainingvideos.com/automatically-send-email-to-users-queries-in-excel-with-vba/ Or do a search at exceltrainingvideos.com
Hello Sir, Is it possible to write VBA code to send auto follow up emails with a draft, if you dont receive any response in certain date? I am trying to have auto follow up emails, if I don't receive any response. Thank you
Dr. Takya Thanks for all your great training and im a big follower for all your videos. Recently I have seen one of your Video in youtube (How to use automation to send ms outlook mail using Excel VBA) Could you Please in my requirement we have data A row and email address B row , Macro has to pick data and send B row email address. ex : A1 email text should send it B1 email and like A2 to B2). Thanks in advance,
Hello sir, This is Nilesh from pune India i have some small business, and i need to send my company catalogue to thousands of customers across the globe. so i want to learn how i can send bulk emails through my outlook by using excel sheet in which all the emails id's included serially... Please guide me for above issue presently i am send manually one by one to my customers and i am able to send only 100 to 150 emails per day...
Hi Dr. Takya Thank you for the tutorial videos and it help me a lot. Can you please show me how to link a certain task and send email notification instead of the whole sheet. Thank you.
Hi Dinesh, i need help on recording a macro for Outlook. i want to save emails which i receive in my Inbox to a specific folder. Waiting for your response. Thank you.
Hi thanx for ur valuable response. However, i m working on one of the idea project where i need to save this emails to the specific share drive. But i dnt want this emails to be saved at once. For example - i m wrking one of the email. Once i m done. I should click on the marco wher this email should go to the specific drive. Hope u understand my scenario. Waiting fr your response thanxx alot!
Hi Dinesh Sir, First of all, thanks for your tremendous help that you are doing to make people learn VBA excel I have a requirement of automate mainframe (TN3270 Plus 3.7.4). That is just a simple thing like, i want to use macro to connect mainframe and navigate some screens and to update some string there in mainframe. Can it be possible to automate through Excel VBA??? If so please help ASAP. Thanks in Advance :) I personally salute your support :)
Greetings Mr. Dinesh, I need your help . I am a hr professional nd I want to send reminders to my staff on their emails for their anniversaries. . Birthdays using excellent data file and also send reminders using outlook to the department heads email ids on their employees performance appraisals using excellent data sheet with the dates . Is it possible .. please help me out. Thank u in advance. Kind regards , Jyothi
Hi Dr. Takya Thankyou for your videos. I cant get the email to work this is what I have put can anyone help me? Sub SendMail(Optional AttachmentPath) Dim appOutlook As Outlook.Application Dim mitOutlookMsg As Outlook.MailItem Dim recOutlookRecip As Outlook.Recipient Dim attOutlookAttach As Outlook.Attachment ' Step 1: Initialize an Outlook session. Set appOutlook = CreateObject("Outlook.Application") ' Step 2: Create a new message. Set mitOutlookMsg = appOutlook.CreateItem(olMailItem) With mitOutlookMsg ' Step3: Add the To recipient(s) to message. Set recOutlookRecip = .Recipients.Add("Shane Randall") recOutlookRecip.Type = olTo ' Add the CC recipient(s) to the message. Set recOutlookRecip = .Recipients.Add("Shane Randall") recOutlookRecip.Type = olCC ' Set valid properties like Subject, Body, and Importance of the message. .Subject = "=orderform!D7" .Body = "Please find attached order for the above customer" & vbCrLf & vbCrLf .Importance = olImportanceHigh 'High importance ' Add attachments If Not IsMissing(AttachmentPath) Then Set attOutlookAttach = .Attachments.Add(AttachmentPath) End If ' Resolve every Recipient's name For Each recOutlookRecip In .Recipients recOutlookRecip.Resolve If Not recOutlookRecip.Resolve Then mitOutlookMsg.Display End If Next .Send End With Set mitOutlookMsg = Nothing Set appOutlook = Nothing
![[안방1열 직캠4K] 베이비몬스터 치키타 'DRIP' (BABYMONSTER CHIQUITA FanCam) @SBS Inkigayo 241110](http://i.ytimg.com/vi/tnlxo79cAqY/mqdefault.jpg)
India is making great deal of progress because of people like Dr. Takyar, what an awesome guy.
Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
Thank you for your videos - I find them very clear, concise and useful.
Thank you so much Dr Takyar for your very valuable help and advises !
Superb sir! Really useful! Thanks a lot
Hi Dinesh. Excellent video. I learned a lot, thank you.
Dear Dr. Takya,
I believe I now have a good understanding on how to send emails from Excel through VBA, thanks for that!!
The next set for me would be to get Outlook to talk back to Excel to highlight the email recipients my "automated" email did not reach, due to either the email recipients not being in existence anymore (i.e. the individual has left the organization) or due to the attachment sent being too heavy for the email to go through or due to any other reason...
Not quite sure this is possible, but would appreciate your assistance in case it is
Great Video! I was wondering if there was a way to set the outlook email address to send the email from? Currently the emails are sent from my default email but I want the messages to be sent from another email address.
Hi Dr. Takya
could you pls help us in writing the code for the below said requirment
i have some names in A column and its value in B column. i would like to know whether i can lock the respective cell whose value is equal to or greater than 0.
thanks
Ram
Hi Dr.Takya i want your help on outlook automation.
I have to select each and every time from option to send email to customer. u have group mail box and i need to send mail from that inbox so i need to select from option and then select my group mail box. is there any sort cut or automation that can help me?
Hi Dinesh. how to Automate Excel from Outlook (e.g. each arriving outlook email should be managed automatically without interfering of user) ? Please help. Thanks for attention.
Thank you , very useful !
Can i send row wise separate mail to one single mail address? I have different data in different row. Thanks in advance.
This Excel tutorial should help: th-cam.com/video/wjSvoWgb5Lk/w-d-xo.html
@@Exceltrainingvideos thanks a lot sir. Let me check.
Hello Dinesh Sir, I have a requirement where I need to send tabular data from outlook mail to excel for a given time period (need to capture data from 12AM to 11.59PM). Do you have any tutorial for the same?.
Dr. Takya, I have created an outlook email with outlooks macro having attachment, subject, and body of the email. I have list of email and name of my customer, and i need to send the same email to different name and different email. I do not know how to connect this outlook email to excel file. can you please guide me?
This link might help: www.exceltrainingvideos.com/how-to-use-automation-to-send-ms-outlook-mail-using-excel-vba/
Hi Dinesh, I am trying to send an email from Excel 2007 using Outlook/Office 365 when a certain date value has be hit on the spreadsheet. All the videos I have found so far use the Outlook client on the PC. I am using Outlook/Office 365 and having a little difficulty. Can you assist?
Thanks
Good day Dr. Takyar,
Thank you for the tutorial. Please advise on how to send emails from outlook with tables contained in the body.
Thanks in anticipation.
What have you tried?
Yes I have same problem. I need a specific range of cells of a spreadsheet to be copied from excel into outlook. Currently it is copied & pasted manually into outlook. I dont know if it is even possible
Thank you very much just a small problem i am getting an error 1004 it says "application define or object defined error" in this line "eRow = Sheet1.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row" what can be done?
Did you write x1Up = xONEUp or xlUp = xLUp?
MS Excel VBA Training Thank you very much Sir i got it should have been xlUp and i was using x1Up which was wrong thanks a lot
I'm not able to find the code in the web site mentioned
www.familycomputerclub.com/How-to-use-automation-to-send-MS-Outlook-message-using-Excel-vba.html
Dear Mr. Takyar,
Do you have the same workbook that can be downloaded ready for use?
Thank you in advance.
Regards,
Lloyd
This link will help: www.exceltrainingvideos.com/how-to-use-automation-to-send-ms-outlook-mail-using-excel-vba/
Hello Sir,
Could you help me how to add the "Signature" using Excel VBA, in the outlook mail as the signature will be changing from person to person. Please assist me.
dear Mr. dinesh
is there any way i have excel log sheet for contract and i have updated along with expiry of contract date with notifications but when notifications shows that contract expiry it should send email to the person which i have mentioned email id in log so the reminder should go to that person saying that this date contract is going to expire plz could you help me for this problem
Have a good look at these links: www.exceltrainingvideos.com/how-to-create-notifications-or-reminders-automatically-in-excel/
www.exceltrainingvideos.com/how-to-send-email-reminder-automatically-from-excel-worksheet-using-vba/
www.exceltrainingvideos.com/how-to-create-notifications-in-excel-with-vba-revisited/
But from outlook if suppose I have 80 bounce backs when I am exporting it into excel the output is missing emails but the text is large so it’s not taking emails which is in the end..
If u got what I am asking then please Help..
Dr. Takya, You are one of the dependent person in the World for excel VBA. It seems that you make video tutorial on the topics which is asked by your followers. As a follower, I have a question-
I have 100 email addresses in column A. I want to send a single message to every persons. Have there anything you can help? and/or it is possible or not?
Will this work on Outlook Web application?
Hello Dr Takyar
Thanks very much for sharing your knowledge, and for taking the time to educate others. . I enjoyed watching many of your videos when I was learning VBA a few years ago
Just now am wanting to learn the “Excel VBA - Outlook way” of automating Email sending as a possible alternative to the “CDO Message way” which I have just mastered.
I have the “CDO Message way ” working well and I think I understand it quite well.
( I watched and found your Video on this helpful )
So I have the “CDO Message way ” working well, but I would like an alternative.
It appears that I must have a “working” Outlook in order to use the “Excel VBA - Outlook way”? Is that true?
I have no experience with Outlook and am still just a computer novice.
Can you recommend a good tutorial which will show me how to set up the minimum that I need with Outlook to allow me to use the “Excel VBA - Outlook way”
Thanks
Alan
Please have a look at this video: th-cam.com/video/Oa4uDulciQ0/w-d-xo.html
Hello Dr Takyar
Thank you for the quick response.
I have seen this and your other 5 similar videos using the VBA Excel / Outlook Email way.
My problem is that it appears that I must have a “working” Outlook in order to use the “Excel VBA - Outlook way”
I have Outlook installed but have never used it.
I believe therefore that no codes of this form will work.
I need to get informed about how to make the minimum in Outlook that I must in order that such a code will work.
I have found not tutorials on this yet.
I think it is always assumed that a person considering such a code is already competent in normal Outlook work.
I have never used Outlook
I will keep looking further for information on Outlook basics
Thanks anyway.
Alan
Hi Dinesh-
I need a help I need to send recurring emails to recipient which is scheduled on particular time. how can i do that
Try the ONTIME method.
This link will give an idea: www.exceltrainingvideos.com/using-timer-to-automate-getting-data-from-closed-workbook/
Hello Dr. Takyar
Please having problem in automating my outlook 2013 mails with excel 2013.
Complaints are made by customers so all i want to achieve is;
1. The date of event and numbers reported from the body of the mail. That is picking only the numbers and leaving out the alphabets.(Narrations).
Kindly help
Search www.exceltrainingvideos.com
Hello Dinesh,
Sequel to my previous question. This is a sample of a mail I want you to help me out with. I want to group this on an excel sheet by the sent date and am only interested in the numbers in the body of the mail.
From:
Sent: 31 July 2017 23:27:38 (UTC+00:00) Casablanca
To:
Subject:
MAY I REMIND YOU THAT UR REGISTERED SIM NO IS A WINNERS OF PMC PROMO AWARD OF 27,888 UK POUNDS &I PHONE 7, PIN 9939 CALL MR BEN IN GHANA O275664357& 055043318 TO RECEIVED
Thank you.
Can we send email using shared mailbox through vba excel
Please share code aswell if yes
Use SentOnBehalfOfName as long as your Exchange account has SendAs permission for the shared mailbox or distribution group
.SentOnBehalfOfName = "email-address"
Sir I want to know how to code the vba to open a specific folder in different drive? Like I am using a macro enabled workbook for stock tracking purpose. When I issue a bill it converts to pdf format and save in a folder named PDF INVOICES in D: drive. Sir I want a macro button by which I can open that D drive pdf invoice folder to attach in outlook mail... I mean to say by clicking that button outlook mail will open along with D drive Pdf Invoice folder so that I can attach my required file. I will enter recipient manually.
Good question!
Shell "Explorer.exe C:\folder-name\"
Dear Dr Takyar,
Good afternoon!!
Thanks for the very great video tutorials. I am trying to send an email (via Outlook web access) from excel, is there a macro that can be written to automate this process?
There will be multiple emails to be sent, hence looking forward to automate them.
Many thanks in advance.
Regards,
Deepak C
Have a look at this link:www.exceltrainingvideos.com/automatically-send-email-to-users-queries-in-excel-with-vba/
Or do a search at exceltrainingvideos.com
Hello Sir,
Is it possible to write VBA code to send auto follow up emails with a draft, if you dont receive any response in certain date? I am trying to have auto follow up emails, if I don't receive any response.
Thank you
This link will help: www.exceltrainingvideos.com/automatically-send-email-to-users-queries-in-excel-with-vba/
Dr. Takya
Thanks for all your great training and im a big follower for all your videos.
Recently I have seen one of your Video in youtube (How to use automation to send ms outlook mail using Excel VBA)
Could you Please in my requirement
we have data A row and email address B row , Macro has to pick data and send B row email address. ex : A1 email text should send it B1 email and like A2 to B2).
Thanks in advance,
How to write autoresponder emails?
Hello sir,
This is Nilesh from pune India
i have some small business, and i need to send my company catalogue to thousands of customers across the globe. so i want to learn how i can send bulk emails through my outlook by using excel sheet in which all the emails id's included serially...
Please guide me for above issue presently i am send manually one by one to my customers and i am able to send only 100 to 150 emails per day...
hello sir,
will you please teach me vba in excel ?
Hi Dr. Takya
Thank you for the tutorial videos and it help me a lot.
Can you please show me how to link a certain task and send email notification instead of the whole sheet.
Thank you.
Hi Dinesh,
i need help on recording a macro for Outlook. i want to save emails which i receive in my Inbox to a specific folder. Waiting for your response. Thank you.
You don't need Excel VBA for this. You can do this directly from Outlook.
Hi thanx for ur valuable response. However, i m working on one of the idea project where i need to save this emails to the specific share drive. But i dnt want this emails to be saved at once. For example - i m wrking one of the email. Once i m done. I should click on the marco wher this email should go to the specific drive. Hope u understand my scenario. Waiting fr your response thanxx alot!
Hi Dinesh Sir,
First of all, thanks for your tremendous help that you are doing to make people learn VBA excel
I have a requirement of automate mainframe (TN3270 Plus 3.7.4). That is just a simple thing like, i want to use macro to connect mainframe and navigate some screens and to update some string there in mainframe. Can it be possible to automate through Excel VBA???
If so please help ASAP. Thanks in Advance :) I personally salute your support :)
Best person to talk to in this case is the system administrator.
Dinesh Kumar Takyar can you sujjesst one?
i am a school accountant i want to send sms to parents from Excel VBA
Greetings Mr. Dinesh,
I need your help . I am a hr professional nd I want to send reminders to my staff on their emails for their anniversaries. . Birthdays using excellent data file and also send reminders using outlook to the department heads email ids on their employees performance appraisals using excellent data sheet with the dates . Is it possible .. please help me out.
Thank u in advance.
Kind regards ,
Jyothi
Please search my website www.exceltrainingvideos.com or this TH-cam channel. Both have a number of videos on this topic.
thanks Dr. Dinesh
Hi Dr. Takya
Thankyou for your videos. I cant get the email to work this is what I have put can anyone help me?
Sub SendMail(Optional AttachmentPath)
Dim appOutlook As Outlook.Application
Dim mitOutlookMsg As Outlook.MailItem
Dim recOutlookRecip As Outlook.Recipient
Dim attOutlookAttach As Outlook.Attachment
' Step 1: Initialize an Outlook session.
Set appOutlook = CreateObject("Outlook.Application")
' Step 2: Create a new message.
Set mitOutlookMsg = appOutlook.CreateItem(olMailItem)
With mitOutlookMsg
' Step3: Add the To recipient(s) to message.
Set recOutlookRecip = .Recipients.Add("Shane Randall")
recOutlookRecip.Type = olTo
' Add the CC recipient(s) to the message.
Set recOutlookRecip = .Recipients.Add("Shane Randall")
recOutlookRecip.Type = olCC
' Set valid properties like Subject, Body, and Importance of the message.
.Subject = "=orderform!D7"
.Body = "Please find attached order for the above customer" & vbCrLf & vbCrLf
.Importance = olImportanceHigh 'High importance
' Add attachments
If Not IsMissing(AttachmentPath) Then
Set attOutlookAttach = .Attachments.Add(AttachmentPath)
End If
' Resolve every Recipient's name
For Each recOutlookRecip In .Recipients
recOutlookRecip.Resolve
If Not recOutlookRecip.Resolve Then
mitOutlookMsg.Display
End If
Next
.Send
End With
Set mitOutlookMsg = Nothing
Set appOutlook = Nothing