Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

HTML and attachments interoperability #16

Open
EitanBlumin opened this issue Apr 16, 2020 · 1 comment
Open

HTML and attachments interoperability #16

EitanBlumin opened this issue Apr 16, 2020 · 1 comment
Assignees
@EitanBlumin
Labels
bug Something isn't working help wanted Extra attention is needed
Milestone
V2.0

Comments

@EitanBlumin
Copy link
Collaborator

EitanBlumin commented Apr 16, 2020 •
edited
Loading

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.
@EitanBlumin EitanBlumin added the bug Something isn't working label Apr 16, 2020
@EitanBlumin EitanBlumin mentioned this issue Apr 16, 2020
Open
7 tasks
@EitanBlumin EitanBlumin added the help wanted Extra attention is needed label Apr 16, 2020
@EitanBlumin
Copy link
Collaborator Author

EitanBlumin commented Apr 16, 2020 •
edited
Loading

Thanks, @vhu408 .

I had similar issues myself, getting "not supported calendar message.ics" when trying anything slightly complex. In fact, I've been getting this even when trying something basic as canceling an event (see issue #11 ).

Unfortunately, I do not know how to resolve such issues at this time, because my understanding of ICS formatting is still quite limited.

I would venture a guess that perhaps you should try removing the <HTML> and <body> tags from the body parameter (i.e. treat it as the actual body of the message). But, other than that, I'm at a loss myself.

I attached the help wanted label to this issue.

@EitanBlumin EitanBlumin self-assigned this Apr 16, 2020
@EitanBlumin EitanBlumin added this to the V2.0 milestone Apr 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@EitanBlumin EitanBlumin

Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Milestone
V2.0
Development

No branches or pull requests
1 participant
@EitanBlumin