Solved

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

Posted on 2016-10-30
6
27 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
  • 3
  • 3
6 Comments
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
0
 

Author Comment

by:Andy Brown
Comment Utility
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 49

Expert Comment

by:Gustav Brock
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:Andy Brown
Comment Utility
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 49

Accepted Solution

by:
Gustav Brock earned 500 total points
Comment Utility
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
Comment Utility
Thanks - Gustav.  I'm going to re-focus on the UTC issue now.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
If you don't know how to downgrade, my instructions below should be helpful.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now