10-28-2015 01:00 PM
I'm not sure if this is the place to post this, if not, please let me know the proper place. I created a project in EG using proc report to create an excel spreadsheet that has 3 different tabs and then email the file. This is placed in a macro so it can go through a loop within a file to grab specific information for a region and then email to that regions manager. This works perfect in EG, however, when I put this as a job in DIS - using the exact same code - my email gets sent with the attachment, however I can't open it, it's telling me the file is corrupt. Every email for every file I'm creating is corrupt. What's the difference? What do I need to modifiy in DIS to make this work?
10-28-2015 03:43 PM - edited 10-28-2015 03:45 PM
The problem you are getting could be this one:
You need to ensure that the content type option is set when emailing so when you try to open the attachment it knows what to open it with.
10-28-2015 06:50 PM
10-29-2015 11:11 AM
I recently ran into an example of an XLS file that Excel said was corrupted and couldn't get it to open in Excel. But proc import could read it.
I take that as another reason to avoid Excel format files and recommend considering CSV. Yes CSV doesn't support multiple tabs. Since you say this is proc report output perhaps RTF would be acceptable.