Is there a way to email directly from FM5? I am for some reason under that impression. I maintain a mailing list database and would like to be able to email new records to my fulfillment house to ship my product. Then, upon successful transmission, I'd like the new record's status to no longer be considered "new", thus paving the way for more "new" records.

Thanks.

Hello

That is a very interesting project. Yes you can send your new records as e mails to specified email adresses, follow those steps :

1.First you should have a seperate database for your emails.

2.Then on your main database create your new record, fill in the necessary fields.( subject, message , ... )

3.On the same layout create a portal . In that portal see the list of the email adresses.( depends on your need specify a relation relation )

4. Create a field to count the records in that portal, name : portal_count

5. Create a field, name :counter / number

6. Create a field, name :e_mail / text

7. Create a script, name : send_email:

set field:counter,"1"

loop

go to field email in portal

go to portal row , field value, counter

set field email , email in the prortal ( whatever relation name::email_adress)

send mail

email adres : field name: email

email subject : subject

email message : message

set field : counter = counter + 1

if the counter > portal_count , set field counter=0 exit script

Loop end

I think that will work. try it ,

I will be very happy if I hear about your work

Happy days

abkaplan