email found set / multiple fields

[innodes]

Is there a way to "merge" a found set of multiple fields into an email? I need to take the data from a specific layout and the found set populating it into an email.

thanks

[mr_vodka]

You can gather the data into one variable (or global field) using a loop. Then refer to that and send it.

[innodes]

Can I code in tabs and hard returns to "format" that data?

If so what would I use for the tab and return? I would assume it could be in the calculation, added with:

"field" & tab-something & "field" & return

or something like that?

thanks

[mr_vodka]

field1 & " " & field2 & ¶

You can actually insert a tab by typing in a tab while holding down Ctrl on a PC.

You can also set up a global field or variable to store the Ctrl-Tab so you can just refer to the global or variable if you use it over and over again.

field1 & gTab & field2 & gTab & field3 & ¶

[innodes]

great,

thanks loads. I'll kick it around.

have a great weekend.

[innodes]

OK, next question is how do I insert this text into an email? I see in the send-mail script command the message area. How do I place this global text in the body?

thanks

[mr_vodka]

Refer to the global in the specify by calc or field name.

[innodes]

Thanks for the help. I was pulled off of this shortly after your answer, but it is now back on line.

2 questions,

1:

What is the best way to view a variable in a layout? I placed it in a text within a merge field, but didn't work.

2:

I have the variable built, but how do I "stack" the data? This is what I tried. It seems to be overwriting not adding.

the variable is $mfgrel_list

the line in the loop is:

set variable [$mfgrel_list; value:$mfgrel_list & ¶

The hope was that it would append the data by grabbing the existing variable data first, then adding the current record data to it.

thanks

[innodes]

Since this is 5 months old I cleaned up the question a bit and started a new post. I hope that is not a problem. It is at:

http://fmforums.com/forum/showtopic.php?fid/36/tid/208001/pid/329932/post/last/#LAST