HTML and attachments interoperability #16
Description
Originally posted by @vhu408 in #10 (comment)
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)='<html> ..<table>...</table> </html>'
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)='<html> ..... </html>'
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.