Hi Adam, You might try creating a session variable called session.trans_id
Then insert the session.trans_id into each submission. Then run a query against the db using the session.trans_id to get all the records that match and then you can either send out as in the body of an e-mail or attached to an e-mail as a pdf. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4698 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
