I currently send Emails out (I do not need to receive) of my FileMaker Pro 6 (no plug-ins) and I use Outlook Express. We have been doing this

Hi

Both questions are possible

1) You would set up a looping script to pick up each E-Mail address individually rather than specifying all the E-Mail addresses in 1 E-Mail.

You would set the script to perform a find on all records where an E-Mail needed to be sent.

Then the script would go to the first found record and send mail

Loop

Go to Record Next, exit after last

Send Mail

End Loop

2) Yes:

Field - First Name

Field - Product

Field - Quote

Calculation Field - c_Message

c_Message=

"It was good to see you " & First Name & " and we are happy to give you a quote on your " & Product & ". Our quote is " & Quote & " and is good for 90 days from the date shown above."

You would then set the E-Mail message text to be specified from a field - the c_Message field.

Hope this helps

Ed.

Hi Eddy and thanks for the reply.

I did not try the calculation as yet but I'm having trouble with the script. I still get all of the found Email addresses in the TO: field. And if I am sending 5 Emails, I have to press the Send button 5 times.

What am I doing wrong?

Bill

OK,

Create this script:

(Your find request script goes here then...)

Go to Record/Request/Page [First]

Send Mail [No Dialog, specify the E-Mail criteria]

Loop

Go to Record/Request/Page [Exit after Last, Next]

Send Mail [No Dialog, specify the E-Mail criteria]

End Loop

By selecting Perform without Dialog on the Send Mail steps, this eliminates the need to have to press send on each E-Mail.

Hope this sorts it for you, if you need anymore help just post again

Ed.

RE: By selecting Perform without Dialog on the Send Mail steps, this eliminates the need to have to press send on each E-Mail.

That is correct. The problem is, that some clients are ignoring the Dialog settings. I guess that SMPTit plugin is better solution and that's why we just bought license for 25 machines.

Hello again Gentlemen,

I have duplicated your script and tried it with

SMPTit

Firstly the Dialog box...

The dialog box is actually coming from Outlook Express as a security feature. In your outlook security options there should be a preference like "Warn me when other applications try to send mail as me" You need to turn this off for there to be no Outlook contact at all.

Even though you have selected no dialog, this Outlook dialog comes up as it is a security feature, so if you do not want it at all, turn off the option.

Now the 3 E-Mail addresses...

The only thing I can think of is this. When you set up the Send Mail script step you click on Field Value to specify which field the TO should be gotten from, you obviously then would select the E-Mail address field. Now when selecting the field, below the field list there are 2 options:

Use Current Record

Use all Records in Found Set

Make sure the first is selected otherwise as you say the 3 E-Mails will all contain the 3 E-Mail addresses

Ed.

Hi Ed,

I'm sorry to bother you again but I must report "no joy". I clicked the "Use Current Record" and that's all it e-mailed was the current record. To send the other two I had to manually press send.

Bill

I suggest you post your script for us to see.

My script is.

Go to Record/Request/Page

[First]

