Jump to content

Get Result of Merge


johnmcad
 Share

This topic is 7197 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

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 & "
Link to comment
Share on other sites

This topic is 7197 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.