I have a series of reports which I need to be emailed automatically. The reports are group into 3 batches. The details of each report are stored in a table “Tbl_Reports_List” which amongst other data, contains the following fields:
Rpt_Name (Text field)
Each of the reports already has the recipient’s email addresses contained in the [.tag] field in the report.
Does anybody have a piece of code to scroll through the table and if [Sendout1] = Yes, then email the report [Rpt_Name] in rtf format to .tag