I have been trying to figure out the command/function for pasting the data and formatting from Excel to outlook. I originally was using readtorange, but that strips the formatting, so I started resorting to VB and I cannot seem to figure out what the paste command is. This is what I have: $oExcel = ObjCreate("Excel.Application") $oExcel.Visible = False $oBook=$oExcel.WorkBooks.Open ($fExcel) $Sheet=$oExcel.ActiveWorkbook.Worksheets.Item($sSheetname) $test=$Sheet.Range("A1:D60").Copy $olApp = Ob