Hi, I am looking for a way, through VBA, that I can automatically have data from a spreadsheet tab pasted into a new email. The data needs to appear in the exact same format as it does in the spreadsheet as it is a letter template. Is there an easy way to do this? When I copy and paste it manually into an email it keeps its format fine, so if there is an easy bit of code to copy from excel and paste into a new email and then send, that would be perfect. Thanks in advance, Ben.