J,
You could use one field, comma-delimited, then use the SSUB function to pick it apart. Note: The ITEMCNT function will tell you how many items are in the comma-delimited list. So, while creating your message: SELECT colname INTO vemaillist FROM tablename WHERE whatever SET VAR vitems INTEGER = (ITEMCNT(.vemaillist)) SET VAR vrecipient TEXT SET VAR v1 INTEGER WHILE vitems > 0 THEN SET VAR vrecipient = (SSUB(.vemaillist,.vitems)) PLUGIN RMail.rbl v1|ADD_RECIPIENT .vrecipient SET VAR vitems = (.vitems - 1) ENDWHILE Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of J BLAUSTEIN Sent: Tuesday, January 26, 2010 16:18 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: email send to Emmitt - thank you for your reply - under 3.0 will John option allow me to use the ";" to add a second email address or do I need several fields - the client now has this information in one field J On 1/26/2010 1:01 PM, Emmitt Dove wrote: No, it is just the difference between R:Mail 2.6 and 3.0. With 2.6 you could put a comma-delimited string of addresses on one line. With 3.0, the entire approach is different. You issue a new PLUGIN command for each additional recipient. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of J BLAUSTEIN Sent: Tuesday, January 26, 2010 12:35 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: email send to Thank you John and James - John method is for several fields where James method is a single field?? J Yes. In order to add an additional email address to a portion of the email message, you must reissue the R:Mail parameter for that portion of the email message. PLUGIN RMail.rbl v1|ADD_RECIPIENT [email protected] PLUGIN RMail.rbl v1|ADD_RECIPIENT [email protected] PLUGIN RMail.rbl v1|ADD_RECIPIENT [email protected] The same applied for the following R:Mail parameters: ADD_CC_RECIPIENT ADD_BCC_RECIPIENT RECEIPT_TO John On 1/26/2010 12:26 PM, James W. Kim wrote: J, Yes. In R:Mail 2.6, you just list the email addresses separated by semicolon just as in Outlook. In R:Mail 3.0, you issue multiple ADD_RECIPIENT command to the plug-in. Version 2.6 is much easier to implement, but 3.0 give you far more features and flexibility. James Kim -- J. Blaustein J Blaustein Associates, Inc. 12 Herrick Drive Lawrence, NY 11559 516-371-3445 FAX 516-345-8009 -- J. Blaustein J Blaustein Associates, Inc. 12 Herrick Drive Lawrence, NY 11559 516-371-3445 FAX 516-345-8009
