Personalizing an email with "Send Mail"

[aslink]

I've got a project where I get a lot of hand written memberships. After the data entry I would like to click a button and have an email created with the members first name and their other info automatically put into this email.

For the most part everything else is in place as far as the script goes. However I've tried a couple of things and looked through several books I have and nothing seems to help. I'm hoping this is possible because the next step after data entry is to enter their email address into an email server so they can receive our posts. I'm trying to create an easy way to double check their scribbled info to help cutdown on bounced back emails.

I tried something like <database name::field name> to have the email start with the members first name but it didn't seem to work I just got the info I typed, not the first name.

Thanks in advance,

Ken

[Orlando]

Hi Ken

This is possible if I understand you correctly.

What you need to do to get the members information into the body of the email is in the Send Mail script stet select

[ralph.nusser]

In FileMaker 7 you have the Evaluate function:

You have a form email letter:

"Dear " & First Name & " " & Last Name & "

Evaluate.zip

[aslink]

Thanks Ralph.

The whole "& &" was perfect. I knew as soon as I saw the "&" that that was what I was forgetting. Being away from FileMaker for almost 10 years is not helping me. lol

Thanks again for your help.

Ken