Solved

Microsoft Outlook Exchange help viewing attachments in .xls format

Posted on 2016-08-02
8
51 Views
Last Modified: 2016-08-08
Using Outlook Exchange (on the web), we are trying to send an .xls file attachment to be opened with a Microsoft Office application. The file attaches correctly, but when we click it...it reads "The file must first be saved to the computer..." It doesn't open up the file in our Office application.

Question: We need the end-user (person receiving this e-mail) to be able to just click the file and open it in the Office software. The user is a very new computer user and does not know how to save and open files. So once they click it, it needs to open right away. I've read somewhere that .xls files cannot be opened as part of a security update and I've read about changing registry files, but we cannot do this because we cannot get access to this user's computer and we don't want to risk changing registry settings. Please help asap!
0
Comment
Question by:Justin Smith
  • 4
  • 4
8 Comments
 
LVL 14

Accepted Solution

by:
frankhelk earned 500 total points
ID: 41739217
That depends probably on some (mere esoteric) security settings in Outlook, and far more worse, it depends on the destination side settings. So regardless of what you do when sending the message, the end-use might have any outcome in between "opened seamless" and "totally blocked", depending on mail client settings, OS settings, local policies, domain policies, antivirus software settings, etc, etc, etc.

To make it more complicated, if the user doesn't use Outlook (i.e. Thunderbird, PMMail2000, Eudora, etc, etc, or some other OS' (Linux, IOS, ...) mail client) there might be more and different security settings ...

A quantum of solace: Your results depend on YOUR settings ... possibly the end-user population majority has more compatible settings ...

Maybe you could circumvent it by placing the file on a web server (http, ftp; with logon) and stuff only a link to it into your message.
0
 
LVL 4

Author Comment

by:Justin Smith
ID: 41739522
The recipient uses Outlook web. Same as us. The web server idea is great, but not the login part. Is there anyway to keep the file secure without having a login, that they can just click and go to it?
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41740170
Even with Outlook Web (which I've never tried ...) the handling of attachments relies on at öleas how the OS handles downloads.

About the web server thing: Sure you can make that web server open, but that leaves the files open for everybody to download. At first you can make the URL a bit obfuscated by including a cryptic prefix - random generated for each attachment set - for every file and ensuring that the directory of them couldn't be read, i.e.:

http://theserver.thedomain.com/ADDAcBHZYqgMtQS1Pzfbzpv7EddGyGseWm8wCLeLeY9uMTKHAG/myworkbook.xls

Open in new window


Second Idea would be to protect the Excel file with a password. I presume that "zip it with a password" would be too much complicated for your end user ...

Nonetheless the OS (or browser, or antivirus ) of the client might block the seamless opening of downloaded files as well ...
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 4

Author Comment

by:Justin Smith
ID: 41740466
The zip it with a password would be too complicated...the encrypted link might work, how would I go about doing something like that?
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41740557
Basically spoken, "simple" web servers (aka "without CMS")  are usually fed via FTP, where the driectory structure reflects the URL structure. So you need some script that generates the "random part", creates a directory at the right place and stores the file to d/l therein. Afterwards it would spit out the correct URL to you to copy/paste it into your email message.
0
 
LVL 4

Author Comment

by:Justin Smith
ID: 41740732
Are FTP addresses free? Know of any good ones?
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41740748
Unfortunately - I don't know.

If you have a web server, you should usually have some ftp acces for maintenance, too ... you'd use the ftp procedure to stuff the files into the web server's data directories.
0
 
LVL 4

Author Closing Comment

by:Justin Smith
ID: 41747435
Good information.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Are you irritated by repeating emails issue in Microsoft Outlook 2016 after recent update ?  Lets’ see how to resolve and prevent duplicate emails in the Outlook 2016 using some simple techniques.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

786 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