I have a query within MS Access that I want to automate the distribution of. While the automatic e-mailing of query results is not something new, the issue I have is new to me. The output contains 10 columns each containing specific information for policies. One of the columns contains an e-mail address. Each line needs to have that information e-mailed out to the address contained in that line. This is currently done manually using a mail merge document contained within MS Word. Is there a way to automate this within TOAD?
Sure. Use the loopdataset activity. See this video.
http://www.toadworld.com/Videos/tabid/831/TID/859/cid/185/Default.aspx
Debbie