Showing posts from 2016

Tips on how to use IBM iNotes (web client) on emailing or scheduling - Like copy tables from Excel or checking for user id (windows logon id) through email address

There are certain functions that I accustomed with when I write email and schedule a meeting using mail client such as Ms Outlook or IBM Lotus Notes. However, such functions are not straightforward when I am in Lotus iNotes, a completely web based client application.

Writing Email Common Functions
1. Checking for user id (Windows Logon ID) for the email address.
There is no check for user detail in web based version. In the PC client version, you can do this by right clicking on the email address in the "To" textbox. However, there is another solution in web based verion. You can click on "To" hyperlink to search for that person in the address book. Then, find the person there and click "Details" there to get the user id (Windows Login ID)

Similar, if you do not have email address of the person but you have the windows logon ID, you can just type the ID in the "To" textbox and click on search for that person. The system will reverse lookup the …

How to reduce the file size of an excel file

I have read a numerous tutorials in the web on techniques to reduce file size.

Some of it work okay but not to my satisfactory. I will show those that work first and then I will show my own simple way that works better.

Method I found in the web that works but not very well and comes with cons. 

- Save your excel file in binary format. Click save as, select Excel Binary Workbook. This however means it will change the format of your file and binary file format is not amendable unless you save as another file format again.

Method I found that works better 

- Highlight the last row and drag until the very far bottom row of the sheet. Then, select "Delete". The further you go the better.

- Highlight the last column and drag until the very far bottom column of the sheet. Then, select "Delete". The further you go the better.

Once it is done. Click Save. You should able to reclaim your file size back to small one.