Restore deleted items in Outlook

Accidents happen. When that sudden realization hits days later that you need an email message that’s long gone, the Recover Deleted Items command might save your day. You can recover some deleted items, like messages, appointments, contacts, tasks, and notes, even after the Deleted Items folder is emptied or you’ve “hard deleted” an item by pressing Shift+Delete. This feature requires a Microsoft Exchange Server account and doesn’t work with POP3 or Internet Message Access Protocol (IMAP) accounts.
If you’re using Office 365 or another Exchange-based client, you can also restore deleted items using Outlook Web App. For more information, see Recover deleted messages or items in Outlook Web App.
  1. Click Folder > Recover Deleted Items.Recover Deleted Item command on the ribbonIf you don’t see Recover Deleted Items, you’re probably not using an Exchange account or you don’t have a folder selected in that account.
  2. Click the message you want to recover, and then click Recover Selected Items Button image. Tip    To select multiple items, press Ctrl as you click each item, and then click Recover Selected Items Button image.Recovered items are restored to the folder you’re working in.

Note    Your Exchange administrator specifies the retention time for deleted items. After this time elapses, deleted items cannot be restored.

To enable port 80 on Windows Server 2008 R2:

To enable port 80 on Windows Server 2008 R2:

NOTE: This assumes that IIS is not installed. I added this firewall rule to enable Apache to accept connections on port 80.

  1. Click Start->Control Panel->Windows Firewall
  2. Click “Advanced Settings” in the left panel of Windows Firewall
  3. Click “Inbound rules” in the left panel of Advanced Settings
  4. Click “New Rule…” in right “Actions” panel
  5. Select “Port” and click “Next>”
  6. Select “TCP”, then “Specific local ports:” (should already be selected)
  7. Type 80 in the box (just the number) and click “Next>”
  8. Select “Allow the connection” and click “Next>”
  9. Leave all profiles checked and click “Next>”
  10. Enter a name and click “Finish”.

Your server should now be able to accept connections on port 80.

Source: http://stackoverflow.com/questions/7363470/windows-server-2008-r2-cant-get-apache-to-run-on-port-80

Excel – Creating a List of Formulas

Most users have discovered that Excel has an option that lets you display formulas directly in their cells: Choose Tools Options, click the View tab, and select the Formulas checkbox. However, Excel doesn’t provide a way to generate a concise list of all formulas in a worksheet. The VBA macro below inserts a new worksheet, then creates a list of all formulas and their current values.

To use this subroutine:

  1. Copy the code below to a VBA module. You can also store it in your Personal Macro Workbook, or create an add-in.
  2. Activate the worksheet that contains the formulas you want to list.
  3. Execute the ListFormulas subroutine. The subroutine will insert a new worksheet that contains a list of the formulas and their values.

The ListFormulas Subroutine


Sub ListFormulas()
Dim FormulaCells As Range, Cell As Range
Dim FormulaSheet As Worksheet
Dim Row As Integer

' Create a Range object for all formula cells
On Error Resume Next
Set FormulaCells = Range("A1").SpecialCells(xlFormulas, 23)

' Exit if no formulas are found
If FormulaCells Is Nothing Then
MsgBox "No Formulas."
Exit Sub
End If

' Add a new worksheet
Application.ScreenUpdating = False
Set FormulaSheet = ActiveWorkbook.Worksheets.Add
FormulaSheet.Name = "Formulas in " & FormulaCells.Parent.Name

' Set up the column headings
With FormulaSheet
Range("A1") = "Address"
Range("B1") = "Formula"
Range("C1") = "Value"
Range("A1:C1").Font.Bold = True
End With

' Process each formula
Row = 2
For Each Cell In FormulaCells
Application.StatusBar = Format((Row - 1) / FormulaCells.Count, "0%")
With FormulaSheet
Cells(Row, 1) = Cell.Address _
(RowAbsolute:=False, ColumnAbsolute:=False)
Cells(Row, 2) = " " & Cell.Formula
Cells(Row, 3) = Cell.Value
Row = Row + 1
End With
Next Cell

' Adjust column widths
FormulaSheet.Columns("A:C").AutoFit
Application.StatusBar = False
End Sub

Source: j-walk.com/ss/excel/tips/tip37.htm

Installing GD library using CPanel

 

If you need to enable imagecreatefromjpeg on CPanel hosting, then do the following…

  • Go to WHM -> Software -> EasyApache
  • If prompted to upgrade, do so then repeat the above step
  • Begin customizing based on the current provile
  • Proceed through the screens until you get to “Step 5″
  • On “Step 5,” click on “Exhaustive Options”
  • Under PHP, check the checkbox for GD
  • Proceed with Build & Compile Process

Source: http://forums.cpanel.net/f5/how-instal-gd-library-114941.html

 

Releasing a product into the wild: an honest survival guide

A list of some things to be aware of when planning on launching or relaunching a website. The process is never 100% error free, but how big the issues are depend on certain factors and how you deal with them will be down to the processes you have in place prior to launch.

Read full article >

How do marketers manage their mobile email channel effectively?

In 2012, more than half (52%) of 18-34 year-olds had clicked through to a website from a mobile email, and in 2013 48% of all emails were opened on mobile.

It’s therefore imperative for email marketers to ensure their communications are suitably optimised for all mobile devices – how to marketers manage this channel effectively?

Read full article >

What’s new for agencies in 2014?

Econsultancy published their Top 100 Digital Agencies Report again last week and while many of the names are similar, the emergence of new players and shifting of rankings indicates that the market is undergoing continuous change.

There is also some discussion about the changing nature of the agency model. In this post, Econsultancy asked Sitecore’s marketing director for his opinion on on opportunities and challenges for agencies in the coming year.

Read full article >