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