I thought I posted this here, but apparently I was mistaken. Here's what I wish to do and here's how I assume it has to be done, but I lack the skills in scripting to make it so.

I have a field named phone1. When the date is entered into Phone1, it is also part of the date that results in text_address. Text_address should append the "@" symbol and strip away any formatting of that number for emailing. According to the value that is chosen from a pop-up menu, mobile.att.net, messages.nextel.com, etc is appended to @ in that field value.

That's part one of the task. Secondly, I wish to have a button which will take all of those addresses and put them into my outlook client from the push of a button. This is already halfway done, because of the email script in FileMaker.

So, to review: (A) Script for formatting a field value into an email address based on two fields values. (: Pulling all email address values for text_address into my email client at the click of a button running a script.

I've looked into third party solutions, but I know this can't be that hard. I've already got the field adding the "@", now I just need to strip the special formatting and append the appropriate carrier information.

I have attached this database so you can see what I'm trying to do. I should also mention that I completely took the easy route and used one of the templates. I hope someone can give me direction for the information I seek.

Copy of the_list.zip

Any direction at all would be greatly appreciated. I really want to get away from having to use an email client with a copy and paste solution for the daily messages we send out.

Feel free to email me directly: [email protected] if you're interested in helping without the world seeing.

Thank you