Send and populate email through a button
Hi,
I am new to the community and would love to implement a button in my DEAL table where it sends out an email (i want it to prompt my outlook window) to the email linked to a different table, CONTACTS and auto-record the content that is being sent into a different table, say EMAIL.
I have created a button already like below:
"mailto:"&""&[email]&"\n"&"?subject="&"\n"&[Subject]&""&"&body="&[Body]&""
where [email] is where i want to grab the mail
and [subject] and [body] are my predefined fields in the same table
but I don't know how to
1) grab the email address that is being stored in a different table
2) save the content that was sent out attached by an ID that is the same ID as deal
3) Would it be possible to track the sender's and receivers email conversation beyond just the initial "send"?
I am new to the community and would love to implement a button in my DEAL table where it sends out an email (i want it to prompt my outlook window) to the email linked to a different table, CONTACTS and auto-record the content that is being sent into a different table, say EMAIL.
I have created a button already like below:
"mailto:"&""&[email]&"\n"&"?subject="&"\n"&[Subject]&""&"&body="&[Body]&""
where [email] is where i want to grab the mail
and [subject] and [body] are my predefined fields in the same table
but I don't know how to
1) grab the email address that is being stored in a different table
2) save the content that was sent out attached by an ID that is the same ID as deal
3) Would it be possible to track the sender's and receivers email conversation beyond just the initial "send"?
