Posts

Showing posts from May, 2011

MS Excel 2010 shortcut keys

Shortcut Keys  Description F2 ------Edit the selected cell. F5-------Go to a specific cell. F7-------Spell check selected text and/or document. F11----------Create chart. Ctrl + Shift + ; ----- Enter the current time. Ctrl + ; ------------- Enter the current date. Alt + Shift + F1 ----------------Insert New Worksheet. Shift + F3 ---------- Open the Excel formula window. Shift + F5--------------------Bring up search box. Ctrl + A ------------- Select all contents of the worksheet. Ctrl + B ------------ Bold highlighted selection. Ctrl + I --------------Italic highlighted selection. Ctrl + K ------------- Insert link. Ctrl + U ---------------- Underline highlighted selection. Ctrl + 5 ------------- Strikethrough highlighted selection. Ctrl + P ------------ Bring up the print dialog box to begin printing. Ctrl + Z------------ Undo last action. Ctrl + F9-------------- Minimize current window. Ctrl + F10 ------------ Maximize currently selected window. Ctrl + F6 --------

Check for subject in OUTLOOK

Steps: 1. Open your outlook 2. Press Alt+F11. This opens the Visual Basic editor 3. On the Left Pane, one can see " Microsoft Outlook Objects ", expand this. Now one can see the " ThisOutLookSession ". 4. Click on " ThisOutLookSession ". 5. Copy and Paste the following code in the right pane. ( Code Pane ) Code: Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim strSubject As String strSubject = Item.Subject If Len(strSubject) = 0 Then Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?" If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then Cancel = True End If End If End Sub 6. Save this and Now close the VB Code editor. 7. In Outlook Go to Tools > Macros > Security > In the Security Level Tab > Select the option MEDIUM > OK 8. Now Restart the

Advanced Find page does not show the custom entities in the look for dropdown

If the URL for adavnced find page misses Organization name in the URL .i.e, if the URL is without the organization name, then the Look For dropdown which lists all entities does not list the custom entities with in that organization. It will only list the OOB entities which are common to all the organizations. Of course, this makes sense. If URL is included, then the lookfor dropdown shows all the entities inlcuding the custom entities in that organization. This bugged me for a while today.