You should create yourself a report layout containing data that you want in a PDF.
Then create a script that will open the report, filter it to show only data needed and save it as PDF in a temp folder.
then your script should send the email with the PDF as an attachment.
your report can have page break so there will be one pdf page for each product.
the script can asked for selections via a personnalized dialog box
your send-to address can be typed in or coming from a field.
Thank you very much for responding.
Sorry to be a pain but being a novice I'm not too sure how to go about this, would I be pushing my luck if I asked for step by step guide?
Thanks in advance