Email to outlying locations

[jacger]

I am currenting using email to transfer files to outlying associates. I am doing this interactively. I want to automate the process.

The problem I am having is in creating, automatically, a file id. My thought is some sort of concatenation of my id, month and day, and associates id. For instance, HMH0413XXX would be the id for a letter from me on the 13th of April to XXX. Can anyone tell me how to do this through scripting.

[LiveOak]

You can do it as a calculation field or using a Set Field script step into a normal text field. The calculation would look like:

FromID & Right( "00" & Month(Date), 2) & Right ("00" & Day(Date), 2) & ToID

-bd

[jacger]

Thanks for the suggestion. The calculated field worked fine and I was able to put it into a related database so that it updates automatically on a daily basis.

Let me ask a follow-on question. I will be building an attachment to put on the email file which will be the found set of new records based on a date field and a flag field (yes/no) that I am using. I will name the attachment using recipient's id and the month/day combination again. Currently, I have not found a way to have that name inserted into the export filename automatically. Any suggestions on this?

HHill

[LiveOak]

You'll probably have to export the file with a default file name and use AppleScript to rename the file. I don't know if there is a plug-in to do this, it might be worth a look at www.filemaker.com.

-bd