How to configure Meeting Invitation to Outlook?

[jenny32]

Hi All,

I have been trying to send Meeting Invitation to Outlook. I have created Email Template and import export map ( from Email Templates - ServiceNow Wiki ).I have been able to send an email with "not supported calendar message.ics" file attachment.   When i open that attachment in notepad, the content is same as the template message.

I have used this code in Email Template.

Message Text:

BEGIN:VCALENDAR

PRODID:-//Service-now.com//Outlook 11.0 MIMEDIR//EN

VERSION:2.0  

METHOD:REQUEST

BEGIN:VEVENT

ATTENDEE;ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:${to}

ORGANIZER:MAILTO:${from}

DTSTART:${dtstart}  

DTEND:${dtend}  

UID:${sys_id}  

DTSTAMP:${dtstamp}  

DESCRIPTION:${u_description}

X-MICROSOFT-CDO-BUSYSTATUS:BUSY  

X-MICROSOFT-DISALLOW-COUNTER:TRUE  

X-SNSYSID:{$sys_id}  

BEGIN:VALARM  

TRIGGER:-PT15M  

ACTION:DISPLAY  

DESCRIPTION:Reminder  

END:VALARM  

END:VEVENT

END:VCALENDAR

In my Email Notification,type is Meeting Invitation.

When i check in Email log(outgoing mail), the body field is empty.

Can anyone tell where i am going wrong?

Thanks,

Jennifer

[Bradford Shelle · Accepted solution]

I'd recommend heading back to the sys_impex_map table and looking there. The new record you added into this table needs to be name icalendar.your_table_name . Also ensure that the fields you are referencing for dtstart and dtend are date/time fields. Not just date fields.

Going to shamelessly self plug an article I whipped together as well: ServiceNow Calendar Invites - Bradford Shelley

I apologize for the poor formatting. Hopefully the gibberish I've typed in there can help out as well.

[aakanksha]

Thank You, it worked

[jenny32]

Hi Bradford,

Thanks for your reply and your article was really a great help.

I got it worked

Thanks,

Jenny

[kreddyT]

Hi Bradford,

It's a great article. Thank you so much.

But I have a question for you, I tried to modify, "organizer:mailto:" in the template. Meaning, I want to be the organizer for this meeting invitation. So, I set it as,

ORGANIZER:MAILTO:keerthana*******@***.com

but it didnt work,

I also tried,

ORGANIZER:MAILTO:${to}

this didn't work either. Can you please correct me?

I want to be the organizer of the meeting so that I can add more people if I want to after sending out this meeting invitation.

[Bradford Shelle]

Hi Keerthana,

Just so I have a better grasp, you want to be listed as both the organizer and the attendee correct?

You might need to check off "Send to Event Creator" under the "Who will receive" tab of the notification if you haven't already. If doing that doesn't work, perhaps try adding your email address into the "From" field on the notification, and then using ORGANIZER:MAILTO:${from} to see if that works.

That's all I can think of at the moment.