Comments on Dan McGhan's Oracle Blog: iCalendar event via email

Hi Amber, I'm not sure if you can do this wit...

2012-01-20T09:24:21.160-05:00

Hi Amber,

I'm not sure if you can do this with the APEX_MAIL package. It will just require some careful testing and analysis. Unfortunately, I don't have time to do it myself...

Regards,
Dan

Hi. I know this blog was from a while ago, but I a...

2012-01-13T17:06:57.503-05:00

Hi. I know this blog was from a while ago, but I am trying to follow these instructions, but I have to use APEX_MAIL. I set this up before I read that you couldn't do it from APEX_MAIL. Now I am receieiving emails with the always classic "You must have HTML enabled client" Can I sort this error out or am I going to have to attach the calendar event (APEX_MAIL.ADD_ATTACHMENT) This might be a problem because the attachment has to be a BLOB

Thanks,
Amber

CoffeeMan, I don't remember why I used UTL_SM...

2011-11-11T11:16:24.495-05:00

CoffeeMan,

I don't remember why I used UTL_SMTP over UTL_MAIL. This is an old post. You'll have to test to find out.

Regards,
Dan

does this work with UTL_MAIL?

2011-11-11T11:13:23.171-05:00

does this work with UTL_MAIL?

Hi Jochen, I'm glad it worked for you (it'...

2011-11-10T08:53:43.987-05:00

Hi Jochen,

I'm glad it worked for you (it's an old post) :)

Dan

Hello, the code worked for me and that's real...

2011-11-10T03:43:08.275-05:00

Hello,

the code worked for me and that's really cool. Still, as a very minor improvement I would suggest to use utl_smtp.crlf as a replacement for your lf constant so you don't need experiment with the line endings.

Cheers
Jochen

Mike, As to your first question. Perhaps you need...

2011-04-26T09:31:04.666-04:00

Mike,

As to your first question. Perhaps you need to change your carriage return... If that's not it then there's probably some other kind of formatting issue.

It's always best to deconstruct an email that works and compare that to one that doesn't. However, you have to see the ENTIRE email. An easy way to do this is with gmail. Open an email, click on the "down arrow", and select Show Original.

Regards,
Dan

Mike, That's a good question. It's been a...

2011-04-26T08:58:06.159-04:00

Mike,

That's a good question. It's been a while since I worked on this... Are you able to do it in Outlook normally? If so, you have to examine that email using a tool that shows you everything about the email. Then just copy that technique.

Regards,
Dan

Is there a way to add the meeting request to the c...

2011-04-19T06:08:43.976-04:00

Is there a way to add the meeting request to the calendar, without prompting for the meeting to be accepted/declined?

Hi Dan, This works great for me if I open the e-ma...

2011-04-18T09:27:10.719-04:00

Hi Dan,
This works great for me if I open the e-mail in Gmail, however if I open the e-mail in Outlook 2003 I simply get a flat e-mail with subject and body populated, but no calendar invitation (not even the "You must have an HTML enabled client to view this message" message that others have referred to)?

Any idea what I could be missing?

Thanks,

Mike

Harry, Please contact me via email.

2011-01-20T18:28:22.729-05:00

Harry,

Please contact me via email.

Is this the current code? I tried the chr(13)||chr...

2011-01-20T17:18:54.274-05:00

Is this the current code? I tried the chr(13)||chr(10). That did not help. Is the read as HTML setting server level or user level? In outlook 2007 I see how to set the outgoing message as HTML but not how to read the message as HTML. It looks like Outlook is ignoring CR/LF.

Hi Dan, great blog! Your iCal solution for pl/sql ...

2010-11-02T14:57:14.418-04:00

Hi Dan,
great blog! Your iCal solution for pl/sql helped me alot with a project I'm working on and, definitely, taught me somthing new and interesting today.

Kind regards,
Davor

Anonymous, Please contact me via email...

2010-07-27T16:59:06.797-04:00

Anonymous,

Please contact me via email...

Thanks Dan for the wonderful post. I've succes...

2010-07-27T16:26:02.978-04:00

Thanks Dan for the wonderful post. I've successfully been able to create a calendar invite for one of our applications. However we have a requirement to have the calendar responses be tracked and when I create a calendar using pl/sql and assign myself as an organizer, I don't see the tracking tab even though I invite myself to the event. When I create an outlook calendar directly, I have an email in my sent folder and I also see a tracking tab. Can this feature be achieved programmatically? I think if somehow I can get the sent email and a copy of the calendar created in my outlook, the tracking tab would show up. Is there any way to achieve this?

Thanks for your help.

Anonymous, Please email me to discuss this furthe...

