Inserting field data into mail send

[dukedinger]

Hi FM users,

I'm pulling my hair out and hoping you can help me...

I've created a database for a research project I'm running at the moment and want to be able to use the send mail function. I want to be able to use information that I have inputed into fields and use this information in emails that are personalised based upon the record.

My DB is set up like this...

I have a 3 or 4 tables in my scenario, like: counsellors, clients, phonelog, and emaillog etc.

The counsellors table stores all my contacts information and details. The clients, phonelog and emaillog are all related via a counsellor ID and store information pertaining to one counsellor record.

I want to be able to do a send mail and type up an email in a field or file>send mail that I can insert field data into.

For example,

To: Counsellor contact::email

Cc:

Bcc:

Subject: Blah Blah

Body:Dear <>,

I'm just writing regarding regarding the research and following up on the clients X,Y,Z (I want to be able to insert this info from the related clients table - but this is my problem).

I can use the send mail and type only 'Counsellor contact::firstname', filemaker will insert the field record name into the body of my mail client (both in single or all record fashion).

However, I can't insert text (eg, Dear blah blah) and a table:field name.

On top of that, I have no F-ing idea how I could call into the body of the email only those records from the one particular counsellor ID.

Any help or suggestions would be great!

PS. I fear my DB is becoming complex and someone will prescribe a script... while I'm ok at finding my way around FM, I'm not overly familiar with scripts (and thats a little generous).