User Tools

Site Tools


pub:imailapis

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
pub:imailapis [2019/02/07 10:55] – [iMail Command APIs] kkramerpub:imailapis [2022/06/25 17:02] (current) – external edit 127.0.0.1
Line 144: Line 144:
 | *SAVF| System i Save File       | Requires that the source file already be a save file   | | *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      | | *TXT | Text                     | Fixed format text file with no field delimitation      |
-| *XLS | Excel format             | Fully compatible Excel format*                         | +| *XLS | Excel format             | Fully compatible Excel format *                        |
-\\ +
-**NOTE:** Outlook 365 doesn't allow an override of the From Address and if entered on the API it will result in a send failure. +
-\\ +
-\\ +
-* Prior to using *XLS to send a database in Excel format, the command IMAILIFS needs to first be issued to install the Java dependencies used to create the Excel file form the DB2 database. The syntax for the useing the command is:+
 \\ \\
 +* Prior to using *XLS to send a database in Excel format, the command IMAILIFS needs to first be issued to install the Java dependencies used to create the Excel file form the DB2 database. The syntax for the using the command is:
 \\ \\
      IMAILIFS LIB([YourSourceLibrary])      IMAILIFS LIB([YourSourceLibrary])
 +\\
 +**NOTE:** Outlook 365 doesn't allow an override of the From Address and if entered on the API it will result in a send failure.
 \\ \\
 == Thresholds and Limitations: == == Thresholds and Limitations: ==
Line 159: Line 157:
   - Limited to emailing a single database file. (For multiples use command ESNDDBFS)    - Limited to emailing a single database file. (For multiples use command ESNDDBFS) 
   - Limited to 80 characters for the sender and recipient addresses   - Limited to 80 characters for the sender and recipient addresses
-  - Limited to 300 direct receipients in the To address* +  - Limited to 300 direct recipients in the To address* 
-  - Limited to 300 direct receipients in the Cc address in addition to those 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 receipients in the Bc address*+  - Limited to 300 blind copy recipients in the Bc address*
   - Limited to 80 characters for the subject   - Limited to 80 characters for the subject
   - Limited to 2048 characters for the message   - Limited to 2048 characters for the message
Line 173: Line 171:
     - TXT - 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.+Note: Your mail server can also limit the file size sentCheck with your Mail Server Administrator.
    
-</pre></html>                             +</pre></html> 
- **Note:** Your mail server can also limit the file size sentCheck with your Mail Server Administrator                                                                                +**Release specific notes: **                            
 +  
 +iMail 6.90 and above supports blank, comma or semi-colon as address separators in TO, CC and BC addresses.\\ 
 + 
 +iMail 6.98 includes data area **DSCSVLEFT** used to control the method used to convert a database to CSV.\\   
 +DSCSVLEFT = '**Y**': Uses the original approach of utilizing SQL to read the data: it will limit the number of  
 +fields in database to 256 columns.\\ 
 +DSCSVLEFT = '**N**': Uses the CPYTOIMPF command to convert a database to CSV and will not limit the columns in  
 +the data file, but it can negatively impact the format of numeric fields for some customers who will be better  
 +served with the original SQL approach 
 +                                                                                
 ===== ESNDDBFS ===== ===== ESNDDBFS =====
  
Line 515: Line 523:
   * **FROMADDR** – This parameter requires the senders email address. If ommitted, then the default from address from the iMail configuration will be used.   * **FROMADDR** – This parameter requires the senders email address. If ommitted, then the default from address from the iMail configuration will be used.
   * ** ATTACH** – This qualifier specifies a PC file from the IFS directory to be attached.    * ** ATTACH** – This qualifier specifies a PC file from the IFS directory to be attached. 
-  * **TYPE** – Enter the type of attachment here as either *FCFC*HTML*PCL*PDF*PRTCTL*RTF*TXT*XLS*XLSX*TIF.+  * **TYPE** – Enter the type of attachment here as either or F4 Prompt displays a list for you to choose from: 
 +    *  *FCFC   
 +    *  *HTML   
 +    *  *PCL    
 +    *  *PDF    
 +    *  *PRTCTL 
 +    *  *RTF    
 +    *  *TXT    
 +    *  *XLS    
 +    *  *XLSX   
 +    *  *TIF    
   * **OUTPUTNAME** - (Added 6.90 12/15/17) The parameter overrides the iMail attachment name. If this parameter is blank, then the default name is used. User can use the following values:   * **OUTPUTNAME** - (Added 6.90 12/15/17) The parameter overrides the iMail attachment name. If this parameter is blank, then the default name is used. User can use the following values:
     * *SPLFNAME, *SPLNAME, *SPLNAM for spool file name     * *SPLFNAME, *SPLNAME, *SPLNAM for spool file name
pub/imailapis.1549565713.txt.gz · Last modified: 2022/06/25 17:02 (external edit)