I created a field called EmailBody, and am trying to create the following calc. Trouble is I don't understand what I am doing. Can someone explain this in more detail. What does the " do? What does the

mboyd,

You are very close.

- Text is entered between " "'s - "Hello World" returns - Hello World

- A carriage return is entered as "

thanks for taking the time to reply, that helps, has anyone made an interface/script that would do the converting ? Can such a thing be done? I got a bunch of long letters with lots of merge fields.., and it will be quite time consuming...any ideas?

thanks

Go to http://www.databasepros.com

John Mark Osborne's site

Go to Resources

Do a search for "Custom Form Letters"

There are 4 versions, from basic to more advanced.

Attached is a custom function that I built to do this, you can read about it here:

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=120434

But if you don't have access to FM Developer, there's a way to hard code the fields into the results calc using the Substitute function:

resultCalc (calculation; text result) = substitute(SourceField;

["<<First Name>>"; First Name];

["<<Last Name>>"; Last Name];

["<<Date>>"; Invoice Date])

FieldSubstitute.fp7.zip

Go to http://www.databasepros.com

John Mark Osborne's site

Go to Resources

Do a search for "Custom Form Letters"

There are 4 versions, from basic to more advanced.

nice site, but there is nothing there that will take your merge fields and make them ready for a calulation.

basically I just want to put my form letter (with merge fields) into the body of an email.

Is there an alternate way to do this instead of putting a field that is a calc in the email body.

Maybe there is a way of copying the final letter from preview mode to the clipboard then pasting it in the email body. Currently i am successful using the pdf way, but just want to have it in an email in case my clients can't handle pdfs for whatever reasons...

thank you!

Attached is a custom function that I built to do this, you can read about it here:

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=120434

But if you don't have access to FM Developer, there's a way to hard code the fields into the results calc using the Substitute function:

resultCalc (calculation; text result) = substitute(SourceField;

["<<First Name>>"; First Name];

["<<Last Name>>"; Last Name];

["<<Date>>"; Invoice Date])

Thanks for your imput ender, this is above my head, your recommended thread had some very impressive custom functions.. =)