[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2016-10-30
6
Medium Priority
?
58 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 52

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 52

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 52

Accepted Solution

by:
Gustav Brock earned 2000 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

650 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