Solved

Outlook is doing a little too much to an .ics email attachment - can I stop it?

Posted on 2016-10-30
6
47 Views
Last Modified: 2016-10-30
Within my Access database, I have some VBA that generates an .ics file, attaches it to an email and then sends the email (I am using EASendMail). This part seems to work just fine.  However, when Outlook receives it, it automatically tries to create a calendar event.  Whilst, I appreciate that this sounds fine, it does seem to do some funny things (don't always come through on iPhone, time loses hour via DST - but if you send the saved .ics manually it's perfect).  

In short, is it possible to modify the .ics file so that Outlook just sees it as an attachment and doesn't try to get too smart?

Here is the code I am using for the .ics file:

BEGIN:VCALENDAR
PRODID:-//Company//AppName//EN
CALSCALE:GREGORIAN
VERSION:2.0
BEGIN:VEVENT
DTSTAMP:20161030T130845
DTSTART:20161029T213000
DTEND:20161029T223000
UID:D87E5D923AD84087BF8F67AEF8CC146AE8E17B23C0FA41CF8B5F0E032F089C9BB4233B6C1A05429CAB6835AF1FC4E8D5
CLASS:PUBLIC
SUMMARY:Quick test
DESCRIPTION:Some more text
BEGIN:VALARM
TRIGGER:-PT720M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR

Open in new window

0
Comment
Question by:Andy Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 41865837
0
 

Author Comment

by:Andy Brown
ID: 41865839
It seems like it, but this is actually to see if anything can be added to the ics file that stops Outlook doing over-smart things.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 41865841
I don't think Outlook is acting over-smart, it just tries - lacking timezone info - to guess what could be the time.

Thus, if you don't want simply to convert the times to UTC, which seems foolproof to me, you could try to specify the local timezone:

DTSTART;TZID=CEST:20161029T210000
DTEND;TZID=CEST:20161029T220000

Open in new window

/gustav
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Andy Brown
ID: 41865847
Hi Gustav - It IS trying to act intelligently.  Instead of simply receiving an email with an attachment, it is seeing the attachment as an .ics file and automatically converting it to a calendar event.  Sure the UTC issue is a problem that I'm going to look at again, but it's not the same question.  I really do appreciate all of your help though.
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 41865862
Oh, I see. There may be a setting in Outlook for how to handle the different file extensions.
That, however, may require admin rights granted to the user.

If not, you may have to attach it as a text file and ask the final receiver to save and rename the file.

/gustav
0
 

Author Closing Comment

by:Andy Brown
ID: 41865863
Thanks - Gustav.  I'm going to re-focus on the UTC issue now.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Use Windows Task Scheduler to print a Word document weekly so your printer ink won't dry out.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question