Hello, I use Exh 2007 and run the below shell command: get-messagetrackinglog -Recipients:email@company.com -Start "01/08/2010 09:41:00" -End "12/08/2010 16:51:00" | ft EventId, Source, Sender, Recipients, MessageSubject, Timestamp > result.txt I wish to get the entire column mainly regarding the Sender, Recipients, MessageSubject but instead I have ... avec few words. Any tips to have the full information using the same way to display the information? Thanks Graig

Try adding -wrap to your ft get-messagetrackinglog -Recipients:email@company.com -Start "01/08/2010 09:41:00" -End "12/08/2010 16:51:00" | ft EventId, Source, Sender, Recipients, MessageSubject, Timestamp -wrap > result.txt[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

It almost do the job :-) I have the information but when I copy the data into a Excel sheet and I do the "text to columns", I got the row on 3-4 columns and not on one row.. Any idea how to gather that on one row? Please get back to me if I haven't been clear enough. Graig

FT is for screen display, and it's gonig to format it to fit the screen. If you need to get it to Excel, I'd use export-csv.[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

When I type the below command: get-messagetrackinglog -Recipients:email@company.com -Start "01/08/2010 09:41:00" -End "12/08/2010 16:51:00" | ft EventId, Source, Sender, Recipients, MessageSubject, Timestamp -wrap | export-csv name.csv I get in the csv file: "#TYPE Microsoft.PowerShell.Commands.Internal.Format.FormatStartData ClassId2e4f51ef21dd47e99d3c952918aff9cd,pageHeaderEntry,pageFooterEntry,autosizeInfo,shapeInfo,groupingEntry 033ecb2bc07a4d43b5ef94ed5a35d280,,,,Microsoft.PowerShell.Commands.Internal.Format.TableHeaderInfo, 9e210fe47d09416682b841769c78b8a3,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 27c87ef9bbda4f709f6b4002fa4af63c,,,,, 4ec4f0187cb04f4cb6973460dfe252df,,,,, cf522b78d86c486691226b40aa69e95c,,,,," Can you help me with that ?

Try this: get-messagetrackinglog -Recipients:email@company.com -Start "01/08/2010 09:41:00" -End "12/08/2010 16:51:00" | select EventId, Source, Sender, Recipients, MessageSubject, Timestamp | export-csv name.csv -notype The output from ft contains formatting for the screen, and isn't suitable for export-csv. Export-csv is intended to take an object collection as input, and the formatting added by ft is just getting in the way.[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "