Few months ago, you held me thru Freelancer to create a MS Access 2007 solution called
MS Access 2007MacroVBA- Export data from query and create Excel books per each customer
where VBA code extracted from a Table data to create a set of MS Excel Book, one book per customer
Each MS Excel book had inside two Sheets with pertinent data for Customer.
Now , is necessary to develop solution a bit more to :
a. Automatically, create one Windows Folder per Customer and name that folder with Customer's name.
b. Put inside each Windows Folder MS Excel books generated from previous solution you made for me.
c. Run a MS Access 2007 Report [ this report is an INVOICE template]
d. Per each customer on Report INVOICE create a PDF file and stored into appropriate Windows Folder .
In short words, solution will make a Folder then put one Excel and one PDF per each Customer
After above process is completed is necessary to create a ZIP file per each customer.
Then using Customers data table which contains email addresses, solution will compose one email and will attach pertinent ZIP file.
To compose email, BCC field is going to be used.
Read Receipt feature for all outgoing emails.
I know Access can create emails and put then into an Outlook 2007 folder ready for dispatch.