Trying to attach multiple PDF drawings to emails. In this case, I would be accessing existing PDFs but also may create some "on the fly". Once created I need to attach them to an email. Also the user will be looking at them to screen first. The email option would be in case the customer wanted them emailed.
My thoughts are to create a temp table and populate the table with the PDFs. Of course each PDF would have a unique name. I would then want to attach the PDFs to the email. 1) The column holding the PDFs needs to be a VARBIT? Or if not what type? 2) As each pdf is created, would the best way to get them be the LISTOF command? My thought is as the cursor goes through each item to have the LISTOF command include all items in the temp table. Thoughts appreciated if this is not efficient enough. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]]
