Note: The other languages of the website are Google-translated. Back to English
로그인  \/ 
x
or
x
Register  \/ 
x

or

Outlook에서 일정 반복 이메일을 보내는 방법은 무엇입니까?

Microsoft Outlook에서는 반복되는 약속, 회의 또는 작업을 다른 사람에게 쉽게 보낼 수 있습니다. 그러나 약속, 회의 또는 작업없이 일정 반복 이메일 만 보내고 싶다면 어떻게 할 수 있습니까? 불행히도 Outlook은 일정 반복 이메일을 보내는 기능을 제공하지 않지만 자습서에서는 Outlook에서 일정 반복 이메일을 보내는 방법을 보여줍니다.

VBA 코드로 Outlook에서 일정 반복 이메일 보내기

놀라운 도구를 사용하여 Outlook에서 일정 반복 이메일을 쉽게 보낼 수 있습니다.


VBA 코드로 Outlook에서 일정 반복 이메일 보내기

이 튜토리얼은 네 부분으로 나뉘며,이 부분을 마친 후에는 일정 반복 이메일을 성공적으로 보낼 수 있습니다. 다음과 같이하십시오.

1부: 새 약속 만들기

1. 다음으로 이동하십시오. 학교 캘린더 클릭하여보기 학교 캘린더 에서 탐색 창을 클릭 한 다음 클릭하여 새 약속을 만듭니다. 신임 아래에 Home 탭.

3. 에서 약속 아래의 대화 약속 탭. 다음을 수행해야합니다.

A : 제목 B : 수신자의 이메일 주소를 촬영장소 대여
C : 구성 시작 시간 그리고 종료 시간 D : 아래에서 미리 알림을 선택합니다. 알림 드롭 다운 목록.
15 분을 선택하면 이메일이 전송 될 때 15 분 일찍 알려줍니다.
E : 약속 본문을 작성하십시오.

주의 사항다음 약속 주제 되풀이되는 이메일 제목이됩니다. 그리고 임명 기관 수신자가 이메일을 수신하면 반복 이메일 본문이됩니다.

2부: 새 범주 만들기

이제 ""라는 새 범주를 만들어야합니다.일정 반복 이메일 보내기”다음과 같습니다.

1. 에서 약속 대화 상자를 클릭하십시오 분류 > 전체카테고리 에서 태그 아래 그룹 약속 탭.

2. 때 색상 카테고리 대화 상자가 나타나면 클릭하십시오 신규클래스 단추. 에서 새 카테고리 추가 대화 상자에서“일정 반복 이메일 보내기" 안에 성함 들; 그런 다음 색상 드롭 다운 목록. 그런 다음 OK.

3. 그러면 "일정 반복 이메일 보내기”범주가 나열되면 확인란을 선택한 다음 OK 버튼을 클릭합니다.

3부: 반복 설정

이제 약속의 반복을 설정할 시간입니다.

1. 클릭 회귀 에서 옵션 중 아래 그룹 약속 탭. 스크린 샷보기 :

2. 에서 약속 반복 대화 상자, 구성 회귀 무늬. 종료 시간이 필요한 경우 아래에서 구성하십시오. 재발 범위. 그런 다음 OK.

3.로 돌아갈 때 약속 대화 상자를 클릭하십시오 저장 후 닫기 단추. 스크린 샷보기 :

파트 4: 일정 되풀이 전자 메일 보내기에 VBA 코드 사용

1. 누르십시오 다른 + F11 를 열려면 응용 프로그램 용 Microsoft Visual Basic 대화.

2. 더블 클릭 Project1 > Microsoft Outlook 개체 > ThisOutlookSession 왼쪽 창에서. 스크린 샷보기 :

3. 다음 VBA 코드를 복사하여 VBA 편집기에 붙여 넣습니다. 그런 다음 찜하기 버튼을 클릭합니다.

VBA : 일정 반복 이메일 보내기

