how do i get the most recent email i sent set it to a regular field

Just for some clarification, I'm assuming you're using the Send Mail script set to send the email from filemaker? If so, what part of the email do you want to save? The body? The recipients? 

Im using 360 works email plugin, is there a way i can retrieve the emails i sent?

Hello,

 

There is no method for retrieving a complete list of all emails sent using the 360Works Email plugin. But you can get a list of emails sent by a given email account by reading emails from the "Sent Messages" mailbox on the mail server. You can pass the name of the "Sent Messages" folder in your mailbox as a parameter to the EmailReadMessages function to retrieve emails from only that folder. Please see our plugin documentation here:

 

http://static.360works.com/plugins/EMAILPLUG/documentation.html#EmailReadMessages

 

You can also use the 360Works Email plugin to copy any email sent by the plugin to a folder on the mail server which would enable you to create a folder that contains all emails sent by the 360Works Email plugin. The function EmailMoveCurrentMessage will either move the message currently queued for delivery or the most recently fetched message from the mail server into the given folder. Here is a link to the documentation for that function:

 

http://static.360works.com/plugins/EMAILPLUG/documentation.html#EmailMoveCurrentMessage

 

The example in that section of the documentation shows how to copy a sent message to a given folder. Please let me know if you have any questions.

im using the function EmailMoveCurrentMessage( "Sent" ) but it says this functiom cannot be found also can i use two mailboxes in one database?

FileMaker cannot find the Email function because the Email plugin is not installed. You must install the Email plugin before the plugin's functions can be used. Have you copied the Email plugin to the FileMaker Extensions folder? Please see our documentation here for instructions on getting the plugin installed and running:

 

http://docs.360works.com/index.php/Plugins_101#Getting_Started_with_Plug-Ins

 

You can use FileMaker Preferences to ensure the plugin is installed afterwards. In Preferences, there is a Plug-Ins tab where the Email plugin will be listed and checked if it is installed properly.

 

You can use the Email plugin to access any number of mailboxes so long as you have the proper connection details and credentials. I recommend creating a table of email accounts where each record represents an account.