Solved

Microsoft Outlook Exchange help viewing attachments in .xls format

Posted on 2016-08-02
8
48 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 13

Accepted Solution

by:
frankhelk earned 500 total points
Comment Utility
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
Comment Utility
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 13

Expert Comment

by:frankhelk
Comment Utility
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
 
LVL 4

Author Comment

by:Justin Smith
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 13

Expert Comment

by:frankhelk
Comment Utility
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
Comment Utility
Are FTP addresses free? Know of any good ones?
0
 
LVL 13

Expert Comment

by:frankhelk
Comment Utility
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
Comment Utility
Good information.
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Join & Write a Comment

Disabling the Directory Sync Service Account in Office 365 will stop directory synchronization from working.
Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

728 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

9 Experts available now in Live!

Get 1:1 Help Now