Android Gmail App not find email addresses / contacts that emailed before?

Sometimes after installing the application on mobile devices,  due to permission popup and without reading the message users generally select Allow / deny.  This will cause that we are not able to select the email / or contacts while sending the email from the email app.  To resolve check the following things:

Went to Android Settings, Apps, Gmail. In the App Permissions section, Contacts disabled. Enabled it, closed everything.

And after  opened gmail, it was giving me suggestions of emails as I was typing.

 

How to display negative time in excel cell

While working with excel application I found that if we find difference between 2 times is negative then excel doesn’t display time, it shows “##########” instead of values. For positive difference we don’t have any issue.

There are 2 ways to handle this, using 1904 date system and other using custom formula.

To change the date system you need open Advance options of excel and enable the 1904 date system box.

Use the formula:

=IF(D2-A2<0, "-" & TEXT(ABS(D2-A2),"hh:mm"), D2-A2)

 

 

How to fix the outlook issue when its prompting the password again and again

We are using Microsoft Outlook on our desktops or laptops to view emails offline. Some times on start the outlook it prompt us to provide valid password. After providing valid password it prompt again. This will be some irritating.

To fix this type of issue we do have 2 ways:

  • Remove the saved credentials of outlook from windows credentials manager, using these steps:
    • Click Start, click Control Panel, and then click Credential Manager.
    • Note If View by is set to Category, click User Accounts first, and then click Credential Manager.
    • Locate the set of credentials that has Outlook in the name.
    • Click the name to expand the set of credentials, and then click Remove from Vault.
    • Repeat step 3 for any additional sets of credentials that have the word Outlook in the name.
  • In outlook, go to ?Email Accounts -> More Settings? ?> ?Outgoing Server? ?> Check First checkbox and first radio button.

How to recover an archived email from your gmail account

Most of the people in the world are using GMAIL for their email, its a free and support unlimited storage (15 GB).

Some times while viewing the email on desktop / handheld devices, archived option is clicked accidentally. If you want to recover that email from archived folder, just use these steps:

  • Open your gmail account
  • Go to left panel and click on “All Mails”
  • Search your email and open it
  • After opening, click on “Move to Inbox” button.
  • Now you can see your archived email to inbox folder

Archive folder is good for keeping the emails, if you want to delete the emails which is not used, without deleting permanently them move to archived folder.