Send Meet Invites From Excel (via Outlook)

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024

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

  • @mostafaza250
    @mostafaza250 5 месяцев назад

    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  5 месяцев назад

      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 5 месяцев назад

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

    • @ExcelMacroMania
      @ExcelMacroMania  5 месяцев назад

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

  • @mohanedalwhaibi576
    @mohanedalwhaibi576 5 месяцев назад

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

    • @ExcelMacroMania
      @ExcelMacroMania  5 месяцев назад

      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 5 месяцев назад

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

    • @ExcelMacroMania
      @ExcelMacroMania  5 месяцев назад

      @@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 5 месяцев назад +1

      @@ExcelMacroMania oh thanks bro already solved the problem