What's the best way to send data via email?

[jfrick]

From Windows... Should I try a mail merge into using MS-Word? Or export a dbf and import into Excel. Or is it possible to create an e-mail straight from FileMaker.

[andygaunt]

Create a set of fields specific for the email, subject and body.

If you want data in the body you will either have to hard code in a calculation field

"Dear " & Name & ", " &

"Hello there. This is an email" etc...etc...etc.

Then write a script using the send mail feature.

Click the specify button and set email address, subject and body to use fields.

Then you can send your email.

If you perform without dialog you will not see the draft window appear.

If you want to send a group of emails, write another script to loop through the found set.

Go To Record [first]

Loop

Perform script [the send email one]

Go To Record [next, exit after last]

End Loop

HTH