Add more code examples

[EitanBlumin]

Add more use cases under "Examples" (each one would need to be tested and verified first):

• Update existing event using various method types: REQUEST, ADD, REFRESH...
• Send HTML body using images uploaded with file_attachments
• Send TEXT body
• Example using SendGrid SMTP settings
• An example using default credentials
• Using profile_name to auto-complete SMTP settings
• Using ics_contents to send custom VCALENDAR document

[vhu408]

Hi Eitan,

Thanks for your work. Wonder if you can comment on the below and if there's something I'm doing wrong.

1.) I 've found that if I use an HTML body email
e.g..
declare @html nvarchar(max)=' ..

... '
exec sp_send_calendar_event
...
@Body=@html
...
GO
The result is an email msg not an event with an attached .ics file for the event (shows in the email as "not supported calendar message.ics") when the HTML is more "complex".. perhaps something to do with formatting(.. don't know.)

2.) I've found that if I use an HTML body that makes use of a CID image (and thus the image is attached..)
E.g..
declare @html nvarchar(max)=' ..... '
exec sp_send_calendar_event
...
@Body=@html,
@file_attachments = 'd:\dir1\picture.png'
...
GO
The result is merely an email msg, even the .ics attachment is missing.

It seems like an event is not created when the HTML is more "complex" or an attachment of any kind if included. And even with the emails (not events), the .ics file is sometime present and sometimes depending on if an attachment is included.

[EitanBlumin]

Thanks, @vhu408 .
I created a separate issue for you: #16
Let's continue correspondence there.