Assuming you are storing references to the file and not storing the file in the container itself:
From the FileMaker help: Tip If you select Store only a reference to the file, one way to see the location of the file on your hard disk is to create a script using the Get(ActiveFieldContents) function.
I have found that a simple GetAsText ( ContainerField ) will give you enough to work out the file path.
You can also use export field contents to export a copy of the file to your temporary folder and attach that file to your email.
Thanks Conor, Phil,
I was planning to embed the image into the filemaker file but looks like Phil's suggestion would mean that the exported file would have to have the same default name each time for the attachment to work. So I am leaning towards your solution of storing it as a reference, that way I can maintain the image file naming conventions we have. If I am making some wrong assumptions here please let me know.
Any input on how to add multiple emails to the CC email field?
There are ways to specify any filename you need when you export the field contents.
As to putting multiple email addresses in the CC box, the details depend on your email software and how your multiple emails are stored in your database.
You can build a string of emails in this format: email1, email2, email3 or this format email1; email2; email3
depending on what your email software requires. How you build this list depends on the design of your database solution. If the email addresses reside in a group of records that are related to the current record, you could simply use a version of this calculation:
Substitute ( List ( relatedTable::Email ) ; ¶ ; "; " )
In other cases, you may need to loop through a set of records appending one more email to such a list with each pass through the loop.