SEND MAIL

[2 letter pi]

Windows 2000; FMP 8.5 Advanced

Problem: SEND MAIL script step

Main Database is on a server being shared not served (But only one user as I run this script)

Fields:

“SSSDB E-Mail” Text

“SSSDB::EMailAddressContainer” Global Text

I run the following script

Perform Script (“QSS List”)

//gets fond set - 364 records

Constrain Found Set (Omit Records: Criteria “SSSDB E-Mail: “=”)

//eliminates 3 records where email addresses are blank – down to 361 recprds

Set Field (SSSDB::EMailAddressContainer;””)

//initializes global field to be empty

Go to Layout (“For Mass E-Mail”)

//has the EmailAddressContainer field on it…basically to check if script working

so far

Replace Field Conents (SSSDB::EMailAddressContainer; Replace with Calculation; SSSDB::EMailAddressContainer & SSSDB E-Mail “,”)

//gathers all 361 email addresses into the one global field

Set Field (SSSDB::EMailAddressContainer; with Calculation: Let(LOF=Length(SSSDB::EMailAddressContainer); Left(EMailAddressContainer; with Calculation; LOF-1)

// eliminates the comma at the very end of the global field

…………….everything works perfectly so far……………

Send Mail [To: SSSDB::EMailAddressContainer; CC: ‘blank’ BCC: my e-mail address; Subject: Whatever Message: “Dear SSS Participant,” & “PP”]

// “One mail using data from currnt record” radio button is selected

// “None of the “For each message, collect address across found set” checkboxes are selected

Halt Script

Even thought he global text field contains all 361 e-mail addresses, the Lostus Notes “TO” field has only part of the very first record’s e-mail address…………….everything up to but not including the “@”

[example: 1st email is [email protected]; the “TO” field in Lotus Notes is “crlsadame”]

A couple of times I’ve narrowed my found set down to 5 or 10 recrods and it works fine. Is there a limit to the number of addresses that can be included??

Any suggestions???