I am having problems setting up aan automated email from filemaker pro.

I would like to have my email subject look like this when sent.

-------------

Hello <<Name>>,

We can help you with the following:

<<Field1>>

<<Field2>>

<<Field3>>

<<Field4>>

Thank you,

Our Staff

-------------

In the email script is ask for either text or field.

Can I format a field to include merge fields?

When I made a paste field It looked very seperated by spaces if the field3 and field 4 where not included.

Create a calculation field that builds up the message that you want. Specify this field in the Send Mail script step.

What is the calc I use for text?

I tried some of the text calc's but I couldnt get it to work.

Define the calc field...

"Hello " & name & "

Thanks Vaughn it worked great.

I, too, am having some oddities here.. My jobticket DB has an estimate layout for printing out estimates.. I can get everything formatted there as I like (via merge fields), but if I send the same thing as email, number formatting does not come over... The data that is returned vial email is:

We are pleased to provide an estimate on your job as follows:

Total Film Price is: 1004.4 1004.4

Total Proofing Charges are: 750

Total Scan Prices are: 0

Total Inposition Charges are

Anticipated Manipulation Charges are: 0

Resulting in a total of: 1754.4

None of the number fields are formatted into currency.. Any way of doing this?

The best way, when taking it out of the program, is to not send the actual number field, but a converted-into-text field, calculated to look how you want it. That way, it saves the number not as a number, that each program will interpret by its own whim, but as a stable string of characters

From a number field, "Money_Number_Field", this (somewhat ineleganat - sorry) calculation will return text formatted as currency as either $28,566.25 or -$89.15. It handles up to 12 digits accurately or up to 15 digits with inaccuracies in the cents area. Hey - as long as you're not emailing Bill Gates' bank balance, that should be OK?

If(Money_Number_Field<0,"-$","$") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>12,Left(NumToText(Int(Abs(Money_Number_Field))),Length(NumToText(Int(Abs(Money_Number_Field))))-12)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>9,Left(Right(NumToText(Int(Abs(Money_Number_Field))),12),Length(Right(NumToText(Int(Abs(Money_Number_Field))),12))-9)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>6,Left(Right(NumToText(Int(Abs(Money_Number_Field))),9),Length(Right(NumToText(Int(Abs(Money_Number_Field))),9))-6)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>3,Left(Right(NumToText(Int(Abs(Money_Number_Field))),6),Length(Right(NumToText(Int(Abs(Money_Number_Field))),6))-3)&",","") &

If(Length(NumToText(Int(Abs(Money_Number_Field))))>0,Left(Right(NumToText(Int(Abs(Money_Number_Field))),3),Length(Right(NumToText(Int(Abs(Money_Number_Field))),3))-0),"") &

"." &

Right("00"&NumToText(Round((100*(Abs(Money_Number_Field) - Int(Abs(Money_Number_Field)))),0)),2)

_ _ _

You can also get formatted numbers into a text field by using a script.

Create a new totally empty layout and place the Money_Number_Field on it. Format this field to display how you want the number to look. Then run this script:

Go to Layout [your new layout]

Copy Record

Go To Layout [Original Layout]

Paste [select][Money text Field]

If you have more than one field on the new layout, this will copy all the fields and the formatted contents will be pasted with TABs between them.