Hi,
I'm new to Access 2010 and Data Macros, so I apologize if the solution is obvious or answered and I'm just not searching the right phrases.
I have 2 tables: Contacts; and Accounts.
The Contacts table has Names, phones, emails, etc.
The Accounts table has many fields and a combo lookup on the Contacts Names (db table relationship is also defined between these two tables).
I would like for an email to generate, that populates the appropriate email contact, when the Accounts table record date field is updated (but allows the user to edit/attach before sending).
I am able to easily write the expression to customize the email Subject Line based on the Accounts table data fields, but I'm having trouble properly referencing the Contacts table and field.

Do I need to use other commands like SetLocalVar or ReturnVars or ???

Any guidance is appreciated.
Thank you