I just sent a spreadsheet to myself with the following and addresses and such changed:
SNDDST TYPE(*DOC) TOINTNET((‘whomever@whereever.COM’)) DSTD(‘DOCUMENT MAIL’) USRID(SYSTEM userid) DOC(document.XLS) FLR(folder)
I think there is an issue with any document if you do not send from the folder portion of the system with, of course, the limitiations of 8 character names. Others can perhaps confirm.
First, don’t use SNDDST to send files such as .CSVs or .XLSs. Why would you think SNDDST had anything at all to do with PC files? It’s a SNA command for sending SNA distributions. It’s been adapted to allow sending text, but a .XLS is hardly a text file.
Further, SNA is not SMTP. If you’re going to be responsible for SMTP e-mail, you better have at least the most basic knowledge about what SMTP can do. The biggest thing it can’t do is send any message that contains any bytes with values that are not “ASCII printable text”. Because of that limitation, there’s a whole area of SMTP e-mail that’s known as “MIME attachments”. MIME procedures take attachments and convert their bytes to encodings that guarantee that all transmitted bytes meet the “printable text” restriction.
If you’re going to use SNDDST to send anything but guaranteed text, you’ll need to locate some procedures that can take your attachments, convert them to MIME encoding, add the appropriate MIME headers and generate the complete body of the e-kmail.
As for CPYTOIMPF. .CSVs don’t have anything but data unless you add rows that have something other than data. If you want some kind of ‘column heading’ row, then create one. Then use CPYTOIMPF to append to whatever non-data row you created.