-
Emails from Access
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
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules