I am not even sure if what I am looking for is possible but here goes. I need a MACRO that will allow me to select a customer from a form, create an email message, pluck the email address from a table and attach multiple zipped files to the message.
To add to the difficulty level, the file name of the zipped file contains the name of the customer.
For instance, it might look like: 000020876-427-BBQ.zip. I might have several files that contain the BBQ. All files with BBQ would need to be attached to the email