cooper collier 1/11/2017 7:11:45 AM
As coincidence would have it, I was just working with notifications as this email hit my mailbox. So I may already have what you need in my brain...
If you are using a rule to generate your email notifications then recording the emails is easy. Create a multiline text box for "email logs" then after the email is sent, just do a record update. Something similar to [emails sent] = Now() & [sent to] &"\n"\&[emails sent]
If you are using the email notifications or there are more emails than a text box can accommodate. You can copy the emails to another table "EMAILS SENT" and link it to the sending table.
Make an "Emails Sent" table. Create a link to the table sending notification from. [emails from] The [email from] column would contain the Record ID of the originating table.
In the originating table make an email formula the formula would be something like.
"your database number"&"+emailnotice+"&[record id]&"@mail2db.teamdesk.net The resulting email address would look like this firstname.lastname@example.org.
In your mail table make a rule for new records.
set the filter for records containing tag "emailnotice"
Then create a new record in the"Emails Sent" table.
assign Part([tags],2) to [email from] . This will create the link between the originating table and the emails sent table.
assign other columns as needed
I know my explanation can be confusing. It is always hard to explain without screen shots or an example database. Feel free to email me and I can help you out. it will only take a few minutes to setup. Once you see an example it becomes clear.