WriteData (l_to_list) writeData (l_cc_list) WriteData (‘Date: ‘ || l_date) writeData (‘From: ‘ || NVL (p_from, p_sender_email)) writeData (‘Subject: ‘ || NVL (p_subject, ‘(no subject)’)) UTL_SMTP.helo (g_mail_conn, g_mailhost) UTL_SMTP.mail (g_mail_conn, p_sender_email) l_to_list := address_email (‘To: ‘, p_to) l_cc_list := address_email (‘Cc: ‘, p_cc) l_bcc_list := address_email (‘Bcc: ‘, p_bcc) UTL_SMTP.open_data (g_mail_conn) Copy text from any source and paste it into here. Use the Separator to separate the list of e-mail addresses by domains and then arrange the addresses within domain. To switch between comma or semicolon as separator, follow the next steps. Lite 14 email separator is an email domain sorter or email domain separator, that will strips email address into domains.
#EMAIL SEPARATOR COMMA OR SEMICOLON IN GMAIL WINDOWS#
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Semicolon separator How and where to change this option Dont waste your time to find this option in Excel This option is not in Excel but in the local settings of Windows Windows settings. Before it is fixed, you could use a semicolon instead of a comma. PROCEDURE writeData (p_text IN VARCHAR2) AS BEGIN IF (p_text IS NOT NULL) THEN UTL_SMTP.write_data (g_mail_conn, p_text || g_crlf) END IF END BEGIN g_mail_conn := UTL_SMTP.open_connection (g_mailhost, 25) So when you want to send an email to one or more recipients using Office 365 outlook, separate multiple email addresses using semicolon would be useful. PROCEDURE send (p_sender_email IN VARCHAR2, p_from IN VARCHAR2 DEFAULT NULL, p_to IN array DEFAULT array (), p_cc IN array DEFAULT array (), p_bcc IN array DEFAULT array (), p_subject IN VARCHAR2 DEFAULT NULL, p_body IN LONG DEFAULT NULL ) IS l_to_list LONG l_cc_list LONG l_bcc_list LONG l_date VARCHAR2 (255) DEFAULT TO_CHAR (SYSDATE, ‘dd Mon yy hh24:mi:ss’) IF (l_recipients IS NULL) THEN l_recipients := p_string || p_recipients (i) ELSE l_recipients := l_recipients || ‘, ‘ || p_recipients (i) END IF END LOOP p_recipients.COUNT LOOP UTL_SMTP.rcpt (g_mail_conn, p_recipients (i)) CREATE OR REPLACE PACKAGE BODY STUETL.utils_mail AS g_crlf CHAR (2) DEFAULT CHR (13) || CHR (10) g_mail_conn UTL_nnection g_mailhost VARCHAR2 (255) := ‘’ įUNCTION address_email (p_string IN VARCHAR2, p_recipients IN array) RETURN VARCHAR2 IS l_recipients LONG BEGIN FOR i IN 1.
0 kommentar(er)
