Send email from a related data field
I have a view that displays a lookup field and the view is configured to display related fields to the lookup value, one of those lookup values is an email address. i would like to use the email address from that field to send an automated email. however because the field is a lookup field related to another form i can't reference the field when setting up the script for the automated email. anyone have any ideas on what i can do here?