Inserting Multiple values into Global field

[prissypan]

Hi all,

I'm wondering if this is possible, what i would like to do is to append all the email address from my list to a global field so that i can mass send emails to all addresses in the field.

I know using the sendMail script will enable me to send to many, but i needed a bcc field therefore has opted to use this format to create my send mail script.

Anyone please explain (or better still show me ) how does one append all/multiple email addresses from the list into the global field.

I'm also thinking is using global field the most appropriate choice? My email addresses will change time and again due to the increase of customers, so the values in the global field varies.

Ever willing to listen to your comments and suggestions.

Regards,

pris

[jscooper]

Loop through the records and append eac to the global field, one at a time. For example:

Set field [gField, ""]

Go to record/request [first]

Loop

set field [gfield,gfield & emailaddress & "

[Vaughan]

Just beware of FMP's 64KB character limit in text fields.

The Copy All Records script step can also be useful too.

[prissypan]

Hi jscooper, i tried the codings you provided but it seems setField only allowed me to enter once.

[EddyB]

hi, code should work fine. you may want to add a Show All Records at the start of the script, if you only have 1 recod showing when you run the script it will only deal with that 1 email address.

you may also want to put a check in there to check the email field is not empty, if it is empty then the code will add blank lines to the global field which could screw up the emailing - (don't know if it will screw up for sure, just a guess)

Show All Records

Set field [gField, ""]

Go to record/request [first]

Loop

If [not IsEmpty(emailaddress)]

set field [gfield,gfield & emailaddress & "

[prissypan]

Helloooo jscooper, i found out my mistake, your codes were PURRRRRFECT!

Thank You SOOoooooOOO Much!

-Pris-