Can ZC do this - mySQL/email generation

Hello ZC,

I'm seeking guidance on the following project and wonder if Zen Cart might be the answer since its primary purpose is online sales. I've used ZC on 2 other sites but couldn't see a way for the standard ZC to do this, but I am posting this to make sure. If standard ZC won't do this, please let me know and I'll seek bids for modification.

Thanks,
DocRocks

We are developing a website for a social group that sells ads for its newsletter. The ad data is submitted via a form to a mySQL data base. The ad itself is an image file attached to the form.

The full workflow is given below.

1. User enters the workflow by navigating to a first page on the website that has general information and an "I accept terms and conditions" box that must be checked to proceed.

2. Checking the box sends the user to the ZC(?) page. This page has a form that contains about 10 fields of personal data (name, address, phone, family members and ages, etc.). Six different ad items will be available for purchase. Each field will allow the user to attach a file from the local disk. ZC has a

3. The user pays for the ad on Paypal.

4. After Paypal accepts payment and returns the user to the website the following needs to happen in the background:

   • An email is generated to the website owner with two attachments:
     -- a CSV file with the form data
     -- the file attached by the user with the submission

5 Concurrently with step 4, the user is sent to a thank you page on the website and a thank you email is sent to the buyer.