Private Sub Application_Reminder(ByVal Item As Object)
'Updated by Extendoffice 20200522
Dim xMailItem As MailItem
Dim xItemDoc As Word.Document
Dim xNewDoc As Word.Document
Dim xFldPath As String
On Error Resume Next
If Item.Class <> OlObjectClass.olAppointment Then Exit Sub
If Item.Categories <> "Send Schedule Recurring Email" Then Exit Sub
Set xMailItem = Outlook.Application.CreateItem(olMailItem)
Set xItemDoc = Item.GetInspector.WordEditor
xFldPath = CStr(Environ("USERPROFILE"))
xFldPath = xFldPath & "\MyReminder"
If Dir(xFldPath, vbDirectory) = "" Then
    MkDir xFldPath
End If
xFldPath = xFldPath & "\AppointmentBody.xml"
xItemDoc.SaveAs2 xFldPath, wdFormatXMLDocument ' wdFormatXML
Set xNewDoc = xMailItem.GetInspector.WordEditor
VBA.DoEvents
xNewDoc.Application.Selection.HomeKey
xNewDoc.Activate
xNewDoc.Application.Selection.InsertFile FileName:=xFldPath, Attachment:=False
With xMailItem
    .To = Item.Location
    .Recipients.ResolveAll
    .Subject = Item.Subject
    .Send
End With
Set xMailItem = Nothing
VBA.Kill xFldPath
End Sub

4. 클릭 도구 > 참조 를 열려면 참조 -프로젝트 대화. 대화 상자에서 Microsoft Word 개체 라이브러리 옵션을 클릭하고 OK 버튼을 클릭합니다.

5. 누르세요 다른 + Q 닫는 동시에 키 응용 프로그램 용 Microsoft Visual Basic 창.

알림 팝업이 나타나면 첫 번째 부분의 위치 필드에 입력 한 수신자에게 이메일이 자동으로 전송됩니다. 그런 다음 알림닫기 에서 알림 대화. 그리고 이메일은이 시간에 매일 반복적으로 전송됩니다. 스크린 샷보기 :

주의 사항: VBA 코드는 Outlook 2010 이상 버전에서 성공적으로 테스트되었습니다.


놀라운 도구를 사용하여 Outlook에서 일정 반복 이메일을 쉽게 보낼 수 있습니다.

많은 Outlook 사용자에게 위의 방법은 올바르게 처리하기에는 너무 지루합니다. 여기 적극 추천합니다 자동 전송 예약 특징 Outlook 용 Kutools. 이 기능을 사용하면 여러 개의 되풀이 전자 메일을 쉽게 만들고 필요에 따라 이러한 전자 메일을 매일, 매주, 매월 또는 매년 정기적으로 보내도록 예약할 수 있습니다. 완료하려면 다음을 수행하십시오.

이 링크를 방문하십시오. Outlook 용 Kutools 다운로드 그리고 시도해보십시오.

1. 클릭 쿠툴 > 자동 전송 예약 > 자동 전송 일정 만들기.

2. 그런 다음 메시지 창이 열리고 다음을 수행해야 합니다.

2.1) 이메일 수신자 선택 까지, 참조 or 숨은 필요에 따라 필드를 입력한 다음 이메일을 입력합니다. 주제;
2.2) 이메일 본문을 작성하십시오.
2.3) 클릭 회귀 아래 Kutools 반복 탭. 스크린 샷보기 :

3. 이제 이메일 반복 대화 상자가 나타나면 다음을 지정해야 합니다. 반복 시간, 되풀이 패턴 그리고 재발 범위 이메일에 대해 다음을 클릭합니다. OK 버튼을 클릭합니다.

4. 이제 메시지 창으로 돌아갑니다. 저장 후 닫기 버튼을 눌러 반복 설정을 저장하고 창을 닫습니다.

팁 : 위의 1~4단계를 반복하여 필요에 따라 여러 개의 반복 이메일을 생성할 수 있습니다.

5. 이제 다음을 클릭하여 기능을 켭니다. 쿠툴 > 자동 전송 예약 > 사용하도록 설정합니다.

6. 오프닝에서 Outlook 용 Kutools 대화 상자에서 좋아요.

위의 설정을 완료한 후 지정된 날짜와 시간이 되면 자동으로 반복 메일이 발송됩니다.

참고 : 다음과 같이 반복 메일을 쉽게 관리할 수 있습니다.

1. 클릭 쿠툴 > 자동 전송 예약 > 자동 전송 일정 관리.

