Jim Medema

Dom, Lauren Kuhlman did a great job and created a Wordpress sync tool. You can find out more at the product site here: http://wordpressfilemaker.com . All the best, Jim Surefoot Database Consulting www.surefootdata.com

I’ve got a client who, when creating emails directly in their email program (Apple Mail), includes their logo after the textual part of their signature line. The client wants to do the same thing when using emails are sent from FileMaker using the “Send Mail” script step. I’ve been putzing with the Send Mail step with no luck. The file attaches easily enough but doesn’t appear at the end of the text in the email. I’ve played around with the signature settings in the email program which can easily include the logo in the signature IF the emails are created by (or within) the email program, but the FileMaker-created emails don’t inherit the “automatically apply my signature” preference from Mail. Sending each email as a PDF attachment is not an option, and I'm trying to see if this is possible sans plugin. Any tips, tricks, thoughts, or ideas? Much thanks, Jim

Thanks for the clarification. I neglected to specify exporting as a tab-delimited file. My unvoiced assumption (yikes!) was that since the original poster didn't seem tied to having a csv file at tab-delimited file would be fine. Jim

The interesting element of your question is that you want some fields to export with quotes and others without them. Assuming that you don't want to assume your users will remember to add quotes to the desired fields ('cause they won't), you could easily create hidden utility fields that add them! When it's time to export, simply export the utility fields along with the regular fields. Example Your original field list: Field01 - (desire to export with quotes) Field02 - (desire to export with quotes) Field03 - (desire to export without quotes) Field04 - (desire to export without quotes) Create 2 new fields: Field01ForExport (calc field) = Char ( 34 ) & Field01 & Char ( 34 ) Field02ForExport (calc field) = Char ( 34 ) & Field02 & Char ( 34 ) Note that the calc engine cannot properly read """ (a quotation mark surrounded by quotation marks), we need to take advantage of the new Char function which allows us to enter the ASCII number for the quotation mark to get our desired result. Fields to Export: Field01ForExport Field02ForExport Field03 Field04 Hope this helps, Jim