select a.recipientid, a.message, a.statuscd, b.firstname, b.lastname, b.emailaddress, b.organization from tbl_eml_undeliverables a, tbl_eml_campaignrecipients b where a.statuscd = 'ud' and a.recipientid = b.recipientid

First Name	Last Name	Email	Organization
#FirstName#	#LastName#	#emailaddress#	#organization#
checked> Returned Undeliverable checked> Address Fixed - Redeliver checked> Recipient Deleted			#message#