Hi Forum,

I'd like to send the result of a merge to a file. Even copying it to the clipboard would be a help. For example I've merged some names and addresses with a form letter now I want to email the letter to someone. How can I export the finished letter?

Thanks in advance!

jmc

Well, there's the Send Mail [ ] Script command...

Also Export Records...

And if those don't work, just click outside of any field (or use Go To Field [ ] in a script) and use Copy...

Oh wait, I see -- you merged into some text you typed in Layout mode. Got it. You'll need to type or script that text into a field. A global field will do. So the script would be something like:

Set Field [globalEmailText,

"Dear " & Name & ",{P}{P}" & etc.

-- {P} is the paragraph symbol.

Send Mail [globalEmailText]

Not sure what you mean by "merge." It has no meaning in FileMaker Pro -- not like it does in say Ms Word where a data file and a letter form are "merged."

Field data is displayed on layouts. If you want to build-up the text for a letter or e-mail message, use a calculation field:

code:

---

"Dear " & Firstnamefield & "