Jump to content

Recommended Posts

Posted

Hi,

You can try this way. When you have the history on screen Press Ctrl + Alt + Print Screen together.

Then open a new word document, right click your mouse and paste on to the word document.

You can then click on the image to adjust the size.

FD :)

Posted
Hi,

You can try this way. When you have the history on screen Press Ctrl + Alt + Print Screen together.

Then open a new word document, right click your mouse and paste on to the word document.

You can then click on the image to adjust the size.

FD :)

Top job 'Fatdog' worked like a dream

many thanks

Posted

If you have a lot of calls in a month you may end up doing a lot of screenshots (same as Press Ctrl + Alt + Print Screen together) kuffki.

Once you are in the Call history pages you can select the all calls option and click on the 'export to history file link'. This opens a 'Comma Seperated Value' file in Excel. The resulting spreadsheet looks a bit unmanageable, but if you follow the following instructions you can make a sensible Excel table of it. My version of Excel is 2003 I think so it may be slightly different on yours. You are looking for the 'Text to Columns' function in Excel to break down the raw data into a recognisable data sheet. In Excel 2003 it is:

Select column A so that all the entries in Column A are highlighted

Click on 'Data' in the top Menu bar

Click on 'Text to Columns'

Select the 'delimited' radio button and click on 'Next'

Unclick 'Tab' in the checkbox and check semicolon instead; click on 'Next'

Select the second column in the dialogue box that has the telephone numbers in it - headed up 'General' and 'Item'; click on the 'Text' radio button in the 'Column data format area of the dialog box

Click on Finish

You should now have a spreadsheet of data of all your calls. You can further titivate the date and amount columns using the same 'Data' / 'Text to columns' approach if you want to further break down the date column and if you want to get rid of the annoying GBP in front of each amount.

You can the print the data using the normal Excel print functions.

Sounds complicated but once you get the knack its easy

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.



×
×
  • Create New...