i created a saved search that emails me yesterdays invoices, the data is set to show in the email and not as an attachment. issue is it does not show up in column format but shows up each record one by one in 1 email instead of looking like and excel file within the email body. any solutions?

I agree with @Sandii, If at all possible keep the data in NetSuite and go get it there. As soon as you email it... its not system data anymore. also while you can tell from the system that an email was schedule to be sent... that is all you can tell... you cannot tell if the email was actually sent, recieved, spammed, black whole'd... basic you inherit all of the trouble of email and it looks like a NetSuite issue when it is not.