Hi!
I wanna automate an ordering process to our suppliers that only accept orders via email (excel og pdf's).
My wish is that the database will do the following:
1. Download the orders from ERP-system
2. The Access user/order manager then check "Yes" or "No" for each order to send in an Access Form, and click a "send email" button.
3. Automatically sends each order to the correct receiver/supplier.
Step 1 and 2 is no problem.
But due to only basic Access knowledge, I run into an issue in step 3
My original plan was to have a query/object for each order, and email those by using EMailDatabaseObject to the correct supplier. However, I only want to send the object if there is data in the query. In other words, I don't wanna send empty files.
All input and suggestions is greatly appreciated! I beg you to keep in mind that my VBA-knowledge is lacking, so any code-related solutions might require some "spoon feeding"