One Note: the quotation marks in the code appear to not work well from Wordpress to Outlook and there also is a space appearing between the quotation marks and some of the symbols. If you get errors in the code once you paste the code and run it, remove the default quotation marks and then type the quotation marks back and those quotation marks should be accepted. Also remove spaces between quotation marks. Do this for each line with quotation marks and that should fix the issue.
OMG!! I finally got it to work!! When copying the codes from the link paste the "text only" into an email then copy it to paste into the VBA. Multiple characters were causing a "Syntax error" Thank you for this Johnathan! Being able to send myself a recurring email is freaking awesome!
Hi Jonathan, I can't seem to paste the code. I would love to be able to do this. Your instructions are great until we get to the part I have to insert the code. Can you help?
Code #1 is below for "ThisOutlookSession" section (note: you will have to remove the "?" from the below code which youtube is adding to the code.) Go to the developer tab, then select "Visual Basic," then "ThisOutlookSession" is within the "Microsoft Outlook Objects" folder. That folder should appear there if you did the first part of the video correctly) Private Sub Application_Reminder(ByVal Item As Object) Set olRemind = Outlook.Reminders Dim objMsg As MailItem Dim objApp As AppointmentItem Dim Att As Attachment Dim tmpFolder As String Dim filePath As String Set objMsg = Application.CreateItem(olMailItem) If Item.MessageClass "IPM.Appointment" Then Exit Sub End If If Item.Categories = "Send Schedule Recurring Email" Then tmpFolder = Environ("TEMP") For Each Att In Item.Attachments filePath = tmpFolder & "\" & Att.FileName Att.SaveAsFile (filePath) objMsg.Attachments.Add filePath Kill filePath Next Att objMsg.CC = Item.Location objMsg.Subject = Item.Subject objMsg.Body = Item.Body objMsg.Send Set objMsg = Nothing ElseIf Item.Categories = "Recurring Email" Then tmpFolder = Environ("TEMP") For Each Att In Item.Attachments filePath = tmpFolder & "\" & Att.FileName Att.SaveAsFile (filePath) objMsg.Attachments.Add filePath Kill filePath Next Att objMsg.BCC = Item.Location objMsg.Subject = Item.Subject objMsg.Body = Item.Body objMsg.Send Set objMsg = Nothing ElseIf Item.Categories "Send Schedule Recurring Email" Then Exit Sub End If End Sub
Here is code #2 (to put in module 1. You have to manually create a module. Just go to the developer tab, then select "Visual Basic," then select "Insert", then choose module and it will create module 1): Public Sub UseWord() Dim Ins As Outlook.Inspector Dim Document As Word.Document Dim Word As Word.Application Dim Selection As Word.Selection Set Ins = Application.ActiveInspector Set Document = Ins.WordEditor Set Word = Document.Application Set Selection = Word.Selection ‘insert here your macro from word End Sub
If those codes don't work after you paste them into the two respective locations I mentioned, wherever there is a quotation mark, delete the quotation mark and then add it back using your keyboard. Let me know if you still need any help.
I don't understand why these lines are red.....IF Item.Categories = “Send Schedule Recurring Email” Then ...its giving me an error saying Compile error- expected Then
@@Anna901020able Yes. amanda brackett 2 weeks ago OMG!! I finally got it to work!! When copying the codes from the link paste the "text only" into an email then copy it to paste into the VBA. Multiple characters were causing a "Syntax error" Thank you for this Johnathan! Being able to send myself a recurring email is freaking awesome!
I am also getting the below error Run-time error ‘-2147024893 (80070003) cannot save the attachment. Path does not exit verify the path is correct. Can you please help me on this too.
Hi Jonathan I have a run-time error ‘-2147024893 (80070003) cannot save the attachment. Path does not exit verify the path is correct. Can you help me with this? Many thanks!
Hi Jonathan, Great presentation. I added all the coding into VBA and all looks good. Although, the email does not actually get sent through. I receive the actual notification but no email gets sent at all. I am not sure what is missing.
BUMP and ditto... Any thoughts Jonathan? I know it's been some time since you've posted this, but wanted to see if this would still be on your radar. Thanks!
@@juancarlosathome101 In the outlook session you need to change the category name in two place, the one he mentions and there is another closer to the to top. Look for “Send Schedule Recurring Email” and change this to your category name as well.
@@sr_spongebob Hi Bob. Could you be more specific where the 2nd location is on the “appointment” window? One location is in the “categorise” on the ribbon, but where is the other?
It is working fine. Thank ypu for the help. But in the email being sent the receipient mail is coming in CC but not in To section of the email. How to overcome this. Please help here.
incase i set it up to start a week later and already save and close the email, what is happening to others whom i put the email in? do they receive email immediately? or just a placeholder in their calendar?
They will not receive any plaeholder on their calendar at all unless you invite them to the calendar event which you don't need to do. The event alert on your calendar is what sends the email to them. As long as there is no alert, the email will not be sent to them.
Hi, everything seems OK, yet, when you are inserting the codes you shared, I did not see exactly where you inserted, since I have an error pop up on my screen, and the MS Visual Basic screen comes up and shows me the "TheOutlookSession" window where I inserted the big code. Obviously I am doing something wrong. Can you please help? Best regards.
My first email in the series went out great but it was a daily recurrence and while I am getting the calendar notifications each day, the emails aren't going out each day like they did the first day. Any suggestions?
First, I would double check you saved the macro settings explained at the beginning of the video so that they always run. Also check the developer tab is showing up in Outlook. You can just review the start of the video. Second, make sure the notifications are set up and working for the recurring emails. Third, if those two checks are not the issue, verify your work hasn't blocked macros running in Outlook by asking someone in IT. I hope you are able to get it up and running.
@@chujunhuang566 you can use the same category format for a totally different email. All the category does is make sure an automated email is sent and will not send the same email if you change the email content you automate.
@@tjosi-1018 Very true about Power Automate - great to hear of someone taking initiative to figure out a task. I am sure you are a valuable employee at your work.
@@jonathandm9740 Thank you so much. I appreciate your help. We will begin using your codes and automation for our company. The recurring emails is very helpful.
@@aareliablehomehealthcare2532 One other potential suggestion if you will have multiple people sending out different emails that require slight modification. If you remove the line of code that says "objMsg.Send", it will set up a draft email automatically, but does not actually send it and gives anyone using the code one final chance to review before sending the email. I have had better success by having everything automated except adding a final manual review when I am not the one sending the email.
@@jonathandm9740 Ah, that is why I could not set it up on my colleages computer, what is the way around this? It works fine on my work computer, with the code and all, but could not get it to work on my colleages computer.
@@aareliablehomehealthcare2532 it should work fine on any computer. It's hard to say for sure without seeing their computer, but if you copied and pasted the exact same code you used for your colleage that worked for you but it isn't working for them, it likely means they don't have the right macro settings and the code isn't running as a result. I suggest having them review the first part of this video to make sure their settings are correct and they are using both sets of code. I also suggest reviewing my pinned comment in the comment section. I wish you guys well.
hi, this is great! where can i find the detailed version of this tutorial? i was met with a syntax error after following instructions and am wondering if the detailed version will help me better understand. Thanks!
If I am understanding your question correctly (let me know if not) that code has to be pasted: 1wordsword.wordpress.com/2021/04/13/recurring-outlook-email-code/
Emails do not appear in 'SENT'. Be careful when testing and ensure to test on your own account first. I have just spent and hour trying to debug why my emails were not beign sent, only to find thatthey were (a dozen times :D) and there is no record in 'sent' box.
Hi, how does one make sure that the enabling / use of the Macros in Outlook is not going to compromise the Pc i.t.o security. We run Kaspersky Cloud + Suite and we dont want to create a risk from the inside w.r.t Macros but the video explanation is very good
Enabling macros doesn’t allow a stranger to paste code in Outlook and run a macro; it just means a macro can now be run in Outlook. Only the macros you set up in Outlook will run. That said, anytime you copy and paste code instead of building it yourself, you should check to make sure there is nothing fishy with it. That is the one way you can easily get in trouble. In this case, I built most of the code and it is safe. Just be cautious if you decide to use any other code you find on the internet for Outlook. 👍
@@jonathandm9740 insert here your macro from word - This part in the smaller code section seems to hilight in red as a compile error and I dont see you refer to this in the video, pls advise which macro it is referring to
this is sending recurring meeting/appointment. THis can easily be done without having to go through these complicated steps by simply go to meeting, set recurrance from there. However, this option is not available when sending as normal email.
You are right it is easy if you only want a recurring meeting or reminder. However this video teaches you how to add a code so the reminders actually generate recurring emails.
Create a custom contact group that includes all emails you want; the code can be modified where you put the custom group name in the location line and then you only need one email space. If you can't figure this out I may make a future video on how to do this.
Hi Johnathan, I have a shared inbox and calendar - is there a way to make it send from that? I have set up the appointment in that calendar but nothing is sent - it works if it comes from my personal outlook account. Thanks in advance.
How do you set this up using multiple emails for different days and times? do you just add the category name to the one section in the code? so you would have two names there?
Hello, I am not sure exactly what you mean, but I will try to answer: 1. If you want your recurring email sent to multiple people, just place a semicolon in between each person’s email in the “location” section 2. Once you have a named category like the one mentioned in video,, you can use that named category anytime you want to have a recurring email. Just select that category each time. If you have a different group of people you want each recurring email sent to, change the emails in the “location” section to the new people. 3. If you want to send the recurring email from multiple email accounts, you will need multiple outlook accounts.
@@kristymanley6129 no worries. Option 2 is the applicable part then. Create your name category, and then use that category for both separate emails on their separate days. Just change the customize the information in each email and the email recipients you want for each email and the days you want the recurring email to occur for each email.
Hi Jonathan, this is exactly what I've been looking for, I followed all instructions, fixed syntax errors. The reminder pops up as expected but email does not get sent. I'm using same Outlook version, not the newer one. Do you have any idea what can be the problem please? Many thanks
Did you add the email address you want sent into the location section? Sorry if that question is obvious but just making sure all bases have been covered. 👍
Also make sure the name of your color coded notification is in the code as well. Either a different email in the code or a different name for the notification color than is in the code would cause the email not to be sent.
Hello Jonathan, This is a great tool, would make my life a heck of a lot easier. I've got to where I'm supposed to put in the code and I don't see it. I'm sorry If it is here and I don't see it. Help please! Thanks in advance for your help. AP
Hi, what I was looking for, however, all a bit too fast for me to follow, specifically around the VBA part, will there be a longer simpler step by step video? I entered the VBA code in the right places i'm sure (pretty sure) and no errors but its just not working? Thanks
Sorry the speed was too fast for you to keep up. If it isn’t working, the code should be pasted into Microsoft Notepad first and then copied from there to the paste section mentioned in the video. 👍
I am not aware of a built in function for Outlook that takes into account holidays. Probably due to the great variance on observed holidays by company and country. It could be automated with VBA, but then it would have to be customized for each company or country so it isn't the best automation option. I think you will likely need to manual make those changes unfortunately. If you make several yearly recurring outlook emails, while it would take some initial effort this would make sure holidays were taken into consideration.
Hi. Thanks for this. However, it is not clear at what point the private subroutine is called in UseWord(). I run the code but nothing happens. Should I call Application_Reminder () in UseWord()? If yes, what is should be the argument Item?
Thanks for the code, I am still stuck, I get a run time error in the Model1 code - "Object variable or with block variable not set" at the point "Set Document = ins.WordEditor". Can anyone help
Hi Jonathan, Do you know if it is possible to create a recurring meeting that depends on other days with visual basic code? for example a meeting each Tuesday prior to the first Friday on each month. Someone could say to schedule a recurring meeting every 4 Tuesdays, or the first Tuesday of the month but this is not always true as the first Friday and the first Tuesday would not always be in the same week. I hope you see this
Thank you man! It really helped me! Just one thing, what if I want to format some text? The appointment saves the format (size, font, etc.), but when I receive the email, it's just plain text (it doesn't even saves the links). Do you know if it's possible to keep the format from the appointment?
Yes this is possible. Here is a link if you have some VBA background. If not I will add this to the list of future videos now that I am a bit less busy than I have been. docs.microsoft.com/en-us/office/vba/word/concepts/customizing-word/applying-formatting-to-text
@harshagrandhi9971 Seems this doesnt work for attachments. That includes "attachments" that are part of your signature. If you have a log picture that you are adding, try deleting that and retry. If someone has figured out how to add attachments please let us know. I didnt see it in any of the comments.
i'm slow and this was super fast. Took 5 minutes to even have a developer window open because that simple step was skipped. Go to "View" then "Code" or F7.
Hey Jonathan, this was really helpful, exactly what I was looking for. However, as I was following your steps, I created a test email and now I revive it everyday at 5pm. Can you help me undo the test one I did please? This was done following exactly the steps you show. Thanks
here is the trick go the code website copy the code paste it an email and then copy the code and paste it in your macro it works. directly copying the code from website to Vb doesn't work , thx
Got it to work, had to fix the quotes and for the attachment path error, the copy paste was putting spaces between the quotes and back slash on the filePath so removed those spaces: Private Sub Application_Reminder(ByVal Item As Object) Set olRemind = Outlook.Reminders Dim objMsg As MailItem Dim objApp As AppointmentItem Dim Att As Attachment Dim tmpFolder As String Dim filePath As String Set objMsg = Application.CreateItem(olMailItem) If Item.MessageClass "IPM.Appointment" Then Exit Sub End If If Item.Categories = "Send Schedule Recurring Email" Then tmpFolder = Environ("TEMP") 'tmpFolder = ("C:\TEMP") For Each Att In Item.Attachments filePath = tmpFolder & "\" & Att.FileName 'MsgBox (filePath) Att.SaveAsFile (filePath) objMsg.Attachments.Add filePath Kill filePath Next Att objMsg.CC = Item.Location objMsg.Subject = Item.Subject objMsg.Body = Item.Body objMsg.Send Set objMsg = Nothing ElseIf Item.Categories = "Recurring Email" Then 'tmpFolder = Environ("C:\TEMP") tmpFolder = ("C:\TEMP") For Each Att In Item.Attachments filePath = tmpFolder & "\" & Att.FileName Att.SaveAsFile (filePath) objMsg.Attachments.Add filePath Kill filePath Next Att objMsg.BCC = Item.Location objMsg.Subject = Item.Subject objMsg.Body = Item.Body objMsg.Send Set objMsg = Nothing ElseIf Item.Categories "Send Schedule Recurring Email" Then Exit Sub End If End Sub
One Note: the quotation marks in the code appear to not work well from Wordpress to Outlook and there also is a space appearing between the quotation marks and some of the symbols. If you get errors in the code once you paste the code and run it, remove the default quotation marks and then type the quotation marks back and those quotation marks should be accepted. Also remove spaces between quotation marks. Do this for each line with quotation marks and that should fix the issue.
Hi Jonathan, my code in the part: If Item.categories = "Send schedule recurring email" Then, got red font. what does it mean?
@@DiptaGhossan Hi Dipta, delete and retype the quotes at each end of every red line.
OMG!! I finally got it to work!! When copying the codes from the link paste the "text only" into an email then copy it to paste into the VBA. Multiple characters were causing a "Syntax error"
Thank you for this Johnathan! Being able to send myself a recurring email is freaking awesome!
Yes worth noting that a lot of the following characters: " or ' didn't paste correctly.
Many thanks, I lasted hours up to I saw you message :-)
This is an excellent presentation. Pace is perfect. For anyone not familiar with adding VBA coding some research is necessary for this exercise.
this....is so much more complicated than it should be to send a reoccuring email
what should take the place of ‘insert here your macro from word in the second code section?
Super helpful! I wanted to send one bi-monthly, fantastic help!
Where can i find the long video. My code isn't working
Hi Jonathan, I can't seem to paste the code. I would love to be able to do this. Your instructions are great until we get to the part I have to insert the code. Can you help?
Code #1 is below for "ThisOutlookSession" section (note: you will have to remove the "?" from the below code which youtube is adding to the code.) Go to the developer tab, then select "Visual Basic," then "ThisOutlookSession" is within the "Microsoft Outlook Objects" folder. That folder should appear there if you did the first part of the video correctly)
Private Sub Application_Reminder(ByVal Item As Object)
Set olRemind = Outlook.Reminders
Dim objMsg As MailItem
Dim objApp As AppointmentItem
Dim Att As Attachment
Dim tmpFolder As String
Dim filePath As String
Set objMsg = Application.CreateItem(olMailItem)
If Item.MessageClass "IPM.Appointment" Then
Exit Sub
End If
If Item.Categories = "Send Schedule Recurring Email" Then
tmpFolder = Environ("TEMP")
For Each Att In Item.Attachments
filePath = tmpFolder & "\" & Att.FileName
Att.SaveAsFile (filePath)
objMsg.Attachments.Add filePath
Kill filePath
Next Att
objMsg.CC = Item.Location
objMsg.Subject = Item.Subject
objMsg.Body = Item.Body
objMsg.Send
Set objMsg = Nothing
ElseIf Item.Categories = "Recurring Email" Then
tmpFolder = Environ("TEMP")
For Each Att In Item.Attachments
filePath = tmpFolder & "\" & Att.FileName
Att.SaveAsFile (filePath)
objMsg.Attachments.Add filePath
Kill filePath
Next Att
objMsg.BCC = Item.Location
objMsg.Subject = Item.Subject
objMsg.Body = Item.Body
objMsg.Send
Set objMsg = Nothing
ElseIf Item.Categories "Send Schedule Recurring Email" Then
Exit Sub
End If
End Sub
Here is code #2 (to put in module 1. You have to manually create a module. Just go to the developer tab, then select "Visual Basic," then select "Insert", then choose module and it will create module 1):
Public Sub UseWord()
Dim Ins As Outlook.Inspector
Dim Document As Word.Document
Dim Word As Word.Application
Dim Selection As Word.Selection
Set Ins = Application.ActiveInspector
Set Document = Ins.WordEditor
Set Word = Document.Application
Set Selection = Word.Selection
‘insert here your macro from word
End Sub
If those codes don't work after you paste them into the two respective locations I mentioned, wherever there is a quotation mark, delete the quotation mark and then add it back using your keyboard. Let me know if you still need any help.
I don't understand why these lines are red.....IF Item.Categories = “Send Schedule Recurring Email” Then
...its giving me an error saying Compile error- expected Then
Thank you so much, this video was very helpful
Hi there. This is showing as an error. Any ideas why? Att.SaveAsFile (filePath)
I have an issue with the row Att.SaveAsFile (filePath). It's yellow
I have the same issue. Have you resolved it?
@@Anna901020able Yes.
amanda brackett
2 weeks ago
OMG!! I finally got it to work!! When copying the codes from the link paste the "text only" into an email then copy it to paste into the VBA. Multiple characters were causing a "Syntax error"
Thank you for this Johnathan! Being able to send myself a recurring email is freaking awesome!
Johnathan - my Microsoft Outlook Objects - ThisOutlookSession is EMPTY - there is no code in it. Please advise
I am also getting the below error
Run-time error ‘-2147024893 (80070003) cannot save the attachment. Path does not exit verify the path is correct. Can you please help me on this too.
It is working for me, thank you very much.
Hi Jonathan I have a run-time error ‘-2147024893 (80070003) cannot save the attachment. Path does not exit verify the path is correct. Can you help me with this? Many thanks!
There is no options tab in the file drawer. How would I get to the developer panel from the Mac version of Outlook?
Hi Jonathan, Great presentation. I added all the coding into VBA and all looks good. Although, the email does not actually get sent through. I receive the actual notification but no email gets sent at all. I am not sure what is missing.
BUMP and ditto... Any thoughts Jonathan? I know it's been some time since you've posted this, but wanted to see if this would still be on your radar.
Thanks!
@@juancarlosathome101 In the outlook session you need to change the category name in two place, the one he mentions and there is another closer to the to top. Look for “Send Schedule Recurring Email” and change this to your category name as well.
@@sr_spongebob Hi Bob. Could you be more specific where the 2nd location is on the “appointment” window? One location is in the “categorise” on the ribbon, but where is the other?
@@sr_spongebob Any idea why this is returning an error? Att.SaveAsFile (filePath)
@@crescendo97 Hi! Have you corrected that error? I have that same Att.SaveAsFile (filePath) error!
Hi Jonathan, I get a Run Time Error 91 on the 2nd code Set Document = Ins.WordEditor?
Sorry it isn't working for you. I suggest double checking you updated all quotation marks (see my pinned comment).
i keep getting an error code 91 in the module part of the code could use some help
It is working fine. Thank ypu for the help. But in the email being sent the receipient mail is coming in CC but not in To section of the email. How to overcome this. Please help here.
how do you send it to a pre-set contact group instead of multiple emails in "location", especially there's not enough space? Please advice!
incase i set it up to start a week later and already save and close the email, what is happening to others whom i put the email in? do they receive email immediately? or just a placeholder in their calendar?
They will not receive any plaeholder on their calendar at all unless you invite them to the calendar event which you don't need to do. The event alert on your calendar is what sends the email to them. As long as there is no alert, the email will not be sent to them.
How can I get a copy of the VBA code in this tutorial?
Hi, everything seems OK, yet, when you are inserting the codes you shared, I did not see exactly where you inserted, since I have an error pop up on my screen, and the MS Visual Basic screen comes up and shows me the "TheOutlookSession" window where I inserted the big code. Obviously I am doing something wrong. Can you please help?
Best regards.
great , very helpful. How can you send an recurring email with attachment?
My first email in the series went out great but it was a daily recurrence and while I am getting the calendar notifications each day, the emails aren't going out each day like they did the first day. Any suggestions?
First, I would double check you saved the macro settings explained at the beginning of the video so that they always run. Also check the developer tab is showing up in Outlook. You can just review the start of the video. Second, make sure the notifications are set up and working for the recurring emails. Third, if those two checks are not the issue, verify your work hasn't blocked macros running in Outlook by asking someone in IT. I hope you are able to get it up and running.
Does it works when computer is closed? ( Outlook App is closed ) Will it send scheduled massage as soon as it will catch contact with internet?
Great Video ...this helped a lot
Hi, my recurring email is always sent twice. Why is that?
This is exactly what I am looking for. Thanks!
Questions: if I have 2 emails want to do the same thing, can I just put it on the same categorize or I have to do another coding parts?
@@chujunhuang566 you can use the same category format for a totally different email. All the category does is make sure an automated email is sent and will not send the same email if you change the email content you automate.
Do you know what I would need to change to make the emails sent out go as BCC rather than CC?
i have an error "91" on the line "set Document = Ins.WordEditor. can you help me?
What character is needed between multiple emails? I'm returning an error if it has more than 1 person
Semicolon
@@jonathandm9740 Thank you. I was able to do this function with power automate as well, which definitely has its capabilities
@@tjosi-1018 Very true about Power Automate - great to hear of someone taking initiative to figure out a task. I am sure you are a valuable employee at your work.
How do you send emails using BCC?
In the code where you see "CC", change it to "BCC" and it will send out emails as BCC
@@jonathandm9740 Thank you so much. I appreciate your help. We will begin using your codes and automation for our company. The recurring emails is very helpful.
@@aareliablehomehealthcare2532 One other potential suggestion if you will have multiple people sending out different emails that require slight modification. If you remove the line of code that says "objMsg.Send", it will set up a draft email automatically, but does not actually send it and gives anyone using the code one final chance to review before sending the email. I have had better success by having everything automated except adding a final manual review when I am not the one sending the email.
@@jonathandm9740 Ah, that is why I could not set it up on my colleages computer, what is the way around this? It works fine on my work computer, with the code and all, but could not get it to work on my colleages computer.
@@aareliablehomehealthcare2532 it should work fine on any computer. It's hard to say for sure without seeing their computer, but if you copied and pasted the exact same code you used for your colleage that worked for you but it isn't working for them, it likely means they don't have the right macro settings and the code isn't running as a result. I suggest having them review the first part of this video to make sure their settings are correct and they are using both sets of code. I also suggest reviewing my pinned comment in the comment section. I wish you guys well.
hi, this is great! where can i find the detailed version of this tutorial? i was met with a syntax error after following instructions and am wondering if the detailed version will help me better understand. Thanks!
My outlook doesn't have any code in the Project1 session. I followed everything you did to a T so I am confused
Double-click on Project1, or select View|Code
If I am understanding your question correctly (let me know if not) that code has to be pasted: 1wordsword.wordpress.com/2021/04/13/recurring-outlook-email-code/
Emails do not appear in 'SENT'. Be careful when testing and ensure to test on your own account first. I have just spent and hour trying to debug why my emails were not beign sent, only to find thatthey were (a dozen times :D) and there is no record in 'sent' box.
Hi, how does one make sure that the enabling / use of the Macros in Outlook is not going to compromise the Pc i.t.o security. We run Kaspersky Cloud + Suite and we dont want to create a risk from the inside w.r.t Macros but the video explanation is very good
Enabling macros doesn’t allow a stranger to paste code in Outlook and run a macro; it just means a macro can now be run in Outlook. Only the macros you set up in Outlook will run.
That said, anytime you copy and paste code instead of building it yourself, you should check to make sure there is nothing fishy with it. That is the one way you can easily get in trouble. In this case, I built most of the code and it is safe. Just be cautious if you decide to use any other code you find on the internet for Outlook. 👍
@@jonathandm9740 insert here your macro from word - This part in the smaller code section seems to hilight in red as a compile error and I dont see you refer to this in the video, pls advise which macro it is referring to
Also need to know how I edit the Outlook message being sent out or change recipients pls
this is sending recurring meeting/appointment. THis can easily be done without having to go through these complicated steps by simply go to meeting, set recurrance from there. However, this option is not available when sending as normal email.
You are right it is easy if you only want a recurring meeting or reminder. However this video teaches you how to add a code so the reminders actually generate recurring emails.
Where I find codes?
great!! But 'Location line where you enter email-Ids has limited size. can't enter more than 6 or 7 emails IDs. Any suggestions?
Create a custom contact group that includes all emails you want; the code can be modified where you put the custom group name in the location line and then you only need one email space. If you can't figure this out I may make a future video on how to do this.
@@jonathandm9740 Hi, I'm struggling to add group name, could you help here? Thank you so much.
Same struggle here - finished creating contact groups but how to “modify the code”? Please help I’ll wait here….
Super helpful, running into this issue too. How do we modify the macro?
what about for the newer version of outlook?
Not sure why it wouldn't work. I will have to get a hold of a newer version to test
Hi Johnathan, I have a shared inbox and calendar - is there a way to make it send from that? I have set up the appointment in that calendar but nothing is sent - it works if it comes from my personal outlook account. Thanks in advance.
is there a way to send the email to a pre-set group of members in outlook?
Have a distribution group created in O365? you may need to contact your IT support for that.
show the web app, many people don't use the desktop app
How do you set this up using multiple emails for different days and times? do you just add the category name to the one section in the code? so you would have two names there?
Hello,
I am not sure exactly what you mean, but I will try to answer:
1. If you want your recurring email sent to multiple people, just place a semicolon in between each person’s email in the “location” section
2. Once you have a named category like the one mentioned in video,, you can use that named category anytime you want to have a recurring email. Just select that category each time. If you have a different group of people you want each recurring email sent to, change the emails in the “location” section to the new people.
3. If you want to send the recurring email from multiple email accounts, you will need multiple outlook accounts.
@@jonathandm9740 sorry I mean like two separate reoccurring emails on separate days
@@kristymanley6129 no worries. Option 2 is the applicable part then. Create your name category, and then use that category for both separate emails on their separate days. Just change the customize the information in each email and the email recipients you want for each email and the days you want the recurring email to occur for each email.
Hi Jonathan, this is exactly what I've been looking for, I followed all instructions, fixed syntax errors. The reminder pops up as expected but email does not get sent. I'm using same Outlook version, not the newer one. Do you have any idea what can be the problem please? Many thanks
I'm having the same issue
Did you add the email address you want sent into the location section? Sorry if that question is obvious but just making sure all bases have been covered. 👍
Also make sure the name of your color coded notification is in the code as well. Either a different email in the code or a different name for the notification color than is in the code would cause the email not to be sent.
@@jonathandm9740 Hi Jonathan, I probably did not. Would you be able to advise at which point do I do that please. Thank you very much
@@jonathandm9740 Hi Jonathan, could you please create video for this part, because I too am not receiving any emails or notifications...
Hello Jonathan, This is a great tool, would make my life a heck of a lot easier. I've got to where I'm supposed to put in the code and I don't see it. I'm sorry If it is here and I don't see it. Help please! Thanks in advance for your help. AP
Here you go! 1wordsword.wordpress.com/2021/04/13/recurring-outlook-email-code/
Hi, what I was looking for, however, all a bit too fast for me to follow, specifically around the VBA part, will there be a longer simpler step by step video? I entered the VBA code in the right places i'm sure (pretty sure) and no errors but its just not working? Thanks
Sorry the speed was too fast for you to keep up. If it isn’t working, the code should be pasted into Microsoft Notepad first and then copied from there to the paste section mentioned in the video. 👍
Why is the code necessary? I did it without the code?
Nice! What did you do to create recurring emails that get sent by themselves each week or month without using code?
Where do I get the code to cut and past?
It's in the description above. Here is the link as well 👍 1wordsword.wordpress.com/2021/04/13/recurring-outlook-email-code/
What if the date is falling on a weekend or a Holiday?
I am not aware of a built in function for Outlook that takes into account holidays. Probably due to the great variance on observed holidays by company and country. It could be automated with VBA, but then it would have to be customized for each company or country so it isn't the best automation option. I think you will likely need to manual make those changes unfortunately. If you make several yearly recurring outlook emails, while it would take some initial effort this would make sure holidays were taken into consideration.
@@jonathandm9740 Thank you so much for taking out your time and answering it in detail..I truly appreciate it..Way to go 👍🏻
Hi. Thanks for this. However, it is not clear at what point the private subroutine is called in UseWord(). I run the code but nothing happens. Should I call Application_Reminder () in UseWord()? If yes, what is should be the argument Item?
Getting this error Compile error: syntax error.
Can you please advise how to fix this?
It highlighted the first row "Private Sub Application_Reminder(ByVal Item As Object)" in yellow and have an arrow on the left.
Remove the " and then add them in again, for some reason the characters are different
Thanks Zulekha. Yes, a good practice if a copy/paste doesn't work is to manual enter the non letter parts.
Thanks for the code, I am still stuck, I get a run time error in the Model1 code - "Object variable or with block variable not set" at the point "Set Document = ins.WordEditor". Can anyone help
Hi Jonathan, Do you know if it is possible to create a recurring meeting that depends on other days with visual basic code? for example a meeting each Tuesday prior to the first Friday on each month. Someone could say to schedule a recurring meeting every 4 Tuesdays, or the first Tuesday of the month but this is not always true as the first Friday and the first Tuesday would not always be in the same week. I hope you see this
Yes, this is possible. I have started both a side business and a new job, so have been busy, but if I have time I will make a video on this.
Thank you man! It really helped me! Just one thing, what if I want to format some text? The appointment saves the format (size, font, etc.), but when I receive the email, it's just plain text (it doesn't even saves the links). Do you know if it's possible to keep the format from the appointment?
Greetings from El Salvador!
Has anyone figured this out?
Yes this is possible. Here is a link if you have some VBA background. If not I will add this to the list of future videos now that I am a bit less busy than I have been. docs.microsoft.com/en-us/office/vba/word/concepts/customizing-word/applying-formatting-to-text
Getting this error Compile error: syntax error
@harshagrandhi9971 Seems this doesnt work for attachments. That includes "attachments" that are part of your signature. If you have a log picture that you are adding, try deleting that and retry. If someone has figured out how to add attachments please let us know. I didnt see it in any of the comments.
receiving syntax and compile errors
i'm slow and this was super fast. Took 5 minutes to even have a developer window open because that simple step was skipped. Go to "View" then "Code" or F7.
Hey Jonathan, this was really helpful, exactly what I was looking for. However, as I was following your steps, I created a test email and now I revive it everyday at 5pm. Can you help me undo the test one I did please? This was done following exactly the steps you show. Thanks
Here you go (it is also in description above): 👍👍1wordsword.wordpress.com/2021/04/13/recurring-outlook-email-code/
To fast to understand.
Too fast to understand.
@@jaquelinomassingue895 which part was confusing? That will help if I make a slower follow up video
here is the trick go the code website copy the code paste it an email and then copy the code and paste it in your macro it works. directly copying the code from website to Vb doesn't work , thx
Compile error: Expected: Then
i have the same error, how to fix?
@@wanazrie88 me too
Remove the " and then add them in again, for some reason the characters are different
@@RianZu7 Good find!
@@RianZu7 Thanks. Yes, a good practice if a copy/paste doesn't work is to manual enter the non letter parts.
Useless
Got it to work, had to fix the quotes and for the attachment path error, the copy paste was putting spaces between the quotes and back slash on the filePath so removed those spaces:
Private Sub
Application_Reminder(ByVal Item As Object)
Set olRemind = Outlook.Reminders
Dim objMsg As MailItem
Dim objApp As AppointmentItem
Dim Att As Attachment
Dim tmpFolder As String
Dim filePath As String
Set objMsg = Application.CreateItem(olMailItem)
If Item.MessageClass "IPM.Appointment" Then
Exit Sub
End If
If Item.Categories = "Send Schedule Recurring Email" Then
tmpFolder = Environ("TEMP")
'tmpFolder = ("C:\TEMP")
For Each Att In Item.Attachments
filePath = tmpFolder & "\" & Att.FileName
'MsgBox (filePath)
Att.SaveAsFile (filePath)
objMsg.Attachments.Add filePath
Kill filePath
Next Att
objMsg.CC = Item.Location
objMsg.Subject = Item.Subject
objMsg.Body = Item.Body
objMsg.Send
Set objMsg = Nothing
ElseIf Item.Categories = "Recurring Email" Then
'tmpFolder = Environ("C:\TEMP")
tmpFolder = ("C:\TEMP")
For Each Att In Item.Attachments
filePath = tmpFolder & "\" & Att.FileName
Att.SaveAsFile (filePath)
objMsg.Attachments.Add filePath
Kill filePath
Next Att
objMsg.BCC = Item.Location
objMsg.Subject = Item.Subject
objMsg.Body = Item.Body
objMsg.Send
Set objMsg = Nothing
ElseIf Item.Categories "Send Schedule Recurring Email" Then
Exit Sub
End If
End Sub
My hyper link is showing not just the hyperlink name. How can I fix this?