Partner submissions
SELECT * FROM applicant
When/IPCompanyAddress & phoneemailexpertisedata
#dateformat(when,"dd-mmm-yy")# #ip# #company#
#first# #last#		 #address1#, #address2#, #city#, #state#, #zip#, #country#
#phone# (#fax#)		 #email# #expertise# #target#
#people#
#regions#
#share#% #existing#

Subscriber submissions
SELECT * FROM subscriber
When/IPEmail
#dateformat(date,"dd-mmm-yy")# #ip# #email#