Send Mail [TO: Email, CC:

It will be better as:

Go to Record/Request/Page

[First]

Loop

Send Mail [TO: Email, CC: “”, Subject: CompanyName, Message: Products::Emessage, Attach:””]

Go to Record/Request/Page

[Next, Exit after last]

End Loop

Hi Anatili and thanks for the post.

I tried it and it made no difference. Send had to be pressed for each e-mail.

I have no idea where CC: “” and Attach:”” mean or where they are to go. Can elaborate?

Any help anyone can give would be greatly appreciated.

Thanks,

Bill

That was created by this forum from copy of your code.

The difference is, that your code is longer.

As I suggested -- SMPTit

Hi Anatoli,

I really do not want to go the SMPTit direction, not if it can be don out of FMP 6. All I need to do is send mail and from what I understand FMP can do this. I just need to get this address thing figured out.

Bill

Hi,

Agree with Anatoli that SMTPit is what you need. You would even be able to attach a document to your mail with this Plug-in.

So what you're saying is, what I want is not possible in FileMaker 6 and I must go to a Plug-in, right?

With a Plug-in, SMPTit specifically, as it sounds like the Plug-in of choice. Can I still put my information in my own solution and mail it, keeping SMPTit completely in the background. Or does it come forward and show itself?

Bill

Hi,

SMTP is a Plug-IN, so it becomes an Internal feature of FM, not an e-mail solution as Outlook, Eudora,...

It get scripted using the external calcs of FM calculations.

With SMTPit comes a great "How to Use Pdf File" that says all you need to know about.

Not sure it's an Online Pdf file though, I could mail it to you if you need it to have a cleared view of what it can do, and its multiple functions.

You already received excellent advice on the two issues

- one email address per email: can be done, using a looping script

Loop

Send Mail

Go to record next (exit after last)

End Loop

You might alternative use the mailto protocol coupled with an Open URL () step

Whatever the method you'll end up having the messages created in your default email client BUT NOT SENT

If you want to fully automatize the procedure use a plugin; I'd suggest SMTPit by CNS

- messages personalization can be achieved creating a calc joining the message and the other relevant fields; if you want to make dynamic create a global text field in which you write the message and put some placeholders like [Contact]; use a calc substituing all placeholders with record data for the message body

RE: keeping SMPTit completely in the background.

Sort of. It will send everything in background, but FM in front will be during that time "busy application".

I downloaded a copy of SMPTit and it did what I needed it to do, "sending multi e-mails and only show one address for each". But can you e-mail directly from your own solution without having to import addresses to SMPTit. If I have to import, that will cause trouble and if that is the way it must be done in SMPTit. Is there another Plug-in where you can send directly from you own FileMaker solution?

Bill

RE: Is there another Plug-in where you can send directly from you own FileMaker solution?

: I don't understand a bit. SMPTit is doing just that.

Hi Anatoli,

Maybe I missed something in SMPTit! I do not find anywhere in their instruction book where it tells how to fax from your own address book from your own solution. All I've seen is where it says to "Import" the addresses into SMPTit.

Talk me,

Bill

RE: All I've seen is where it says to "Import" the addresses into SMPTit.

By "SMPTit" above you mean to copy from your database to SMPTit database?

You can program every single aspect of SMPTit *plugin* into *any* FM database.

HTH

Hi Bill (or Buddy )

What are you talking about ?

1. Flag the records you want to mail

2. Lauch your script inside which is a Loop with the SendMail script using SMTPit.

With the Plug-in, you should have received a sampler for a MassMailing. Just check it ....

You FileMaker folks give us new guys a lot more credit for knowledge than is our due.

1. You say "Flag the records you want to mail" What's a flag? What's a flag in my yard have to do with e-mailing? Or is it the same as Search or find?

2. RE: Lauch your script inside which is a Loop with the SendMail script using SMTPit. What in the world are you talking about. I do have the MassMailing file but it does not show me, tell me, or elude to, how I send e-mails from my own file. You guys must really have a good time messing with the new guys. It's like, here, hold this spark plug while I start the engine! Or get behind the car and tell me if my right directional signal works. Yep, nope, Yep, nope! I'm going to learn a bunch about FileMaker, so maybe I can have as much fun with you guys!

Bill

Pasted from the pdf file....

1 Enter Browse Mode []

2 Go to Layout ["Main"]

3 Replace [No Dialog, "Send Result", """"]

4 Set Field ["Start Time", "Status(CurrentTime)"]

5 Perform Script [sub-scripts, " _ Connect"]

6 If ["PatternCount(Setup Result, "ERROR:") > 0"]

7 Show Message ["There was an error setting up the email. Pleas..."]

8 Else

9 Go to Layout [Refresh window, "List"]

10 Go to Record/Request/Page [First]

11 Loop

12 Perform Script [sub-scrips, " _ Send One"]

13 Flush Cache to Disk

14 Go to Record/Request/Page [Exit after last, Next]

15 Refresh Window []

16 End Loop

17 Go to Layout [Refresh window, "Main"]

18 End If

19 Perform Script [sub-scripts, " _ Disconnect"]

20 Set Field ["End Time", "Status(CurrentTime)"]

21 Perform Script [sub-scripts, " _ Calculate Duration"]

Lines 11 through 16 contain our main mail-out loop. This is the section of the script that gets

repeated over and over for every single one of the records in the database. Line 12 calls the Send One

script which sends an email with the Contact information in the current record. We will look at this

script in a second.

The SendOne script :

1 If ["not IsEmpty(Contact Email Address)"]

2 If ["Contact Name <> """]

3 Set Field ["Send Result", "External("SMTP-ToAssign", """" &..."]

4 Else

5 Set Field ["Send Result", "External("SMTP-ToAssign", "<" & ..."]

6 End If

7 Set Field ["Send Result", "Send Result & "

1 - flag -> select, mark whatever using a field/checkbox etc

somehow you will have to tell the program what records to send ...

(those with a "1" in field sendit, for example)

2 - If you own (or try) SMTPit, you'll know.

-------------

could you specify your OS and platform?

It might(should) be possible to do without the SMTPit plugin.

From post above...

repeated over and over for every single one of the records in the database

You should read "repeated over and over for every single one of the found set in the database"

Have fun

if you are on Mac (which I guess from Outlook express not sending directly), have a look at thisvpage, tips&tricks section.

http://www.dwdataconcepts.com

It shows bulk email using FMP 4 & Applescript, no send mail script step required.

and have a look here

http://www.webmastermac.com/tips/applescript/

Hi Ugo,

I know that the above script is in the "MassMailing" file as the GO script. But what I don't understand is how does this script in the "MassMailing" file do anything for my own file? I want to mail out of my own custom file, I do not want to mail out of the "MassMailing" file. Is there a way that I can use my own file, with my own e-mail addresses so I do not have to use the "MassMailing" file and do not have to export my addresses. I just can't get my brain around what you are trying to tell me. It seems like we keep going in a circle with no end in sight. I know it's my fault and I apologize for it, but I just don't get it. Am I to put the script you show above in my solution, or am I to call this script from my solution? I don't understand!

Bill

Bill,

The script given is the "MassMailing script" from "Massmailing" sample file.

But you will us the "MyMassmailing script" from "Yourfile".

You don't need the Massmailing file...it was a demo file...Just copy/paste the scripts given here and in your sample and booklet in YOURFILE, call the script what you want it to be.

Again, SMTPit is a PlugIN, not an external application as such. It works combined with FileMaker, INTO FileMaker files.

Hi Ugo,

Just to make sure I understand. I put the "GO" script from the MassMailing file and the other scripts, "Connect","Send One" etc., into my solution. Including the fields that are called from the scripts such as, "SMTP Host" "HTML Body" "From Email Address" etc. Is this correct so far?

Bill

Yes.

Of course, modify the script so that the fieldnames are those of your solution.

It's a FM script though. If you need more functionnality, you can hopefully personnalize the script given as a "wizard".

Hi Ugo and thanks for getting back to me.

RE: you can hopefully personnalize the script given as a "wizard".

What is a "wizard?

Harry