2. 에서 자동 전송 일정 관리 창, 당신은 만들 수 있습니다 새로운 반복 이메일, 수정, 삭제, 켜다 or 오프 필요에 따라 기존 되풀이 이메일. 또는 다음을 클릭할 수 있습니다. 로그 아이콘을 클릭하여 반복되는 이메일의 전송 기록을 봅니다.

이 기능에 대해 자세히 알아 보려면 클릭하십시오..

  Outlook 용 Kutools Microsoft Outlook을 위한 100개 이상의 강력한 기능이 포함되어 있습니다. 60일 동안 제한 없이 무료로 사용해 보세요. 다운로드!


Outlook 용 Kutools-Outlook에 100 개의 고급 기능을 제공하고 작업을 훨씬 더 쉽게 만듭니다!

  • 자동 CC / BCC 이메일을 보낼 때 규칙에 따라; 자동 전달 사용자 정의에 의한 여러 이메일; 자동 회신 교환 서버없이 더 많은 자동 기능 ...
  • BCC 경고 -모두 답장하려고 할 때 메시지 표시 메일 주소가 숨은 참조 목록에있는 경우; 첨부 파일 누락시 알림및 기타 알림 기능 ...
  • 메일 대화에서 모든 첨부 파일로 (전체) 회신; 많은 이메일에 답장 초 안에; 인사말 자동 추가 대답 할 때; 제목에 날짜 추가 ...
  • 첨부 도구 : 모든 메일의 모든 첨부 파일 관리, 자동 분리, 모두 압축, 모두 이름 바꾸기, 모두 저장 ... 빠른 보고서, 선택한 메일 수...
  • 강력한 정크 메일 관습에 의해; 중복 메일 및 연락처 제거... Outlook에서 더 스마트하고 빠르며 더 나은 작업을 수행 할 수 있습니다.
