Inserting custom fields into email text

[MikeAir]

Hi there,

 

I have a database where i have some related tables with different information regarding an order. I want to create a customized email for the customer with a standard text, and some variables that will vary, depending on which record they are related to(different costumer data, order data etc.).

 

Is this possible?

 

 

 

I get a lot of errors when i try to customize the email this way - do i need to make "" or () in order to include more than one field in the message? 

 

Or is there another way to do this?

 

Thnanks in advance,

 

Mike

[eos]

Wrap your literal text in quotes, and use the & operator to concatenate them with field references (which you do not quote).

 

So your text calculation would begin like this:

"Dear " & Venues::FirmaNavn & ",¶
here is your information … regarding " & Bands::Bandsname & ", " & Orders::theDate & "¶¶
Contact information: " & Employees::Title & ", " & Employees::Firstname 

etc.

 

FileMaker ignores any returns you type within the calculation dialog – you need to use the ¶ operator to insert the desired number of carriage returns. (Which is a good thing, because this allows you to format your calculations without impacting their result, and you can calculate the number of returns to insert.)

[MikeAir]

And once again you save me Eos!

 

Thank you! That was just what i needed.