Welcome to the forum, AndrewPSS!
- In ScriptMaker, choose 'Send Mail'.
- This will allow you to specify what data to include in the message body (and other stuff).
- You can also select the option to 'Perform without dialogue', so it will send 'silently'.
- You may want to make a loop in your script that goes to the first record, generates the e-mail message, sends it, goes to the second record, generates the e-mail, etc.
Alan, thanks much, creating the email script was easy. I can't figure out how to insert a field name in the text of the message. When I click the field name in there, it deletes the message.... Your suggestion will be appreciated! Thx, Andrew
When you set the "text of the message" you have three options:
1. Specify field name...
2. Specify calculation...
3. Insert text from file...
All accessed from the arrow button to the right of the message area.
What you want to do is to specify a calculation. This gives you access to the calculation engine and you can construct something like:
"Dear " & firstname & ",¶" &
"How are you? I see that you have enrolled in the " & enrolcoursename & " course on " & coursedate & ".¶" &
"I look forward to meeting you in " & courselocation & ".¶" &
See how you can string together text with fields?
David, thanks so much for taking the time to explain this and the syntax - works perfectly! I had been using ACT but hated it - very tempermental. I actually still use the original version of FM1 on an old Mac, so this is very different. I appreciate your help and the ability to go to these forums.
Regards from the top of the world!
Thanks for the info - I am now able to perform a email merge, almost - after each record that goes to outlook a security blocker comes up and asks me to Allow or Deny or Help - the help does not work - how do I great a digital signal of filemaker pro so the software (outlook/windows) recognizes the software and allows it to use the outlook email without asking permission? Thanks for your help,
How to write a loop for all the contact record in the database?
All I know is if ( i < maximum ) , but how to determine the maximum?
I appreciate the assistance and comments.
Basically this is what I would do...
Go to Layout ["LayoutName" (databasename/tablename)]
Show All Records
Go to Record/Request/Page [First]
Instrucctions that you want to do for each record.....
Go to Record/Request/Page [Next; Exit after last]
This is a very old thread. (Feb 4th 2009) Anything where the date in the first post is more than 3 months old no longer pops up into recent items. Thus, your replies may well be missed by many forum users. You may want to start a brand new thread so that it appears in recent items and then include a link to the original thread if you think its content is relevant to the new thread.