[ Up To iMail ]
The main iMail menu appears below:
IMAIL iMail Menu 6.96 11.30.20
iMail Administration
1. Configure iMail CFGMAIL
2. Work with Log WRKMAILLOG
3. Work with Users WRKMAILDST
4. Work with Groups WRKMAILGRP
5. Work with Administration WRKMAILADM
iMail Functions
10. Work with Spooled Files WRKSPLINF
11. Send Database File SNDDBF
12. Send Email Message SNDMAIL
Configure iMail Server
21. Work with iMail Server WRKMAILSVR
22. Start iMail Server STRMAILSVR
23. End iMail Server ENDMAILSVR
More...
Selection
F1=Help F3=Exit F12=Cancel
© Copyright 1994 - 2020 inFORM Decisions All Rights Reserved.
If the Work with Administration 'Allow to use WRKSPLFINF' value is Y (Default), choosing item 10 from the iMail menu displays the prompt screen Work with Spool File (MMRGSPLF) as shown below. With this screen you can refine your search criteria. Type your choice and press enter, the following screen will be displayed.
Work with Spool File (MMRGSPLF)
Type choices, press Enter.
User ID . . . . . . . . . . . . > *CURRENT Name, generic*, *CURRENT...
Form Type . . . . . . . . . . . *ALL Name, *ALL
User Data . . . . . . . . . . . *ALL Name, generic*, *ALL
Output Queue . . . . . . . . . . > *ALL Name, *ALL
Library . . . . . . . . . . . Name, *LIBL
Job Name . . . . . . . . . . . . *ALL Name, *, *ALL
User Name . . . . . . . . . . Name
Job Number . . . . . . . . . . 000000-999999
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
If 'Allow to use WRKSPLFINF' value is N, the prompt screen when user select option 10. Work with Spooled Files will be suppressed and the spool files list is shown immediately with the configured parameters for the current user as shown below (Equivalent to the WRKSPLF system command):
11/30/20 iDocs Form Suite MRGSPLC1
12:17:11 Work with Spooled Files KKRAMER
2=Change 3=Duplicate 4=Delete 5=Display 8=Convert to IFS
9=Attribute 10=Email 21=Edit Splf
Total Form
Opt File Job User Out Queue User Data Sts Pages Type
FIVEPAGE QPADEV002B KKRAMER FORM001 ALASKARR RDY 5 *STD
L88X132W QPADEV002B KKRAMER FORM001 CMST408 RDY 28 T4
L99X132W QPADEV002B KKRAMER FORM001 CMST4A08 RDY 15 T4A
L22X132W QPADEV002B KKRAMER FORM001 CMS1099D08 RDY 3 1099D
L88X085W QPADEV002B KKRAMER FORM001 CMSW208 RDY 85 W2
L33X132W QPADEV002B KKRAMER FORM001 CMS1099M08 RDY 4 1099M
L22X132W QPADEV0002 KKRAMER FORM001 CMS1099I08 RDY 3 1099I
CMSPO QPADEV000J KKRAMER FORM001 REEVESPO RDY 2 P.O.
REEVESCC QPADEV000J KKRAMER FORM001 CMSPRSP7 RDY 17 PRCHECK
W66X132L QPADEV000J KKRAMER FORM001 Swift Stub RDY 37 SWIFTSTUBS
L42X85W QPADEV000J KKRAMER FORM001 SWIFTAPCK RDY 375 SWIFTCHECK
L66X132W QPADEV000J KKRAMER FORM001 Swift stub RDY 2 SWIFTSTUBS
L42X85W QPADEV000J KKRAMER FORM001 LEONPLASTC RDY 106 *STD +
Record: 13 / 276
F3=Exit F5=Reload F11=Old view F12=Previous F17=Top F18=Bottom
Option 8, Converts to IFS, does just that function. Selecting a spool file with this option enables a user to specify not only the location of where to copy to the file, but also the format that spool file should be converted to as illustrated below:
iMail Convert Spooled File (ECVTSPLF)
Type choices, press Enter.
Spool file name . . . . . . . . > CMSPO Name
Job name . . . . . . . . . . . . > QPADEV000J Name, *
User . . . . . . . . . . . . . > KKRAMER Name
Number . . . . . . . . . . . . > 337611 000000-999999
Spool file number . . . . . . . > 000000001 1-9999, *LAST
Converted spool types . . . . . *PDF *FCFC, *HTML, *PCL, *PDF...
IFS Directory . . . . . . . . . '/imail'
IFS Filename . . . . . . . . . . *SYSTEM
Bottom
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display
F24=More keys
Option 10, sends a spool file with iMail (if you have the module) as illustrated below:
11/30/20 iDocs Form Suite ESNDSPR1
12:23:55 Send iDocs Spooled File with iMail KKRAMER
From Address. . : noreply@informdecisions.com
To Address. . . :
Cc Address. . . :
From Page . . . : 1
To Page . . . . : 17 Type: *PDF
Subject . . . . :
Request Delivery Receipt: (Y/N) Request Read Receipt: (Y/N) Batch Mode: N
F3=Exit F4=Prompt F7= Group List F10=Send F12=Cancel
F4 (Prompt) in the Type field reveals the following output options:
11/20/20 iDocs Form Suite ESNDSPR1
IM0601W1
Select an Attach Type
1=Select
Opt Type Description
*HTML Hyper Text Markup Language
*RTF Rich Text Format
*PDF Portable Document Format
*TXT Text
*FCFC Ansi Forms Control
*PRTCTL Print Control
*XLS Microsoft Excel
*XLSX Microsoft Excel
F12=Previous
This option reveals one of iMail strongest suits.
The ability not only to send a native System i database file, but also to convert the database file from the native format to a open format such as a *DIF for data interchange format that can be directly opened by a windows spreadsheet. What does this mean? It means you are not longer limited by the confines of proprietary file formats, conversion techniques, and file transformations.
Within the screen below in the prompt for type any one of the following formats may be entered from the table below.
| Type | Format | Description |
|---|---|---|
| *CSV | Comma Separated Value | Record and field based text file delimited with commas |
| *DIF | Data Interchange Format | Record and field based text file delimited with tabs |
| *SAVF | System i Save File | Requires that the source file already be a save file |
| *TXT | Text | Fixed format text file with no field delimitation |
| *XLS | Excel format | Fully compatible Excel binary format* |
| *XLSX | Excel format | Fully compatible Open XML format* (2007+) |
Prior to using *XLS/*XLSX to send a database in Excel format, the command IMAILIFS needs to first be issued to install the Java dependecies used to create the Excel file form the DB2 database. The syntax for using this command is:
IMAILIFS LIB([YourSourceLibrary])
Choosing option 11 from the menu displays the screen below
6/23/18 iMail IM0636
18:07:51 Send Database File KKRAMER
From: addednow@informdeicions.com F4=List
To: F4=List
Cc: F4=List
Bc: F4=List
File . . : Lib: *LIBL Mbr: *FIRST Type: *DIF F4=List
Zip Attachment: *NO *YES/*NO
Subject. :
F3=Exit F4=List F7=Distribution List F10=Send F12=Cancel
- Limited to emailing a single database file.
- Limited to 80 characters for the sender and recipient addresses
- Limited to 300 direct recipients in the To address*
- Limited to 300 direct recipients in the Cc address in addition to those in the To address*
- Limited to 300 blind copy recipients in the Bc address*
- Limited to 80 characters for the subject
- Limited to 2048 characters for the message
- Limited to converting the database file to the following types if the attribute is a
source physical file. CSV, DIF, TXT, XLS
- Limited to retaining the initial format if the database file to the following types if the attribute is a
source save file.
- CSV - Maximum columns 255, Maximum column width 256
- DIF - Maximum columns 255, Maximum column width 256
- XLS - Maximum columns 255, Maximum column width 256
- TXT - Maximum columns 255, Maximum column width 256
* iMail 6.90 and above supports blank, comma or semi-colon as address separators in TO, CC and BC addresses.
Option 12 enables a user to send an email without an attachment.
8/16/18 iMail IM0606
18:08:42 Send iMail Message KKRAMER
Type information, press Enter
From: addednow@informdeicions.com F4=List
To: F4=List
Cc: F4=List
Bc: F4=List
Subject. :
F3=Exit F4=List F7=Distribution List F10=Send F12=Cancel
NOTE: The <CR> tag can be used to insert a line break or carriage-return within the message body.