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/)
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?
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.
How do i put mail in "CC" ? Thanks 🙏🏻
OutInvite.OptionalAttendees = "optional1@outlook.com;optional2@outlook.com"
hi dear i have a question how can i add the my special email signature to the macro regards
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
@@ExcelMacroMania .HTMLBody doesn't show in my macro
@@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.
@@ExcelMacroMania oh thanks bro already solved the problem