Sunday, 9 March 2014

Outlook 2013 shows an empty folder where inbox displayed unread emails.

Problem:

Outlook shows the message “we didn’t find anything to show here.” when looking in a folder that shows unread items.
Screenshot of outlook 2013 showing no emails in inbox.

Cause

The views in outlook can become unresponsive causing it to not display the emails.

Solution

Reset the view in outlook
  1. Open outlook and select the folder you are having issues with.
  2. On outlook ribbon click “View”
  3. Under current view category, click the Reset View
Reset views butting in the view ribbon.
Screenshot from Outlook 2013

How to add scanner button in word 2007/2010/2013.

Problem:

How to add scanner button in word 2007/2010/2013.

Solution:
This could be tricky for a user because you have to add a script in word application.
Let's see how.
To add a Scan button into Microsoft Word:
  1. Click the Office icon in the top left.
  2. Click Word Options
  3. Tick the box labelled Show Developer Tab in the Ribbon
  4. Click OK.
  5. Click on the new Developer tab in the Ribbon
  6. Click Macros
  7. Type something in the top box and click Create
  8. Delete everything in the new box that pops up and paste in the following:
    Sub InsertFromScanner()
    On Error Resume Next
    WordBasic.InsertImagerScan
    End Sub
  9. Click File, then Save Normal, then close the Visual Basic Window.
  10. Click the Office icon.
  11. Click Word Options.
  12. Untick the Show Developer Tab button.
  13. Click Customize.
  14. In the drop down Choose Commands box and select Macros.
  15. Select Normal.NewMacros.InsertFromScanner.
  16. Click Add.
  17. Click OK. You should now have a new icon on the Quick Access Toolbar for Scanning.

Wednesday, 5 March 2014

Right click doesn't work in Excel 2007.

Problem:

When you right click on excel spreadsheet it do not show anything.

Solution:

1. Open excel 
2. Hit alt-f11 to get to the VBE 

3. Hit 
ctrl-g to see the immediate window 

4. Type this and hit enter: 

      application.CommandBars("Cell").Reset      application.CommandBars("cell").Enabled = True
5. Hit alt-f11 to get back to excel and test it out.

Sunday, 2 March 2014

Microsoft Excel Error: "There was a problem sending the command to the program."

Problem :

Microsoft Excel Error: "There was a problem sending the command to the program."
image
image

Solution:

If you are getting this error in office 2007 or 2010 then the solution could be simple then it it in office 2013.

1. Open excel 2007/2010.

2. Click on File Menu - > Options - Advance.

3. Under General Category you will find the option.

"Ignore other applications that use Dynamic Data Exchange (DDE)”

4. Uncheck this option and close excel program.

5. Open excel and see if this will work otherwise you can also use other method described in other post on TechhStuff.