Hi,



I've searched through various forums and online tutorials, however, I have not managed to find any answers to my question, perhaps it's a little specific, or I'm looking in the wrong place....

Anyhoo...

I have a database that has various tables and reports.
Here are the two that affect my question:

TBL:Suppliers

  • Vendor_Name
  • Supplier_Code (primary key)
  • email_addresses
  • Send_Email

QRY:New_Final_Data

  • Various Columns of data
  • Supplier_code

What I would like to do, is;

where TBL:Suppliers.Send_Email = yes, take the supplier_code, filter to the same supplier_code in the "QRY:New_Final_Data" and email all those rows, as an excel file, to the email address(s) from the "TBL:Suppliers".

I was given a link to here : http://www.utteraccess.com/forums/sh...Number=1296038 by another forum, however, I'm not advanced enough to know what any of that means.

Does that make sense?

Do you need any more information?

Any guidance or help, greatly appreciated.

Cheers,
Andy