We would like to send database files in the form of e-mail attachments to our sales reps, from the AS/400. Currently, we are sending them from the AS/400 to an intranet website, where they can get the file. I haven't been able to find any info on this. Does anyone have any experience with this?
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
E-Mail attachments
Collapse
X
-
E-Mail attachments
We routinely use CPYFRMPCD and CPYTOPCD commands to move files with character data (no packed) to and from AS400 files and Folders. We can then attach the PC file to an email using a mapped network drive. The process can be automated with CLP's up to the actual attachment part. (If the attachment part can be automated using Lotus Notes, I would like to know that trick)
Comment
-
E-Mail attachments
I have written some utilities to email database files as .csv (comma-separated-value) files that can be opened directly into Excel. It involves using some API's and the SMTP support. From an end user standpoint it is all driven off of a single command though.
Comment
Comment