Email

I'm needing a little clarification on something. I have a whole bunch of records, and a whole bunch of PDFs that I need to send out to the right person. The title of PDF includes a page number of a book spread I need a particular contributor to read and sign off. I have that same page number in the record where the info on the contributor resides. Is there a way to conditionally attach the corresponding PDF to the correct person's email? I've tried making the specified email attachment be seen as a Calculation like: Case(MyTable::MyPageNoField = "1" ; filepath to page 1 pdf; ... etc but it doesnt want to work. Any further ideas?

I want to use "SendMail" command. It sends a single or multiple mail programatically on the basis of found set. But i could not send multiple attachments. Even manually adding multi attachments, it sends only one attachment. Is there any setting which restricts to send multi attachments? Is there a way to tackle this multi attachment problem programatically? Please convey. FileMaker 8 adv/pro O/s- Windows and Mac OS 10

Righto then, i have filemaker 8 pro... yet despite what i read somewhere the send mail script step still asks me to specifically reference a particular file instead of allowing me to reference a field with a file path or something similar... i know a way i could do it with one static attachment with the user being able to change the file and it just exporting to the defined location... but i need multiple attachments for different user modifiable and addable email templates etc... Also, is there anyway at all to incorporate a stored image into an email (im guessing not seeing as the result is locked to text)... but if anyone has had any success with using pre-define…

Hi there, I have a whole bunch of contact records with email addresses, and a whole bunch of PDFs that I need to send out to the right person. The title of each PDF includes a page number of a book spread I need a particular contributor to read and sign off. I have that same page number in the record where the info on the contributor resides. Is there a way to conditionally attach the corresponding PDF to the correct person's email? Please help.

Hi there, I've been sending huge batch emails out as text using the 'Send email' script-step and Applescripting to Entourage, with great success. The emails are autogathered using a lot of personalised fields from my customer database, but now the powers that be would like to incorporate HTML. Can someone please tell me what I need to do to compose in HTML, which can be peppered with the same kind of personalised fields as I had going with the text emails? Paul

Is there any way to set the "Send Mail" script step so that it allows the user to select an email attachment? I'd like to be able to open up some sort of browse window so that the attached file could be selected at the moment of creating the email. I have a feeling that there is some way to place a file in a global container field and then reference that as that file to attach, but I can't figure it out. Thanks Jake :P

I have set up a send mail script, and assigned it to a button... I am in a 5 computer LAN and the script works on all computers, however on 2 of the 5 the default signatures are placed at the bottom of the email. I have verified all of the pref's are the same. I have even tried deleting pref's to create new ones. How can I make the Signatures show up on the emails?

I have a very particular problem with a client who is using Outlook. When I script to create an email (but not have the email sent without dialogue), my users must actually send the email before they can either return to Filemaker or do anything else in Outlook. I don't, however, experience the same problem on my Mac with Mail. (And the Outlook users can create messages, keep them open, and do other things in Outlook normally.) What is going on, and how do I fix it? Has anybody else had this problem? (Oftentimes people will need to do other things before sending the mail.)

I have set up a send mail script and assigned it to a button..... How can i identify if an email has been sent out for that record? Any ideas?

I have FM7 and was told to purchase the smtpit pro plugin for emailing thru FM. I really don't know how to use this plugin. I am wanting to send a record through smtpit pro but I have no idea how to go about it. The documentation that comes with the plugin doesn't seem to be very helpful. Any tips and/or tricks, any leadway into the right direction would be great, thanks!

This is a Mac OS X 10.4x installation. We would like to be able to email a personalized PDF to a subset of our address file and incorporate information from a linked table in the PDF. This is a registration database. We want to be able to send out a pdf (with letterhead graphic) reading "Dear Someone, Thank you for registering for some class. Some class will meet on some date in some building. " The email address and the name (someone) come from a people database. the some class, date and building will come from a classes database. I know that I can do this without the pdf by using the send mail scrpit step, but the boss really wants it to go out as a…

Hi guys, Is there a way for FM5 to automatically send an email when a record is added?? Thank! Sarah

The website for FMPRO (as did the salespeople for the company) indicated that I could email container fields using FMPRO 8. OK, so they have added the email to the menu bar rather than having to script it - helpful yes, but how do I email the pdf file contained in the container field? I hope the answer isn't that it has to be saved in a file on the desktop or something to that effect.

