• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Send a Spool File from AS/400 with a Specific Subject Line and Message Body

    May 23, 2007 Hey, Ted

    Note: The code accompanying this article is available for download here.

    A while back, I was working on a project that required an e-mail to be sent with a resulting spool file as an attachment and with a specific subject line and specific message body. I had no trouble figuring out how to send the spool file as a document and how to create the message body. The hard part was customizing the subject line of the e-mail. This was important because the subject line would have provided the users a hint about the urgency of the task they need to perform.

    Any time the command SNDDST is used to send an e-mail with the TYPE parameter specified as *DOC, the name of the document pre-fills the subject line of the e-mail by default. I spent hours to find out how to get around it.

    I wrote the Send Email Spool File (SNDESPF) command to send an spool file of any length as an e-mail attachment. Source code for the command and its command-processing program, ASNDESPF, are available for download.

    There are two things to consider before using the utility.

    1. Make sure for SMTP server properties, the value for Message Split Size is set to No Maximum. This is required for large spool files.
    2. Make sure QDLS directory is not restricted for access or at least you have access to it to create folders.

    To prevent users from sending e-mail to outside addresses, I hard coded the domain name. You can change that if you wish. The e-mail address parameter of the command does not require the domain name. If the domain name of your company is more than 15 bytes, adjust the size of the parameter &INTADD. Also it needs to be mentioned that if no spool number is provided in the command, the last spool file of the job (this is useful in batch processing) will be sent.

    –Manouchehr Babakhani

    Thanks to Manouchehr for sharing his utility with us. I have no doubt he’s having great success with it in his shop. I know that e-mailing from the System i can be a challenge at times, so I was glad to pass his code along to the readers.

    –Ted



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee Help/Systems:  SEQUEL is the single solution for all your business intelligence needs
    LaserVault:  AES Encryption for secure AS/400 backups with no changes to your system

    IT Jungle Store Top Book Picks

    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    IBM: SOA Fits Skills Shortage to a ‘T’ ICS Finds the Sophisticated Side of PHP

    Leave a Reply Cancel reply

Volume 7, Number 20 -- May 23, 2007
THIS ISSUE SPONSORED BY:

WorksRight Software
ProData Computer Services
LaserVault

Table of Contents

  • Send a Spool File from AS/400 with a Specific Subject Line and Message Body
  • Searching for Wildcard Characters
  • Admin Alert: i5 IPL Pre-Planning and Post-Planning Checklists

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Power Systems Grows Nicely In Q3, Looks To Grow For All 2025, Too
  • Beta Of MCP Server Opens Up IBM i For Agentic AI
  • Sundry IBM i And Power Stack Announcements For Your Consideration
  • Please Take The IBM i Marketplace Survey
  • IBM i PTF Guide, Volume 27, Number 43
  • IBM Pulls The Curtain Back A Smidge On Project Bob
  • IBM Just Killed Merlin. Here’s Why
  • Guru: Playing Sounds From An RPG Program
  • A Bit More Insight Into IBM’s “Spyre” AI Accelerator For Power
  • IBM i PTF Guide, Volume 27, Number 42

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle