Hi there!
I am trying to figure out a way to create book catalogs to automatically email customers from specific table views. I do something similar for sales: When the Shipped field from my Sales table is checked, an email notification automatically goes out. In this case, though, I’m hoping to send multiple books in a single email, and hoping to avoid the awkward bunching together of ALL TITLES, ALL AUTHORS, etc. Ideally, all the records would be displayed with their seven fields in this format:
AUTHOR. Title. Place: Publisher, Year. Description. Price.
Any suggestions? Are there any extensions that might make this possible? Thanks in advance for any ideas or expertise you might be willing to share!