My desired end result is to email one record having formatted HTML embeded in the body of the email. In DreamWeaver, I created my HTML template and where field data would go I added <> tags. In my database I have a global field that contains the HTML code I copied from DreamWeaver. I have a calculation field which uses Sustitute to convert the <> tags to the record fields. In the Send Mail step I specify in the message body the global that contains the formatted HTML. Instead of formatted HTML in the email I get the same HTML code from DreamWeaver. What did I do wrong?? Any help is much appreciated

Not an expert, trying to make my program work, and would appreciate some help, bearing in mind I will need details please! I want to put a button in the layout that will email to the designated recipient the contents of the several fields in the current record. All I can get it to do is send the details from just one field. How can I get it to send the information from about 12 fields from the same layout, same record, in the email? Can I make a PDF file for example and email that? Please give me enough detail for me to duplicate the process, and thanks in advance.

Hi Guys?Gals i am a newby and can get scripts to work but do not know how to have my database send an email from a a calc field result- 21 days before a date and or 20 hours flying time before my service comes due.Can you help please Col

We are hosting a membership database for a non-profit organisation on fmp 6 unlimited. They need to also keep a current copy of the database on their computer. I've been trying to create a backup and email button that would create an ascii file from the fm and email, zip it and email it to them. I've created a home page where they logo on, I would have the backup button there because once logged on, they use instant web publishing (to save the cost down). I would also need to use Azium Events to schedule daily emailing. Tx for your help, Yves

