Displaying slide show on same monitor with PowerPoint 2013

1. Click the Slide show ribbon bar
2. Select the Window presentation option
3. Hit F5

Hyperlinks not opening immediately from emails

If this happens then follow the steps below to fix it...

To reset Internet Explorer Settings, follow these steps:

1. Close all Internet Explorer windows.
2. Click Start, type inetcpl.cpl in the Search box and then click inetcpl.cpl on the Programs list.
   The Internet Options dialog box appears.

    

   Note for Windows XP, click Start, click Run, type inetcpl.cpl in the Open box, and then click OK.

3. Click the Advanced tab.
4. Under Reset Internet Explorer Settings, click Reset. Then, click Reset again.
5. When Internet Explorer finishes resetting, click Close in the Reset Internet Explorer Settings dialog box.
6. Start Internet Explorer again.
   Your changes will take effect the next time that you open Internet Explorer.

How to open Visio documents in Visio Viewer when you already have Visio installed

1. Just delete the HKEY_CLASSES_ROOT\.vsd key from you registry root
2. Enter the below registry text into a .reg file and double click to add it into your registry
3. In internet explorer choose File, Open, (select all files filter), and then select your .vsd file, and then allow the activex control to run.
4. Also to remove the warning from IE each time you open a .vsd file, set the following security option in your Internet options, Advanced dialog...
   

 

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.vsd]
@="VisioViewer.Viewer"
"Content Type"="application/vnd.ms-visio.viewer"

[HKEY_CLASSES_ROOT\.vsd\PersistentHandler]
@="{FAEA5B46-761B-400E-B53E-E805A97A543E}"

[HKEY_CLASSES_ROOT\.vsd\shellex]

[HKEY_CLASSES_ROOT\.vsd\shellex\{8895b1c6-b41f-4c1c-a562-0d564250836f}]
@="{21E17C2F-AD3A-4b89-841F-09CFE02D16B7}"

Restarting Outlook mail search indexer

Kill the SearchIndexer.exe process in task manager, and then follow the steps below to get outlook search working again...

 

Searching for emails from multiple senders

I've always wanted to know how to do this myself, so just thought I'd let you know if you were wondering as well. When searching emails you can use the OR operator as follows for quick search for people messages are from for example like this

FROM: (james OR robert)

This will find all emails that were sent from either James or Robert for example.

Outlook Mailbox / Inbox repair tool

Just had to do this again today, after my outlook 2010 wouldn't open, so I thought I would re-blog it here on my new blog just in case I forget the next time.

Found an article on the web that pointed me in the direction of this nifty little tool for MS Office 2010 inboxes.

C:\Program Files (x86)\Microsoft Office\Office14\SCANPST.EXE

VBA Excel Macro for Hyperlinking first column

Use this macro in an excel 2010 spreadsheet to turn the first column of a table into hyperlinks, using the text of the table as a hyperlink.

Sub CreateLinks()
'
' CreateLinks Macro
'
' Keyboard Shortcut: Ctrl+R
'
   
    Dim i As Integer

    'Starting on row 2 because I have a header.
    Range("A2").Select
   
    'move to the final cell in the first column
    ActiveCell.End(xlDown).Select
       
    Do Until ActiveCell.Row = 1
   
        ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
           ActiveCell.Text, TextToDisplay:= _
           ActiveCell.Text, ScreenTip:= _
           "Click here to open Person record in Beacon"
               
        Range("A" & ActiveCell.Row - 1).Select
       
    Loop
   
   
End Sub

Bypassing Word document password setting

If you ever have a Microsoft Word document that you want the merged version of, but are unable to do this as there is a password set on the document preventing you from accepting all changes, then simply email the document as an attachment to your Google mail (Gmail) account, and view it online. From there you will see Google does the merging for you and you are then able to export off a new version in word document format, with all the changes accepted.