Help with Email address and can you personalize?

BigZilla · June 17, 2003

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

EddyB · June 17, 2003

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.

BigZilla · June 17, 2003

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

EddyB · June 17, 2003

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.

Anatoli · June 17, 2003

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.

BigZilla · June 18, 2003

Hello again Gentlemen,

I have duplicated your script and tried it with

Anatoli · June 18, 2003

SMPTit

EddyB · June 18, 2003

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.

BigZilla · June 18, 2003

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

Unable · June 18, 2003

I suggest you post your script for us to see.

BigZilla · June 19, 2003

My script is.

Go to Record/Request/Page

[First]

Send Mail [TO: Email, CC:

Anatoli · June 19, 2003

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

BigZilla · June 19, 2003

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

Anatoli · June 19, 2003

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

The difference is, that your code is longer.

As I suggested -- SMPTit

BigZilla · June 20, 2003

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

Ugo DI LUCA · June 20, 2003

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.

BigZilla · June 20, 2003

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

Ugo DI LUCA · June 20, 2003

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.

Pupiweb · June 21, 2003

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

Anatoli · June 21, 2003

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".

BigZilla · June 23, 2003

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

Anatoli · June 23, 2003

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.

BigZilla · June 23, 2003

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

Anatoli · June 23, 2003

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

Ugo DI LUCA · June 23, 2003

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 ....

BigZilla · June 23, 2003

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

Ugo DI LUCA · June 23, 2003

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 & "

cjaeger · June 23, 2003

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.

Ugo DI LUCA · June 23, 2003

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

cjaeger · June 23, 2003

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/

BigZilla · June 23, 2003

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

Ugo DI LUCA · June 23, 2003

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.

BigZilla · June 24, 2003

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

Ugo DI LUCA · June 24, 2003

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".

BigZilla · June 24, 2003

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

Sign In

Help with Email address and can you personalize?

Recommended Posts

Create an account or sign in to comment

Create an account

Sign in

Important Information