My client tells me that since she upgraded to the latest version of Entourage (I'm not sure what that is...), every time she runs the group email script in the database, she gets a preview window for every message to be sent. I changed nothing in the script; it sets global fields for the message body, finds a set of recipient records, loops through those records and sends out a separate email addressed to the recipient. In earlier configurations with Entourage, she did not have these troubles. For completeness sake, the script step reads: Send Mail [ To: People::EMail Address; Subject: People:_c_MailSubject; Message: People::_c_MailText ] [ No dialog ] Since I d…

My client wants an automatic email sent using a calculation based on a date + 1 week. They want the program to send this automatically, so no button is pressed. Is this even possible in Filemaker? The database would be hosted on a filemaker 8 server, on a windows server 2003 machine. Right now I am thinking this just isn't possible with filemaker.

I use the specify mail feature in FM 7 to send emails of final invoices to my clients. I've noticed that when I look at the saved emails in my sent folder the "To:" field is blank. This is annoying because sometimes it is necessary to have confirmation that an email was sent. I can verify using the date in a field in my database but I would like to be able to see the data in my email client as well. Is there something I'm doing wrong or is this just inherent with sending email w/ the specify mail feature? The links below are screenshots of my specify mail screen and another showing the error in my sent mail folder.

I've been using SendMail by Digital Fusion in FMP7 to send email messages in the background, triggered by user actions in IWP, such as pressing a button "Send." However, I am planning t upgrade to FMP8 the the pluggin no longer works, even the version request simply returns "?." The vendor says it's a Filemaker problem. I trialed versions of several other plugins, including SMTPit Pro, email.it, PriorityMail, and NONE OF THEM WORK IN IWP using FMP8. Is this an FMP8 bug or is there something else I need to do to get mail plugins to work in FMP8?

I have a client that uses a service that does his mailing (email) list. I will automate that for him, but I am unsure how to register his clickthrus from the emails that will be sent out from his machine instead of that service. Can anyone help? I want to know how many from the emails actually got the click from the newsletter to his site.

Has anyone used BLAT for sending email straight out of Filemaker on Windows? I'm hoping to find a small, simple sample file that shows the calculation field required to create the command line that BLAT needs. In addition to the header info, I would have TO, SUBJECT, BODY and authentication. Thanks for any pointers.

Hi, I'm wondering if there's a plug-in, Applescript solution, or other means by which I could create a record in a FMP database by email. Essentially, I'd like to be able to send an email with the body: firstname: John lastname: Smith phone1: 800-555-1212 ... and have FM create a new record and populate it with the data included in the body of the email. I've looked around, searched forums, and haven't found anything which deals with this topic. If anyone has any thoughts on this, I'd appreciate it. Thanks! Doug Nelson

Can you suppress the email client window and have the email automatically sent in the background using open URL script step via IWP?

I have written a script in our FM7 database so that the user can click a button and it will generate a PDF of a quote, and then open an email message with some text, an email address drawn from the database, and the PDF as an attachment. It works great when we're working on the computer that hosts the database, but when we use "open remote" to access the DB from another computer it doesn't work at all. It seems to me that the PDF is being created on the host machine, but the email is being sent from the client machine, so the PDF can't get attached to the email. But I'm a novice at FM so I might be totally wrong about what's going on. Any advice?

Anyone know of a way to preserve number formating when e-mailing? Thanks, John

I am working for a PBS station and currently I am working on putting our pledge activities in a database. We have both radio and TV pledges. What we do in radio pledge is that we solicit donor for challenge grant and bonus gift (usually are in-kind) to offer our listeners. We do offer premium, but it’s only a handful of program over the weekend. The structure I set up works really well for radio pledge. I basically set up a solicited item table and scheduling table to track one solicit item can be scheduled in different pledge break. I am trying to look ahead for our TV pledge that should be happening in a few months. TV pledge is program driven. We offer premium for…

I fear the solution is blindingly obvious - to all except me. I have written a simple organisation membership db for a friend and she wants to be able to generate a list of email addresses which she can then copy and paste - presumably into the Bcc field. She wants to use Eudora/Mac OS9/ FM 5.5 - can't change old habits... I have created an email field and also an email_and_comma field. I fear the answer is some sort of loop procedure, something I've never been good at. Can some kind person help? Thanks

I'm sure that this has been covered somewhere, but I can't find it for the life of me. I'm running FM 7/8 w/ Server and want a method to allow a user to click a button on an order screen to email just a few fields and a line of text to the designated CSR for the account to let them know an order has been placed. I do not want any interaction with the user other than a possible message letting them know that the email has been sent. I do not want an external email application to be used. All users are on our WAN and are running both OSX and XP. We have an SMTP server that is open with no login required as long as it is to an internal email address. I'd …

I am trying to make script that when it sends this email, it puts this saluation at the beginning: Dear , AND I can put something like this in the middle: , we are happy to help you. Struggling with both of those.

Running FMP 5.5 Server on mainly Mac platform. One client(Mac OS 10.3) can not use the send mail feature. Nothing happens when they click on a button used for sending an email. It creates an email with a few fields added into the message. It works on any other client. I have noticed this before and was only able to fix by updating to FMP 6. I no longer have that option. I have reinstalled Filemaker 5.5 and the v2 updater. I reinstalled Entourage Office X. Nothing.

I have a 5 page invoice. I select to make it a pdf (in the print dialogue box) I'm on MAC OS 10.4.4 BTW. I see 5 pages generated, but when I click on the PDF from the desktop only one page is there. I've been beating my head against a wall on this one. any help appreciated. thanks.

I have no idea if this is in the right forum because I don't know how it is done. When an order is received, I want to send the customer an email which self-updates, indicating exactly where their order is in our process. It would look something like: 1/4/2005 3:47 PM Order Received 1/5/2005 8:00 AM Order paid (... insert either via credit card or net terms confirmed, etc) 1/5/2005 9:47 AM Order assembly in process 1/5/2005 1:11 PM Order checked for completeness 1/5/2005 3:00 PM Order shipped (... insert ship method) 1/9/2005 5:00 PM Anticipted delivery 1/11/2005 9:00 Order delivered (... insert tracking number) FMPug and Dell have both used…

Hello. I wasn't sure where to put this post so I hope I got the right place. I use the Send Email function within FM 8.0 without problem. However, in the email that I send I want to be able to include a "Mailto" link in the body. FM doesn't like that when I just type it in the text of the email like this: Unsubscribe I now know I can type the mailto code into the body, but it simply shows up as text--no link is available for people to use. I have my email program set up to send my mail in HTML and typing the mailto code into mail directly from my program works just fine, but not when I use this code in FM and send my mail from FM. Is ther…

Here's the situation... I have my FM7 database send out various automatic emails to vendors through my company email account. Currently, they send me confirmation emails and I have to manually copy and paste the emails into the associated record in FM7 so that I have the confirmation on record. Surely, you know what my question is. Can I automate that process some how so that the confirmation email from the vendors automatically go to FM7, and get stored in the right record???

Hi everyone I am having a serious problem and my boss wanted this. Is it possible to write a script performing in a file that check itself like every 15 minutes for any new record found? Lets say e.g. staff 'a' access the form from iwp or client from elsewhere, he/she submits it. And this script actually checks itself lets say every 15 minutes and when new record is found, it auto generate an email and inform the particular personnel. Can this be done?? i am really stuck in this and do not know what to do. Help are greatly appreciated Thanks a lot in advance Kelvin

I'm very new to FileMaker, while trying Email Campaign Management from the Starter Solution, I don't seem to be able to get all assignees' email addresses on the "TO:" field in Outlook. I want to be able to send one email addressed to all assignees. Any help will be appreciated. Joec

Hi If one use the 'send mail' script, one need to pre decide the filepath that one going to attach. How can i choose the file i wish to attach rather then deicided prehand inside the script? Thanks a lot.. Kelvin

I am trying to create a template that allows users to click on a number of buttons to create a customizable template for emailing. The "Email Campaign Management" application that comes with FM8 does exactly what I want in this respect (and a whole lot that I don't want in others), but I'll be honest in saying that, despite my knowledge and experience in FM, I don't know how they did it! : If after creating the layout with buttons and a field that gets populated with them, how do you convert that into a field that merges the data? For example, if I have in the template "Dear ...", how do I convert that to "Dear John" for one record and"Dear Jane" for another? A…

Hi everyone. In my form i did a button that open my default email appliaction 'Lotus' and user jus need to enter any more information they wish to state then click send. I put it up on IWP but users who do not have FM when clicked the button nothing happened, users can only choose 'submit'. And I finally found out why from the filemaker 7 guide book i bought. IWP did not supports emailing sript. Is there anyway to use a 3rd party client or plugs-in to allow users to send the form as email?? Thanks a lot.. Kelvin

Is there a way to email a record to someone? I see that FM has the email function, but that just opens a blank email. How can I attach the current record being browsed to that email?

Hello all... Is there a way to send e-mail without attempting to open the default mail client on the users computer? I would like to find a way to hardcode the mail server, the from, password etc. If anyone knows of a way to do this I would be greatful. Garry

Hi all, Using a German speaking OS 10.4.2 and MS Entourage. In the database, I have a text field in which I sometimes type text directly and sometimes copy and paste text from other sources. If I use the script step Send Mail to put the content of this field into an email, it is put into my drafts. There, the mail looks fine, exactly as it is in the field. When I then send the mail, two things happen: on top of the received mail the following info is added: Mime-version: 1.0 Content-type: text/plain charset="ISO-8859-1" Content-transfer-encoding: quoted-printable furthermore, diacritical signs (such as ä, ö, ü and ß) are being translat…

I tried posting this on the bottom of an old post and didn't get any response. So, I'm adding as a new post in hopes that someone will help. I want to track email history and display the data in a portal. So, when I send an email it relates to the contact record and tells me when and what email was sent. So, the portal should have the Date, Subject, and a link to the message. I set up an "Email Activities" table with fields: Message_ID {Number} eMail_ID {Number} Contact_ID {Number} - Related to Contacts eMail_Address {Text} Subject {Text} Message {Container} Calculated to populate the field based on a lookup from subject. I've got a script that will…

I am working on a hosted/multiuser FMP7 solution whose clients will be Mac OS X only. I would like to use the Send Mail script step for creation of e-mail messages with attachments. For the purposes of this question, let's currently assume that the file I wish to attach will be on the user's Desktop, and I will know the exact filename of the file to be attached, and that the filename will always be the same in all cases in which the script runs. Since the Send Mail script step requires a hardcoded file reference when using "Attach File", can anyone give me any insight into how best to specify this file reference? Remember that (1) my solution will be a host…

My client wants to be able to send an mass html e-mail to mimmic the look of a mailed letter. Basically all it involves is placing their logo at the top on the right hand side. A simple table would do fine. I know HTML well enough to be able to code this by hand (or so I thought), so I just modified the body field in the SendMail script to be "HTML code here" & message_body & "END HTML code" When it gets to outlook, it just copies the text over as if it wasn't HTML at all. This is the first time I've tried such a thing, so I thought I'd ask for some quick help

Is there any practical way to link all my emails for various clients to their FM record in my database? I really don't want to see all the text, but if it were possible to see the subject name and date of the email it would cut down on my search time.

My boss asked me if it would be possible to do the following with our filemaker recruitment system. They would like to have job applicants send in their application as an attachment to an email... they would like filemaker to check the email account and.. 1. if the subject line has a application # in it , the attached file & text of the email will be added to the matching applicant's record 2. if the subject line does not contain an application #, then the email will go into a queue to be dealt with.. so that the user can either a. create a record for this person, or b. attach the email to the appropriate record. basically, we're tryin…

Does anyone know if Groupwise will work with the Send Mail script step, if Groupwise is designated the default mail client? I have some new users to our system who don't use Outlook (for some silly reason).

OK simple question. My automated email goes to Entourge but then nothing. No email in drafts or anything. However my premade form emails have no problem going through. I want to have a simple email field to open up a blank email. I don't think it is a Fm8 since the script looks correct. Any suggestions. Michael

See image and you will see what I am trying to do. If you click to specify the field in the message body it only lets you select one field. If you then try to select another it clears out the field. So essentially I want it to output like 5 or so fields in message body similiar to the image below. What do i have to do? Thanx. image

The "send mail" function sends messages alright to my ISP email account, but all other recipients result in the following error: "The server response was: 5.7.1 This system is not configured to relay mail from to for dialup." Any help would be really appreciated!

When using the "Send Mail" function as a button, referencing a specific field for the email address i get 2 entries in OS X Mail's recipients field. Has anyone else experienced this? Any help would be appreciated!

Yes, we do not need to use static paths anymore. But is it also possible to attacht mutiple files to an email with filemaker 8.0 Thanks for your help. Kind Regards

Is it possible to email with an image within the message using fm7 func? i.e. not as an attachment but within the body?

I am new to File maker pro. I have been able to create a database for our IT hlep desk to keep track of tickets. But I am stuck. My boss wnats me to be able to click on the email button and that should automatically put in all the feilds and should look like this (exapmle)in the email: Requester Name: auto insert field (Sally) Location: Auto instert (bldg 43) Problem: Auto insert (printer not working) Status: Autuo instert (open) Get the idea? So by clicking send email and specify i see how you can insert fields. So on the subject line of the email I put in the ticket number field and there it shows the ticket number! So I think i am off to ao good start u…

Does anyone know if it is possible to send SMS notes out of FM using a bluetooth connection to a mobile phone on OSX. I can make it work through Address Book so I figure FM can too. Above all I can looking to send the same message to numerous numbers and wish to avoid using a web site. Thanks in advance

My client wants to add mail merge functionality to their FM-based contacts DB. They have created layouts within their existing FM file that print as form letters. I am re-doing the DB in kiosk mode so as to limit their ability to screw up layouts, scripts, etc. This will, however, also limit their ability to change or add these form letter layouts. Anyone know a trick that will enable a user to create/edit a layout in kiosk mode? Or should they maybe create their form letters in Word and merge the database via ODBC? Will that work on a Mac? Is there a way to script it so they can call up the form letters directly from their DB interface and have them load and merge w…

Is there a way in FM7 Pro to right a script that will email all the records with matching data in a field to one email address? Right now I have set up to do one record at a time, but that could be tedious!

I have FMP 7v3. I am opening db file locally. Does anyone know why FMP is causing my MS Outlook to freeze up? Even if FMP software is open with no file open I get the same error. When I end FMP, Outlook functionality comes back. Any suggestions? Thanks Steve

Greetings... I'm curious if there is a way using Send Mail (or other method) to specify the contents of a container as an email attachment? The Send Mail dialog appears to only allow you to define a path to an external file. Thoughts or ideas? Thanks in advance. Kirk

I'm having trouble sending email using certain email programs. I have a client running OSX that is using iMail. The email is ignoring the paragraph mark and running it all together. I'm thinking that a command will work, but I'm not sure how to insert this code into my calculation. Of course, I will have a calculation determine which platform the program is running from. Oh, here's my original code: "Type of Lead: " & type & If ( not IsEmpty ( readerservicenu ); "

I just switch to Outlook from Eudora. I have a lot of SendMail Scripts. They keep opening Eudora. Is there a way to make it default to Outlook instead? Also is there any problems I can expect with using Outlook instead of Eudora?

Hello, I'm having A hard time with a plugin I purchased(AfFiler) that creates .PDF files & is supposed to automate the email process with attachments based on calculating the parameters. However i'm kind of stuck on some issues and was hoping for some guidance. Apperantly I'm supposed to have A local mail server. Which I don't, and I was hoping someone might suggest an easy to use, cheap simple program for this purpose. The plugin uses SMTP relay and it asks for the address of the SMTP server and what port to use. I downloaded what I thought was A "no-brainer" demo version of Local SMTP Relay Server and set it up according to instructions. No luck. In the end what…

The send mail script step seems to do nothing with Thunderbird 1.0.2. Where before, in Entourage, the mail would appear in the outbox, Thunderbird does nothing. No message appears in the outbox. It would seem that Filemaker is not capable with working with Thunderbird. Has anyone else solved this problem or aware of it? In a different thread, a plugin was suggested to bypass the e-mail client. Is this the only solution?

Please forgive me for asking this before I've learned the program, but I couldn't find anything on this topic in a search and I am hoping I didn't purchase this database for nothing. Here are the tools I have: iBook running 'Tiger', Excel, Dreamweaver, and FMP 7. (Not sure what all I will need.) Here is what I would like to do: 1. Set up a web form for users to fill out online. 2. Submit that form as an email to a specific account. 3. Have the FMP database 'somehow' read each new email and create a new record from it. The 'somehow' part is what is I'm stuck on. Can FMP check an email account? Failing that, could I write an Automator script that direc…

Please help this newbie! My issue is... when perfoming a "send mail" script, Entourage opens up or comes to the front like it's "trying" but nothing goes beyond that. I have a couple of different files that I'd like to send mail to. One has approx. 5,000 people and the other has about 3 - 400. I have a "split recipients" script in Entourage in order to compensate for Verizon not letting me email more than so many per day. But I cant get the email to come up. Perhaps I'm not setting it up right in the first place? Could someone help or point me in a direction?? Thanks in advance, RT

I'm using an iBook G4 running Mac OX Jaguar Version 10.3.9. I'm having a problem in sending group emails after creating a script using Filemaker Pro Help. After creating a group and then selecting send email - the email addresses are inadvertently DOUBLED in the Send To: area of the Mail application. For example they all look like the following example: [email protected] [email protected] (See attached jpeg) In other words it puts the address in twice one after the other and they both are enclosed in brackets with NO spaces between both addresses. The addresses cannot be separated to look like it should which would be Mr…

Goal: Ability to send secure e-mails with FileMaker and also the ability to recieve emails (through secure channel) and be able to display such messages on FileMaker. Currently, our FileMaker has a layout for each member and their information (name, e-mail [text format], phone #, etc.), and I would like to add a feature (button, text box, etc.) allowing our own personel to send e-mail(s) to this particular member. We also have LASSO server that's handling our online side of FileMaker with things like Membership sign-up, change of address, etc. Therefore, my preliminary thinking is: 1. have office personel enter a their desire message from the Member's Layout …

Hi, I have a large database with contacts and some standard e-mails and attachments that I would like to send when I press the e-mailbutton in Filemaker. Right now a simple new blank emailmessage opens and I have to copy, paste and attach files to it. I have filemaker Pro 4.0 Is it possible that when I click on e-mail I can choose a certain textfile to be in the email and the attachment to go with it? Thanks!

Hi, I am using an ODBC driver to query and import data from a DB2 database. Users have their own passwords and login id to the DB2 database. There would be a button to be clicked to query and import the data from DB2. I want that the users should be prompted with the password dialog box and once they enter their password, the entire import process should be automatic. I have tried working and it works fine when I save the user name and password permanently into the script. As I said that each user has its own login and password, if I don't save the user id and password, the application gives an ODBCError "Invalid userid/password". Please let me know if anyone has a …

Hi, I have a database tracking development contracts. I have set up some automated emails. Problem: Due to the calculation of deposits etc and the way in which I have to export data (long story) all numbers must be entered without any formatting save the decimal point. i.e $20,000.00 is entered 20000.00 (but subsequently formatted to display as $20,000.00 for ease of reading onscreen). Also, any calculation of fields i.e field1 + field2 result is automatically 20000.00 whilst DISPLAYED as $20,000.00. My email has the following message: "Hi Belinda

I'm getting the following error message every time I try to attach anything through FileMaker via the email script. Here's what I get: "Microsoft Outlook Message: The operation failed due to network or other communication problem." I can go into Outlook and email the same attachment without problem, but doing it via FM gives me this message. (Running FM7.3 Dev on XP, also running MS Office 2002). Does anybody know what's going on? Please help.

I'm so new to this program (and forum!) that I'm not sure where to post this but I'm tring to figure out how to email one message to multiple people. I figured out how to send one email but what I want to do is be able to select a bunch of contacts by whatever criteria and then email a message using BCC with the main address (the one that's visible) being my own. Is there a way to do this? I know 0 about scripts. Well, maybe .02 so I'm willing to dive in.

I think this is a really simple thing to do and I hope someone can help. How do I send an email that has in the body the data from one field for all the records in the table? (for example, a list of First names of everyone in the database.) I can get it to send an email that has the field from only one record at a time-- I can't figure out how to get it for all the records (or the records from a found set.) Please help!

Hi all I'm having a bit of trouble. We've just created a new contact management database in Filemaker and are in the process of extracting data from our old 4D database. I'm looking for a plug in that allows us to send emails to a number of contacts, (1,000+) at a time without having to go outside of Filemaker. It would also be really good if it could record un-deliverables. I've checked on Versiontracker and haven't been able to find anything that's any good. I've looked through these forums and have still not found the right plug in. Anyone know of any good commercial plug ins that will allow us to email directly from Filemaker, keep records of wh…

Hi, My application downloads some data from other datasources. The data should be downloaded only once in a day and by the first user who logs on to the application. I can think that I can store the date of download. When the user logs in to the application, I would check if the date matches current date. If yes, I would not download it again. To store the date, I cannot use a global field because it gets initialized everytime whenever client closes the application on his/her workstation. Is there any other solution where I can store the date of download so that I can check this date from each client? My second question is, the status(currentdate) shows the date…

hello. i know cross posting is not cool, but over at http://www.fmforums.com/threads/showflat.php?Cat=0&Number=157355&an=0&page=0#157355 is a discussion going on how to send mail via applescript and osx inbuild smtp. it fits really in both categories i thought.

I would like to store an email message body in a text field. Sounds simple and it works when the email is in plain text.... When i receive an HTML email message it stores all the tags... Is there a way to convert html message to plain text?? (I am testing POP3it to get my e-mails..it does not seem to convert message) thanks Dan

Hi, I had entered this question in my previous post but I have not been able to find a good solution. I have a layout which has number of fields and layout is well formatted. The users want to click on a button and all the data from the layout and the layout design needs to be exported to a file outside of filemaker pro which can be distributed by an email. I have two choices and here is my problem with the two solutions: 1. PDF format: We cannot use any plugin here. I can use acrobat writer to print data in the pdf file but the entire process cannot be made automatic since it always prompts with a file dialog box to save/replace the new/existing file. We do not ne…

I have several scripts which use Send Mail and had been working okay. My mail program is Novell's GroupWise (6.0). Suddenly stopped working this weekend. No traceable changes to system. When I uncheck "No dialog" to watch what happens, FileMaker will prompt me to provide my GroupWise password if it isn't open yet. And then it skips past the rest of the Send Mail process. If Groupwise is alread open, it simply skips past the step. Anyone have any guesses? Any known conflicts with security certificate settings or config settings? Help.

I have a Send Mail script that is supposed to perform a find, take the info from the found records and place it in the body of the email, set the to: and subject: lines and open up the users email client. It works most of the time, but sometimes when the email opens it will be completely blank, even though it still performed the find and the script did not stop. Does anyone know why the emails would sometimes be blank? I can post my script in here if it will help.

Hi, I am working on a portal tool. It shows the data from a child table. Assuming that the child table has following four records related to the master table. Cancelled Scheduled Closed Cancelled I want to calculate how many "Cancelled" records are present in the child table. I understand that I can create a calculation field in the child table which would return 1 (one) if the date is "Cancelled" and then using a summary field, I can find the sum of calculation field. Can we find a solution without creating additional fields in the child table? Thanks, --Sanjai

Total FileMaker newbie here. I recently upgraded one of our users from Windows 2000 running FMP 5 to Windows XP running FMP 7. He has a database with a fair amount of scripting in it. All the work on the database was done by someone who worked here a few years before I started, so I know less than a little bit about what's happening behind the interface. One of the functions he used to be able to use without a problem was to e-mail a contact. Since the upgrade, the button that controls the e-mail function now opens a "Windows Messaging Wizard" that eventually fails with a DLL error and suggests opening the Mail applet under Control Panel. It sounds like FM isn'…

Hi Everyone, I have a global date field on a layout. I want to empty everytime the user is navigated to the layout. I tried using set field(gDateField,"") Since I have assigned an empty string to a date field, it always shows "?" (Question Mark) instead of emptying the field. My first question is how can we empty a global date or a date field? My second question is how to find records in a file which contains data in one of the date fields? To find out records which contain some data, we use "*" in find mode. If we use * in a date field in find mode, it does not allow. Waiting for a solution. Thanks, --Sanjai

Hi, I don't know much about FM7. I need to add an item loaned out box in the home inventory template, that will email either or both me and the person I type in that has the item. Or even some type of alert that would pop up telling me that the item has been out for either 7 or 14 days. I am using the standard home inventory template for items. How do I add boxes for the person that borrows the item, and maybe a box that just says it's out? Also, how do I add a feature that will give me an alert or email at a set amount of days to tell me that an item is still out? Maybe a list that would tell me all the items out and who has them? Please remember I am new. Thanks

Hi, Can we provide users with an export utility from where they can select the fields which they want to export. I understand we can do it by using the export script step and performing it without dialog but this would show all the fields and would also show field names to the users. Can we accomplish it using some other method? Thanks, Sanjai

I am curious how to email a record to a client. I am using a Mac...OS9, but am moving up to Panther soon. I know that it's possible to fax an individual record, but how do I email one? I have a client that does not (GASP) have a fax machine and I'd also save a lot of trees. Thanks Mike

I've got a project where I get a lot of hand written memberships. After the data entry I would like to click a button and have an email created with the members first name and their other info automatically put into this email. For the most part everything else is in place as far as the script goes. However I've tried a couple of things and looked through several books I have and nothing seems to help. I'm hoping this is possible because the next step after data entry is to enter their email address into an email server so they can receive our posts. I'm trying to create an easy way to double check their scribbled info to help cutdown on bounced back emails. I trie…

Greetings All! I, like alot of people, was dropped into using FileMaker as our main Problem Tracking and Asset Data base. What happens is a user can "Report A Problem" on our Intranet and have it email me and it also logs the problem into our problems data base. The issue I have is that the mail function that I am using does not constantly email me. Once in a blue moon I will get an email. We are using a script called FX.php that calls on a mail function to do the emailing. Is there a more streamlined way of doing this?

Hi Everyone, I have a field where data would fill up dynamically. The data is mostly numbers like 1, 3, 3, 4. This might go to 100. This field needs to be shown to the user but the user should not be able to edit any information on this field. I have an option to keep field length big enough to show 100 numbers but then GUI does not look in good shape. The second option which I tried was to use a vertical scroll bar and uncheck the option to allow entry for a user. But if the field is read only then even the scroll bar is not visible and hence entire data could not be seen. Please suggest what could be the best solution. Thanks for your help, --Sanjai

I created the script and everything worked fine with Entourage but it will not work with Mac Mail. actually, it only worked some times with Entourage. Can anyone help me trouble shoot this? I tried using FM Server and FM Pro and still now luck.

I couldn't find any info on this forum on even on Google about using FileMaker to validate an e-mail address before submitting the form via e-mail. Has anyone run across this issue or a plug-in that does this? Instead of just looking for '@' follow by '.' in the e-mail string, I'm looking for something that could send a dummy e-mail via smtp to validate the email address before sending the real thing. There's an online service, ServiceObject [http://www.serviceobjects.com/default.asp?bhcp=1]

Hi to everyone, I need your help to find out how we can create a pdf file in FileMaker 5.0. This pdf document should be prepared from a layout in a fp5 file. I cannot use any external plugin or freeware for this purpose. The users who will be responsible to create the pdf document do have acrobat writer on their machines. I tried using the "print to file" option in the "print" script step by selecting the acrobat pdfwriter in the printer selection dialog box. I checked the option to print without dialog. But every time acrobat writer asks to name the pdf file in the save as dialog box. I don't want this save as dialog box to be shown to the user. Everytime the pdf fi…

I've just switched from years of using FMP5 with Macs. I am now using Windows XP. Never before have I had any problem sending emails in all sorts of configurations from my databases. Now the simple SEND MAIL script will not work. OUTLOOK EXPRESS version 6 is set as my default mailer. I use FMP5. Is OUTLOOK v6 compatable with FMP5 email script step? If not - does anybody have any other suggestion at all to try? I am stumped over this very simple function! Should I just pour some brandy on it? Shakur

HI, I have experienced problems using FileMakers Send Mail command. If the mail app is set up to send messages with a default signature, FMP ignores the setting and creates new messages with no signature. I'm using FMP 5.5v2 on a Mac but have tested on 7 and windows with the same issue. Is there any way to preserve the default signature of the mail app? Thanks in advance Cath

This is my last attempt to find an answer before I give up. I'm trying to get a test page up and running that will have FM Pro (not server) send an email. I'm copying and pasting the sample text in the CDML reference. When I click on the "Send Message" button and then check the Error.log I get the error message: "ERROR: -101. Error occurred while sending email." No email is ever received. I check the -MailHost and -MailTo values and they are valid. Any clue what I could be doing wrong? Could I have the MailFormat file in the wrong directory? What directory should it be in if I'm using the Web Companion to publish the db? Thanks in advance. Bob

this may seem very basic - but I'm stumped. I have been effortlessly sending emails from Filemaker on Macs with Eudora and the simple SEND MAIL script step for years. No problem. But now that I have switched from Macs and I am using Windows XP and Outlook Express 6--- nothing happens at all. I can email directly out of Outlook. It is set as my default mailer. But Filemaker just hiccups and does nothing! What am I missing here? Any help muchly appreciated. Thanks Shaker

Is it possible to write a script in FM to send mass email using BCC field?