Send Meet Invites From Excel (via Outlook)

Поделиться
HTML-код
  • Опубликовано: 23 июл 2024
  • Excel macro/VBA code available in this post: excelmacrobusiness.blogspot.c...
    We can integrate Excel with other Microsoft Office applications using VBA. In this video we see how to send meet invites from Excel and via Outlook using VBA macros. The macro automatically creates an appointment item and defines the properties to create a meet invite in the recipient's calendar.
    You can find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners) in the blog under the link: excelmacroclass.blogspot.com
    And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
    Excel Macro Fun (excelmacrofun.blogspot.com/)
    Excel Macro Business (excelmacrobusiness.blogspot.com/)
    Excel Macro Sports (excelmacrosports.blogspot.com/)

Комментарии • 9

  • @mostafaza250
    @mostafaza250 21 день назад

    Hello I needed his services when I came to create a Google form with images that showed the images with a title Url I need it to show me the pictures inside the cell. Can I do that?

    • @ExcelMacroMania
      @ExcelMacroMania  20 дней назад

      Not sure I understand what you want to do. Does that really have something to do with sending meet invites? or is it something completely different? Because this video is just about sending meet invites from Excel.

  • @alexf2863
    @alexf2863 22 дня назад

    How do i put mail in "CC" ? Thanks 🙏🏻

    • @ExcelMacroMania
      @ExcelMacroMania  20 дней назад

      OutInvite.OptionalAttendees = "optional1@outlook.com;optional2@outlook.com"

  • @mohanedalwhaibi576
    @mohanedalwhaibi576 28 дней назад

    hi dear i have a question how can i add the my special email signature to the macro regards

    • @ExcelMacroMania
      @ExcelMacroMania  28 дней назад

      Here's how you do it for an email. If you want to do add it to the invite just replace OutMail with OutInvite as defined in this video.
      With OutMail
      .Display
      signature = .HTMLBody
      .To = "recipientemail@outlook.com"
      .Subject = "email subject"
      body = "Dear Customer,... bla bla"
      .HTMLBody = body & signature
      '.Send 'uncomment to send
      End With

    • @mohanedalwhaibi576
      @mohanedalwhaibi576 28 дней назад

      @@ExcelMacroMania .HTMLBody doesn't show in my macro

    • @ExcelMacroMania
      @ExcelMacroMania  23 дня назад

      @@mohanedalwhaibi576 Make sure you add the Outlook library to references and declare OutMail as MailItem, then when OutMail.HTMLBody would get or set the whole body as HTML.

    • @mohanedalwhaibi576
      @mohanedalwhaibi576 23 дня назад +1

      @@ExcelMacroMania oh thanks bro already solved the problem