2010-03-03T13:25:58.608-05:00

Anonymous,

Please email me to discuss this further...

Regards,
Dan

Hi Dan, It is working fine for desktops with Outl...

2010-03-03T09:10:48.941-05:00

Hi Dan,

It is working fine for desktops with Outlook, but for Outlook Web Acces, I receive the same MR as an e-mail instead of MR. Have you seen this before?

Aha, Please email me to discuss this further... ...

2010-01-17T22:29:00.931-05:00

Aha,

Please email me to discuss this further...

Regards,
Dan

Hi Dan, I am looking for an option to send a recu...

2010-01-17T01:21:36.683-05:00

Hi Dan,

I am looking for an option to send a recurring meeting request. The meeting is supposed to span over a from date and to date. Is there a way for this? I could also do with a way to send requests which just sends requests and blocks the calendar and doesnt require a user response. Thanks in advance for your help!

Regs,
Aha

Grigoriy, I'm actually revisiting this topic ...

2009-07-31T16:23:57.752-04:00

Grigoriy,

I'm actually revisiting this topic this weekend. I'll release an update soon which may fix your issue.

Regards,
Dan

Hi Dan, I'm trying to test you code. I receive...

2009-07-31T16:14:45.028-04:00

Hi Dan,
I'm trying to test you code. I receive email with an attachment "not supported calendar message.ics". When I open it I see meeting details. What should I do to receive meeting as an email and not as attachment. We use Outlook 2007.

Thanks a lot!
Grigoriy

Dan, I originally used the chr(10) in development...

2009-04-21T14:11:00.000-04:00

Dan,

I originally used the chr(10) in development with the exchange server, but had to change it to chr(13)||chr(10) for it to work properly. I had not thought of using chr(10) for Domino until you suggested it. Interestingly, after changing it back to chr(10), the email with the ical does get sent out, but when the email arrives in my inbox, there is nothing in the email. There is no subject, no body, and the TO: says undisclosed-recipients. As soon as I change the LF back to chr(13)||chr(10), then the email gets stuck in the Domino inbox, and won't send. The admin had to delete it so that the other emails would send.

Thanks,
Kris

Kris, Good timing... I'm currently revisiting thi...

2009-04-21T10:34:00.000-04:00

Kris,

Good timing... I'm currently revisiting this subject. I'm surprised that something would choke your mail relay. Have you already tried changing the linefeed from chr(10) to chr(13)||chr(10) or vice versa?

Regards,
Dan

Dan, Thanks for the great post. I was able to su...

2009-04-21T07:58:00.000-04:00

Dan,

Thanks for the great post. I was able to successfully implement your sample on our development side, which uses a Microsoft Exchange server. However, in production is a different story. We are using Domino 8.5 as our SMTP relay server. When the email gets sent through this server, it gets stuck in the queue and causes the server to stop sending any further emails until we delete the ical email from the queue. Any ideas?

Randy,

You're spam/garbage filter seems to ...

2009-04-09T15:52:00.000-04:00

Randy,

You're spam/garbage filter seems to have picked up on something in the email - could be a header. To find the cause you'll need to view the email in it's entirety and look for differences.

If you've not worked with a pop3 server before an easy way to view the email is to send it to a gmail account. Open the mail there and click the down arrow and then on Show original.

Regards,
Dan

Comments on Dan McGhan's Oracle Blog: iCalendar event via email

Hi Amber, I'm not sure if you can do this wit...

Hi. I know this blog was from a while ago, but I a...

CoffeeMan, I don't remember why I used UTL_SM...

does this work with UTL_MAIL?

Hi Jochen, I'm glad it worked for you (it'...

Hello, the code worked for me and that's real...

Mike, As to your first question. Perhaps you need...

Mike, That's a good question. It's been a...

Is there a way to add the meeting request to the c...

Hi Dan, This works great for me if I open the e-ma...

Harry, Please contact me via email.

Is this the current code? I tried the chr(13)||chr...

Hi Dan, great blog! Your iCal solution for pl/sql ...

Anonymous, Please contact me via email...

Thanks Dan for the wonderful post. I've succes...

Anonymous, Please email me to discuss this furthe...

Hi Dan, It is working fine for desktops with Outl...

Aha, Please email me to discuss this further... ...

Hi Dan, I am looking for an option to send a recu...

Grigoriy, I'm actually revisiting this topic ...

Hi Dan, I'm trying to test you code. I receive...

Dan, I originally used the chr(10) in development...

Kris, Good timing... I'm currently revisiting thi...

Dan, Thanks for the great post. I was able to su...

Randy,You're spam/garbage filter seems to ...

Randy,

You're spam/garbage filter seems to ...