User Tools

Site Tools


pub:imailfunctions

[ Up To iMail ]

iMail Functions

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.                   

Work with Spooled Files

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                                                               
                                                                              
                                                                              

Send Database File

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               

Thresholds and Limitations:


  - 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. 

Send Email Message

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              



Here the email recipients can either be typed in or selected from the public distribution list by pressing F4. Once the recipients have been entered and the subject and message body typed in, pressing F10 sends the email to the desired users.

NOTE: The <CR> tag can be used to insert a line break or carriage-return within the message body.

pub/imailfunctions.txt · Last modified: 2022/06/25 17:02 by 127.0.0.1