SAS email option to include "when" for a meeting room booking via email

[Venkat4]

I am trying to automate the meeting room booking process via SAS emailing to the meeting room email just like how Outlook does while booking a room. I got the email ID for the room and can add myself as sender, and only thing that is missing is the "when" option or "start time" and "End time" option within the filename email SAS code.

I don't seem to see anything related to the timing as an option like

importance="high"

I am sure the option exist or can be added differently. Can someone let me know how would you solve this problem using SAS and automated email?

Thank you,

Park

[Venkat4]

I don't seem to see anything related to the timing as an option like

importance="high"

I am sure the option exist or can be added differently. Can someone let me know how would you solve this problem using SAS and automated email?

Thank you,

Park

[SuryaKiran]

Hi,

You can add importance for the mail using IMPORTANCE='HIGH' options. But, for meeting maker I don't think there are any direct options available. You may have to hard code and create an invite file for setting a meeting.

You might find this helpful: https://support.sas.com/resources/papers/proceedings09/086-2009.pdf

[SuryaKiran · Accepted solution]

I just tested this out and worked for me.

1) Open Outlook and create a meeting maker as you like to have.

2) Save the file (.ics extension).

3) open this .ics file in Notepad++ and find where you have to make changes to schedule it daily.

4) Read this file (.ics) into sas and make necessary changes with new date and time and create another (.ics file ) that is similar to the one you created earlier.

5) Send email from SAS with this new (.ics file attached).

6) You should see the meeting added in your calendar.  

[Venkat4]

Thank you much. This seems like a great solution. I tried it, but somehow Outlook is not doing anything when the email is sent from SAS with the .ics file attached. I sent the email directly to the meeting room. I am not sure if any firewall is causing the issue. I do get email from SAS if I use my email in the "To" and I can open the .ics file fine. Do you have any suggestion?

filename sendmail email
sender="myemail@yyyy.com"
to=("meetingroom122@yyyy.com") 
Subject = "Room 122"
 attach="/path/data/meeting1.ics";

data _null_;
 file sendmail;
run;

[SuryaKiran]

Check if you have meeting organizer listed. Also mention from=<your email> in the filename.