We have created a utily that - using MIME - allows us to send emails using the VMS MAIL utility that include various types of file as an attachment. So far it works for PDF, text xls, doc and zip files.
However we are unable to get it to work for the newer .xlsx excel files. We can send it OK and when you open the email up it all looks as it should, the little .xlsx icon is right there etc ... But when we actually click on it to try to open it up , excel simply says the file is in an unreadable format.
I wonder if anyone has any experience of getting this to work ok or can suggest a solution.
Ok, so here is the answer to my own question.
First of all the VMS engineer guys are accepting that mime has a bug which prevents it from encoding native .xlsx (and possibly other new office format files).
The workaround we did was to zip the .xlsx with a recent version (circa 2006) of zip on our openVMS box, using the "-V" option. We could then "mimeify" the zip and send on using VMS Mail. We found that we could then open the zip in the target email client and read the attached .xlsx spreadsheet OK.