I've looked throgh the tech support on fmpro7 and they acknowledge the EMAIL SCRIPT issue where all is populated except the "to" in your email program. I happen to be using netscape but they mention outlook on XP but offer no solution.

Anyone stumble on to a fix

FileMaker Version: 7

Platform: Windows 2000

can you not just put "enter email address' in the to part and make sure that the perform with out dialoge is unchecked, then the user can enter the final address, or

do you mean when cc: is populated and not the to:

Unfortunately i need to automate this as much as possible and don't want room for error by mistyping. As for the script, I definitely need the "To" populated but i have tried the CC and BCC sections just to see if it works but to no avail. I sure hope FMPro support gets back to me!

I'm new to the forum but appreciate all your help Charles. Normally i tough my way through but this is an acutal job for a client and time is of the essence.

Do any of you use any other resources or forums?

Jared

I usually avoid the email script and send an email via a url string.

Substitute(

"mailto:"&email&"?subject=field1"&PhotoID&"&body=Hi "& FirstName & ","

,"

I use the plugin: MailIT with good results. Since outlook is so 'virus cautious' I don't get any warnings etc that would stop my bulk mailing. Perhaps you should be looking in that direction.

Rivet:

Why do you use the url method, is it so you can free up FMP right away?

Charles

I use the URL method because I use a non-system standard email client (MailSmith) which doesn't have the same hooks as Apple Mail. Same goes for other clients. If you have system prefs set for a particular browser and email client the URL method typically performs very well versus the system call to the "email" client. YMMV

Rivet:

Why do you use the url method, is it so you can free up FMP right away?

Charles

Hi All,

I need to send an html email as well. There MUST be a way to send without a plugin. I am trying to craft the url method but don't understand how i might encode the url so it shows up as HTML in the message.. Someone help! Do i need to replace all html entities?? ie: < > / " etc??

you can ODBC it with ms word and thus get a mail merge, a note though: MS word's html email merge is partially broken, The hyper links inside the email body don't work. It also still has to go through the Outlook security baffle (if you used outlook)

Daecons MailIt plugin trail works for 30 min before it Kak's. I guess you could get all your emails queued and send out . Then buy it later once you realize it's value. I did something like that.

Charles

I ended up buying the mailit. Pretty cheap considering the power! Miraculously they fixed another issue with a sister plugin to called launchit. Def worth checking out for future reference if you have no need now.

FMpro has had no solution for the "to" thing that i initially posed.

hi Charles, I use the URL for the same reason you do. It is the most compatible on all platforms with all email clients. Why today I just tried the email script in FMP7 (just curious) and I was given grief right off the bat. I found that if and address has punctuation in it (in this case a period in name portion) AppleMail will paste the address in twice. So although a the mail script has a nice dialogue it will cost me in the long run.

oh no!!! - just found out that the url script (fmp7) sets all characters to lower case. @$^!#

I am having a similar problem with filemaker pro 7 changing my URL and changing everything to lower case. My server does not like that! I am going to try a work around using Applescript.