샷 kutools 전망 kutools 탭 1180x121
샷 kutools 전망 kutools 플러스 탭 1180x121
 
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    RodmanB · 14 days ago
    I followed the instruction in this article "How to send a schedule recurring email in Outlook" multiple times, to no avail. I get the popup reminder box but, the e-mail is never sent. I've tried with Kutools for Outlook installed and uninstalled. Still no success in sending a scheduled recurring email in Outlook.

    Thanx,
    RLB
    • To post as a guest, your comment is unpublished.
      tarnold · 13 days ago
      I have had the same situation. It was working fine for almost a year and then suddenly stopped working. I've tried recopying the code, delete it completely and start over. Same results- popup reminder box happens, I click ok, and the email is never sent.
      • To post as a guest, your comment is unpublished.
        crystal · 13 days ago
        Hi tarnold,
        Make sure that the category name you created in step 2 is the same as the name specified in the code.
        Can you try the VBA below and give me feedback on error you encountered later? Because this problem needs to be reproduced in my case. Or you can also try the third party tool mentioned in the post. Sorry for the inconvenience.

        Private Sub Application_Reminder(ByVal Item As Object) 'Updated by Extendoffice 20220114 Dim xMailItem As MailItem Dim xItemDoc As Word.Document Dim xNewDoc As Word.Document Dim xFldPath As String If Item.Class <> OlObjectClass.olAppointment Then Exit Sub If Item.Categories <> "Send Schedule Recurring Email" Then Exit Sub Set xMailItem = Outlook.Application.CreateItem(olMailItem) Set xItemDoc = Item.GetInspector.WordEditor xFldPath = CStr(Environ("USERPROFILE")) xFldPath = xFldPath & "\MyReminder" If Dir(xFldPath, vbDirectory) = "" Then MkDir xFldPath End If xFldPath = xFldPath & "\AppointmentBody.xml" xItemDoc.SaveAs2 xFldPath, wdFormatXMLDocument ' wdFormatXML Set xNewDoc = xMailItem.GetInspector.WordEditor VBA.DoEvents xNewDoc.Application.Selection.HomeKey xNewDoc.Activate xNewDoc.Application.Selection.InsertFile FileName:=xFldPath, Attachment:=False With xMailItem .To = Item.Location .Recipients.ResolveAll .Subject = Item.Subject .Send End With Set xMailItem = Nothing VBA.Kill xFldPath End Sub
      • To post as a guest, your comment is unpublished.
        RodmanB · 13 days ago
        At least yours work for a while. Mine never worked. Contacted Support and was told to post here. I suppose we'll have to wait on the author to respond.
        • To post as a guest, your comment is unpublished.
          crystal · 13 days ago
          Hi RodmanB,
          Can neither of the two methods described in the article solve the problem?
          VBA code and Kutools for Outlook are two different ways to handle the task.
          I need to know more specific about your issue, such as your Excel version.
          • To post as a guest, your comment is unpublished.
            tarnold · 12 days ago
            Hi Crystal,

            I am using MSOffice 365 for all of the Office products- Outlook, Excel, etc. As I posted 6month ago, it was working fine with my previous MSOffice desktop software.  When I switched to Office 365, it stopped working and I am having the same/similar situation as RodmanB.  The reminder popup occurs, I dismiss it and nothing happens.  The email is not in the draft folder, not in the sent folder, nothing.
          • To post as a guest, your comment is unpublished.
            RodmanB · 13 days ago
            Crystal,
               Thanks for help. I replaced the VBCode and made a different test email. It preformed just as the other; reminder pops up, .wav file plays but the email is not sent. I'll install Kutools for Outlook and try that way tomorrow and, will respond with results.
            • To post as a guest, your comment is unpublished.
              RodmanB · 12 days ago
              Crystal,
                 Unable to install Kutool for outlook, demo license expired. Not willing to buy  just to debug this feature. So, have a great day and thanks for the help.

              Thanx,
              RLB
  • To post as a guest, your comment is unpublished.
    Saúl · 16 days ago
    Hi have implemented this and there's a couple of issues.
    1 - if i don't have Outlook opened, the email is not sent --> i guess this is normal, not a big deal anyway.
    2 - even the appointment appears just once a day and the email sent properly then, i see that the email is sent randomly other extra times during the day. For example, my schedule is daily at 9:00 and this is sent at 9:00 (OK) and also at 17:13 (NOK). I am not being able to identify why, any idea?

    thanks.
  • To post as a guest, your comment is unpublished.
    J · 3 months ago
    What would the VBA code be for this but sending from the recipients of the appointment, not the "location" of the appointment as coded above? I need to send to 20+ people and cannot add enough names as the location fields is limited on characters. Many thanks
    • To post as a guest, your comment is unpublished.
      crystal · 13 days ago
      Hi J,
      You can try the second method "the Schedule auto send feature of Kutools for Outlook" mentioned in the post.
  • To post as a guest, your comment is unpublished.
    SM · 5 months ago
    If you are having trouble with the email not sending after you get the reminder, look in your drafts folder. If the email is there then go back to the categories step and change the category to "Send Scheduled Recurring Email". The original instructions read "schedule" and not "scheduled". As soon as I did this, Outlook sent the email from my drafts folder and everything worked.
    • To post as a guest, your comment is unpublished.
      Uri · 2 months ago
      This worked for me too! thanks!
  • To post as a guest, your comment is unpublished.
    JM · 6 months ago
    hello, thank you this great code! It works like a charm. Is it possible to format the body of the email for HTML format?

  • To post as a guest, your comment is unpublished.
    Durgeshwaran N · 6 months ago
    I tried the above VBA Code, I am getting reminder everytime,
    But receipient does not receive my mail,
    Please assist
  • To post as a guest, your comment is unpublished.
    tarnold · 6 months ago
    I had a 2016 desktop version and everything worked great. I switched to Office 365 and it stopped working. Is there a setting (VBA Code?) that needs to be changed?
    Anyone else having this problem?
  • To post as a guest, your comment is unpublished.
    Günter · 7 months ago
    I'm useing a german Version of outlook. Whats i have to change in the VBA-code?

  • To post as a guest, your comment is unpublished.
    Mabpetroc · 7 months ago
    For me.  I needed to add 2x : 

    If Item.Class <> OlObjectClass.olAppointment Then 
    End If

    If Item.Categories <> "Send Schedule Recurring Email" Then Exit Sub
    End If

  • To post as a guest, your comment is unpublished.
    Prateek · 7 months ago
    how to add CC and BCC
  • To post as a guest, your comment is unpublished.
    pheadjack75 · 8 months ago
    this saves the email into the Drafts folder without a header or timestamp. How do I get it to include that header and timestamp; and saved in the Sent folder ?
  • To post as a guest, your comment is unpublished.
    Raj · 9 months ago
    I am facing issue with Email Body. in my received email it completely blank. what could be wrong
    • To post as a guest, your comment is unpublished.
      Natalia · 7 months ago
      Same for me, I don't know how to fix it 
      • To post as a guest, your comment is unpublished.
        Mabpetroc · 7 months ago
        scroll down - the question has been covered. :-)
  • To post as a guest, your comment is unpublished.
    JayPie · 10 months ago
    Is there a way to modify the code to only send the email if you hit "dismiss" and don't send the email if you "dismiss all" or some other button?
    I want to be able to chose each day if I send the email, but still want to be reminded each day.
    • To post as a guest, your comment is unpublished.
      Ryan Vargas · 4 months ago
      Would like to know this as well.
  • To post as a guest, your comment is unpublished.
    rayray4105 · 11 months ago
    For me the VBA halted on 'CStr(Environ("USERPROFILE"))'.

    I have moved both lines starting with 'xFldPth' just below 'On Error Resume Next' which resulted in the code to be fully executed
  • To post as a guest, your comment is unpublished.
    katie · 1 years ago
    This was working for me for several months. All of the sudden, the reminders are still appearing, but the emails are no longer being sent. Any ideas?
    • To post as a guest, your comment is unpublished.
      Fishy · 1 years ago
      Same here. Have you found what make it stop working?
    • To post as a guest, your comment is unpublished.
      FishyD · 1 years ago
      Same here, it was working great and over the last day or so, just broke.
  • To post as a guest, your comment is unpublished.
    Sohail · 1 years ago
    I am using Office 2016. I am unable to click on CATEGORIZE when doing through NEW APPOINTMENT but Categorize function properly when using NEW EMAIL.
  • To post as a guest, your comment is unpublished.
    Julia · 1 years ago
    Hi. How do I add attachments? I need to pull specific files each month and attach to the email. Is there a way to do this?
    • To post as a guest, your comment is unpublished.
      Matt · 5 months ago
      Private Sub Application_Reminder(ByVal Item As Object)
      'Updated by Extendoffice 20200522
      Dim xMailItem As MailItem
      Dim xItemDoc As Word.Document
      Dim xNewDoc As Word.Document
      Dim xFldPath As String
      On Error Resume Next
      If Item.Class <> OlObjectClass.olAppointment Then Exit Sub
      If Item.Categories <> "Send Schedule Recurring Email" Then Exit Sub
      Set xMailItem = Outlook.Application.CreateItem(olMailItem)
      Set xItemDoc = Item.GetInspector.WordEditor
      xFldPath = CStr(Environ("USERPROFILE"))
      xFldPath = xFldPath & "\MyReminder"
      If Dir(xFldPath, vbDirectory) = "" Then
      MkDir xFldPath
      End If
      xFldPath = xFldPath & "\AppointmentBody.xml"
      xItemDoc.SaveAs2 xFldPath, wdFormatXMLDocument ' wdFormatXML
      Set xNewDoc = xMailItem.GetInspector.WordEditor
      VBA.DoEvents
      xNewDoc.Application.Selection.HomeKey
      xNewDoc.Activate
      xNewDoc.Application.Selection.InsertFile FileName:=xFldPath, Attachment:=True
      With xMailItem
      .To = Item.Location
      .Recipients.ResolveAll
      .Subject = Item.Subject
      .Send
      End With
      Set xMailItem = Nothing
      VBA.Kill xFldPath
      End Sub
  • To post as a guest, your comment is unpublished.
    Phoebe · 1 years ago
    The emails are being generated but are going to draft folder and not being sent out automatically. How would I fix this?
  • To post as a guest, your comment is unpublished.
    Tellett · 1 years ago
    This didn't work for me until I realized that naming the category "Send Scheduled Recurring Email" instead of "Send Schedule Recurring Email" mattered. It was a comment below that brought it to my attention. Thanks!
  • To post as a guest, your comment is unpublished.
    yang · 1 years ago
    Doesn't work for Outlook 2016
  • To post as a guest, your comment is unpublished.
    Tony · 1 years ago
    I followed the instructions, but I get a .dll error when I check microsoft word 16.0 object library. I don't know if it matters, but the other object libraries show up as 14.0
  • To post as a guest, your comment is unpublished.
    Terri · 1 years ago
    often the location bar is unable to contain all of the email addresses for me, I can certainly use a distribution list or group contact but how do I unpack it so the resulting email shows the addresses individually?
  • To post as a guest, your comment is unpublished.
    sangeeta · 1 years ago
    It worked very well with MS Office 365 -outlook but then stopped working. I cant figure out what changed. Did anyone else run into similar problem? Any suggestion on how to debug what is going on?
  • To post as a guest, your comment is unpublished.
    ofek · 1 years ago
    I can confirm it works on Outlook 2019 as well
  • To post as a guest, your comment is unpublished.
    Kristen · 1 years ago
    Hi, been using this without issue for a few years. Suddenly in the last couple of months, it stopped sending the email. Reminder still goes out to me at least. I came here and and see the code has been updated, which I did and now I get "userdefined type not identified" error that others seem to have gotten. Is there a fix for this or no?
  • To post as a guest, your comment is unpublished.
    odhinto@gmail.com · 1 years ago
    I have followed all the instructions: I enabled Macros; I configured the appointment as instructed and added the VBA Macro....I checked all the references as instructed.
    The email is not being sent, and I'm not getting any compiler errors. What could be the problem? I'm using Outlook 2016.
    • To post as a guest, your comment is unpublished.
      Ricky · 1 years ago
      I can't get it to work either in Outlook 2016
  • To post as a guest, your comment is unpublished.
    Andrey · 1 years ago
    Is there a way to send the email from certain different e-mail (SendAs or SendOnBehalfOfName)?
  • To post as a guest, your comment is unpublished.
    Scott · 1 years ago
    Every time any reminder pops up, i am getting a VBA error of "userdefined type not identified".
    • To post as a guest, your comment is unpublished.
      Jon · 1 years ago
      Pardon me if this is something you already know, but without having other details besides what you posted, I suggest you make sure both microsoft office 16.0 object library AND microsoft word 16.0 object library are selected from step 4 above.
      • To post as a guest, your comment is unpublished.
        Uri · 2 months ago
        This worked for me - thanks!
      • To post as a guest, your comment is unpublished.
        Nicola · 1 years ago
        This worked for me thank you

  • To post as a guest, your comment is unpublished.
    joaquimlmpires@gmail.com · 1 years ago
    Hi. I know this is an old post but I'm trying to use it to send a periodic email.

    I'm able to complete all the steps but the code line:
    Dim xItemDoc As Word.Document
    prompts a compile error: "userdeffined type not defined "

    I replaced with:
    Dim xItemDoc As DocumentItem

    compiles ok but emai does not get sent.

    anyone can help?

    thank you
  • To post as a guest, your comment is unpublished.
    Ron · 1 years ago
    I get the reminder but no email, ideas?
    • To post as a guest, your comment is unpublished.
      Scott · 1 years ago
      Same issue here
  • To post as a guest, your comment is unpublished.
    Marjorie · 1 years ago
    I received the email, however the body of the email is blank. I have put text and a signature in the body but when the email comes the body of the email is blank.
    • To post as a guest, your comment is unpublished.
      Jarrett · 1 years ago
      Try adding ".Body = Item.Body" under the line ".Subject = Item.Subject" in the VBA Code mentioned in this article.
      • To post as a guest, your comment is unpublished.
        Tony Fecteau · 1 years ago
        I have same issue, where on the code we have to adding
        ".Body = Item.Body" under the line ".Subject = Item.Subject"
        • To post as a guest, your comment is unpublished.
          Marcio Filho · 10 months ago
          Thank you very much Tony, you helped me a lot :D
  • To post as a guest, your comment is unpublished.
    Katie · 2 years ago
    I have followed all instructions and made sure the object library was checked etc but get the error 'compile error user type not defined' when it's time for the reminder.
    Any solutions to this?

    Thanks!
    • To post as a guest, your comment is unpublished.
      Mads · 1 years ago
      I get the same error. What's the solution here?
  • To post as a guest, your comment is unpublished.
    Vinay · 2 years ago
    It worked for me on Testing but when I made the changes to send it actually it didn't worked. Is there any specific modifications I needed to make? I see my Macro is disabled but it's on office system so I can't change it but assuming it worked for the first time it should work alright again; right?
  • To post as a guest, your comment is unpublished.
    tricia · 2 years ago
    how can this be sent to emails that change on a weekly basis?
    • To post as a guest, your comment is unpublished.
      OrionStar · 2 years ago
      If they change every week then it's not able to work really. What changes? if it's an attached file that should be fine because it grabs the file each time.
  • To post as a guest, your comment is unpublished.
    anne · 2 years ago
    this is not working for me
  • To post as a guest, your comment is unpublished.
    Sai Swaroop · 2 years ago
    I Tried using the above code it works very fine. But the problem is in the body of the email I am including Pictures, text and Hyperlinks to that. By the time mail reaching to the receiver everything is converting as a Text. Can anyone help me on this
    • To post as a guest, your comment is unpublished.
      crystal · 2 years ago
      Hi,
      Sorry for the inconvenience. The code has been updated to solve the problem. Please have a try and thank you for your comment.
      • To post as a guest, your comment is unpublished.
        Vinodh Kumar · 1 years ago
        Hi,
        I am facing the same issue. can you please post the updated code.

        Also is there any way to include email address as CC ?

  • To post as a guest, your comment is unpublished.
    Aarti · 2 years ago
    superb works for me thanks yaa
  • To post as a guest, your comment is unpublished.
    Priyank · 2 years ago
    It did work on my laptop before. I somewhat messed up my VBA. now it's not working..
    How do I restart of clear my VBA?

    I am not a programmer. I just wanted automatic email generated and googled it. Tried various things and then came across this post.

    It really worked well before. Please help
  • To post as a guest, your comment is unpublished.
    aerin.melvin@gmail.com · 2 years ago
    How do you add an attachment to go with the email that is sent?
  • To post as a guest, your comment is unpublished.
    Aerin · 2 years ago
    Is there a way to make this BCC?
  • To post as a guest, your comment is unpublished.
    Jan · 2 years ago
    I got to the VBA code copied, pasted, and saved fine. But no reminder popped up for me to dismiss. Will this still send?
    • To post as a guest, your comment is unpublished.
      crystal · 2 years ago
      Hi Jan,
      Please go to the Sent Items folder to check for the sending email.
  • To post as a guest, your comment is unpublished.
    Tomy · 2 years ago
    It's great work, tks
  • To post as a guest, your comment is unpublished.
    john · 2 years ago
    This is limited on the number of email addresses you can add in the locations. Any work arounds?
  • To post as a guest, your comment is unpublished.
    Kevin · 2 years ago
    This still works. Just tested on Office 2016/ O365. Make sure macros are enabled. Make sure you are pasting the code under "application" and "Reminder" as shown in the screen shot.
    • To post as a guest, your comment is unpublished.
      Daniele · 2 years ago
      Good, now it works!
      I've just one problem. If my Outlook client application is close, it don't work ...any solutions?
  • To post as a guest, your comment is unpublished.
    anitanashgh · 2 years ago
    I am getting a "compile error: invalid outside procedure" every time ANY reminder pops up, not just the one's for the scheduled send. Also, my scheduled send doesn't work. Any ideas? I copied and pasted the code from above. Thanks.
  • To post as a guest, your comment is unpublished.
    Anita · 2 years ago
    Not working for me.... :(
  • To post as a guest, your comment is unpublished.
    Kathrin · 3 years ago
    It didn't work for me either :/.Is there any update available?
  • To post as a guest, your comment is unpublished.
    Simon Hogh · 3 years ago
    This still works? :D
  • To post as a guest, your comment is unpublished.
    Simon · 3 years ago
    Does this still work? Unfortunately it doesn#t work for me...
  • To post as a guest, your comment is unpublished.
    SS · 3 years ago
    Does this go out as an invite? Does the recipient have to accept the invite?
    • To post as a guest, your comment is unpublished.
      Rebeccah · 2 years ago
      It's in the location field rather than in an invitee field, so, no - no invite goes out to the location address(es). No reminders to the location address(es) normally, either. This code is triggered by the application_reminder event for this appointment and adds functionality to it, to

      - create an e-mail message

      - put the appointment location address(es) in the To field of the e-mail message.

      - put the appointment subject line in the Subject field of the e-mail message.

      - put the appointment body in the Body field of the e-mail message.

      - send the e-mail message.