Hi! I'm new to this forum but it seems to be the right place to find answers for most of my access needs
In my Access 2013 (/365) database I have 2 tables: tblClient and tblOrder. tblClient has client name and email address (and more). tblOrder has order date, shipping date and item ordered (and more).
A query qOrderdetail picks up data from both tables and shows it all in a form. Now, from this form I'd like to be able to press a button and send an email to the single client on the screen, giving details on the order. And that's where I get lost :-P Any help is greatly appreciated.
And BTW: English is not my native language, so feel free to ask if you need clarification on something - I tried explaining as best I could.
Also: I hope this is the correct subforum for the question.
And lastly: I know how to make a datamacro that does the above - as long as all the needed data is in one table only...