How to create a form letter to Email

[tarheel]

I need to create a button to send a form letter via email. How can I create a form letter with inserted database fields? I tried using the header only field of a layout but can't figure out how to email it. I am using FM8 & XP.

Bob...

[bcooney]

I need a bit more detail of what you're attempting, but a simple solution is to create a calc field, such as LetterBody_c and have it equal to:

"Dear " & Customer::Name & return &

"this is the text that I want in the letter."

Use a script with the send mail script step. Have the body = LetterBody_c. Set the emailto equal to Customer::Email.

This is an easy way to create a customized email. With a looping script, you can send an email to each customer in a found set.