Fill alphabet series in excel

 

=CHAR(ROW(B65))

Re-Enable the Disabled System Restore

Using Registry editror:

1.   Type regedit.exe in the Run box.

2.    Navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\SystemRestore and verify that the key on right DisableSR has a value of 0.

3.    If the key is not there then create one DWORD value with the same name DisableSR and give it a value 0 to enable else 1 to disable.

Using Group Policy:

1.    Go to the Group Policy Editor by typing gpedit.msc in the Run box

2.    Navigate to Computer Configuration -> Administrative Templates -> System -> System Restore

3.    Set the following entries to Not Configured

Turn off System Restore
Turn off Configuration

The System Restore feature will be enabled.

Turn Off Outlook Reading Pane by Default at Startup

Reading Pane can be disabled for all folders at startup by creating bellow shortcut.

"C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE" /nopreview

Checking the Microsoft Exchange Connection Status from Outlook

When you use Outlook with an Exchange Server with MAPI, server connectivity is needed for directory queries as well as message store access. A quick way to check which servers Outlook is communicating with is to use the Microsoft Exchange Connection Status dialog box.

 

In Microsoft Office Outlook 2007 or Microsoft Office Outlook 2003 hold the CTRL button  and right-click the Outlook icon in the task bar, select Connection Status. Outlook will automatically find another Global Catalog server on its own, if the one it's connected to become unavailable. This is a quick way of verifying that Outlook is establishing client-server communications. The Reconnect button will force Outlook to attempt to find a Global Catalog server and its mailbox server. If it's already connected to those, it will disconnect and reconnect (as the button name suggests).

 

 

Disable Reply To All and Forward in Outlook using Macro

Go Tools|Macro|Macros...

In the next dialog, type something like NoReplyAll and click Create.

Add these lines to your new subroutine:

ActiveInspector.CurrentItem.Actions("Reply to All").Enabled = False
ActiveInspector.CurrentItem.Actions("Forward").Enabled = False

Then close this window.

At this point you've got a macro that prevents Replying to All and Forwarding (at least within Outlook world. This won't prevent folks running other mail systems from Replying to All, but we're mostly focused on internal work with this tip.)

Now, open up a new Outlook Message and right click at the VERY top (assuming Outlook 2007).

Click More Commands...now from this dialog select "Macros" from the dropdown, select your new Macro and click Add>>.

If you like, click on your Macro on the right and select the Modify button and pick a nice icon for it and a Display Name. I used a "halting hand" icon:

Click OK and look at your Quick Access Toolbar...you've got a nice little icon there.

Now, CLICK that button then send an email to yourself

Only works if the recipients' email client is Microsoft Outlook.

Reference: http://www.hanselman.com/blog/HowToEasilyDisableReplyToAllAndForwardInOutlook.aspx

Disable Outlook "Reply All" Functionality using Group Policy

1)     Download the appropriate Office Administrative Template files.

2)     Extract the Administrative Template files by running AdminTemplates.exe. Once extracted you should have 3 folders created (ADM, ADMIN, and ADMX):

3)     Create a new Group Policy that links users of the required organizational unit.

4)     Add the Office/Outlook Administrative Templates to newly created Group Policy

5)    

If performed successfully you should now see that the Microsoft Office Outlook 2007 Administrative Template files have been added in Group Policy Editor:

6)Once you have successfully added the Outlook Administrative Template, you need to properly define and enable the necessary policies. To successfully block "Reply All" functionality we need to enable and define two specific policies in the Administrative Template:

• A policy to disable the actual command button as well as the menu option.
• A policy to disable the keyboard shortcut.

To accomplish:

• In Group Policy Editor navigate to the following path: User Configuration\Administrative Templates\Microsoft Office Outlook 2007\Disable Items in User Interface\Custom.
• Once here you will notice 2 policies that will currently show as "Not Configured":
• Disable Command Bar Buttons and Menu Items.
• Disable ShortCut Keys.
• To disable the Command Bar Reply-All button we need to select the Disable Command Bar Buttons and Menu Items Policy.
• Once the policy is open set the State of the policy to Enabled then select the "Show..." button.
• Any and all Outlook Command Bar Buttons that are currently disabled will be present here in a numerical context (although presumably this would be the first time working with the template so you would not see any numerical values present). Click Add, and in the "Enter the Item to Be Added" field, type 355. Once done click OK. You will be returned to the Show Contents page which should now resemble the following. Click OK:

 

• Back on the Disable Command Bar Buttons and Menu Items policy page, select Apply and OK.
• The "state" of the policy should now show as Enabled.
• Now we need to disable the keyboard shortcut for Reply All. To do so, we need to open the Disable Shortcut Keys policy, configure our settings and enable it. To do so:
• Select and open the"Disable Shortcut Keys" policy.
• Select Enable, and then click the "Show..." button.
• This will bring up the Show Contents page.
• Select Add.
• In the Add Item Window type the following: 82,12
• Click OK which will shift the focus back to the Show Contents pane. Your value should look like this:

• Back on the Disable Shortcut Keys property pages, select Apply and OK.
• Back in Group Policy Editor, both policies should now show as Enabled:

Step-9:

They will also notice that the menu option for Reply-All is now disabled:

 

Bellow are some additional Command IDs and shortcuts

Reference: http://blogs.technet.com/b/exchange/archive/2009/09/29/3408403.aspx

Color Code e-mails in Microsoft Outlook 2007

Here's how we do this…choose the Tools menu followed by the Organise menu item:

Next, click on Using Colours. I already have e-mail that is sent to me and me only appear in blue, hence the option to turn it off is available. Assuming that you don't have this option enabled, click on the Automatic Formatting button at the top right:

By default, Microsoft Outlook provides a handful of automatic formatting rules, one of them is "Mail sent directly to me":

Sending As in Outlook - Exchange

http://www.msexchange.org/tutorials/Sending-As.html

How to grant Send On Behalf Of permission

http://www.cryer.co.uk/brian/msexchange/exch_howto_grant_send_on_behalf_of.htm

"Send on Behalf Of" allows one user to be able to send emails on behalf of another. The message will show the recipient who the message was sent on behalf of and who actually sent the message.

There are two ways of granting "Send on Behalf Of":

• via Outlook
  allowing a user to grant others to send on their behalf
• via Active Directory Users and Computers
  which can be performed by system managers only

Grant Send on Behalf of via Outlook

This procedure will allow you to grant other users the ability to send on your behalf:

1. Start Outlook
2. Tools → Options, select the "Delegates" tab
3. Click on [Add ...]
4. Add the user or users that you want to grant the send-on-behalf-of permission to, then click [OK]
5. The next window will allow you to specify which permissions you are granting. To allow send-on-behalf-of, you need to grant permissions on the "Inbox" to either "Author" or "Editor", then click [OK]
6. Click [OK] to close the "Options" dialog.

Note:

• The above has been demonstrated to work when using Outlook 2003, but not with Outlook 2000 connected to a Exchange 2003 server (I have not had time to identify why).
• See also "How to send a message on behalf of another"

Grant Send on Behalf of via Active Directory Users and Computers

This procedure will allow system managers to grant users the ability to send on the behalf of other users:

1. Log onto the server running Exchange.
2. Run Active Directory Users and Computers.
3. Find the user's account that you want to be able to send on behalf of, and open up the account properties.
4. Select the "Exchange General" tab.
5. Click [Delivery Options...]
6. Click [Add ...] and add the user (or users) that are to be granted permission to send on behalf of this account.
7. Click [OK] to close the "Delivery Options" dialog.
8. Click [OK] to close the account properties dialog..

See also "How to send a message on behalf of another".

How to Send a Message on Behalf of Another

To send an email on behalf of another (assuming you have been granted the necessary send-on-behalf-of privilege):

1. Start Outlook.
2. Go to your Inbox.
3. Click [New] to start a new mail message.
4. If the message does not show a "From" field then pull down the "View" menu and check "From Field".

   Note: I have noticed that if you have Outlook set to use Microsoft Word then the "From Field" does not appear in the "View" menu. The work around is to clear the option to use Word (Outlook → Tools → Options → Mail Format → Use Microsoft Office Word 2003 to edit e-mail messages), you will then be able to show the From field, and this remains even if you re-select to use use Word to edit emails.

5. Click [From...] and select the account that you wish to send an email on behalf of.
6. Compose the email as normal.

Note:

• When you try to send the email you will get an error if you have not been granted the necessary send-on-behalf-of permission.
• To the recipient the email will show both the true author and who it was sent on behalf of.

Keyboard shortcuts for Outlook - Outlook - Microsoft Office Online

Keyboard shortcuts for Outlook - Outlook - Microsoft Office Online

Outlook 2007: Prevent Forwarding of a Message

Sending a message to someone and you would prefer that they not forward it to someone else? You can prevent the forwarding of your message by following these steps:


1. Open, create, and address the message as you normally would.

2. Click the Office Button.

3. Mouseover Permission and select Do Not Forward.

Note: You need to have the Windows Rights Management Client installed, if you do not, a prompt will appear. Click Yes and you can download and install the client. You will need a .NET Passport to register and download an RM account certificate.

Enable user password changes through Outlook Web Access (OWA) in Exchange 2003

Yes, although this behavior is not enabled by default.
In order to do so you must first configure your server to use SSL.
Then, you need to create a new Virtual Directory called Iisadmpwd under the Default Web Site.
1. Open Internet Information Services Manager from the Administrative Tools.
2. In IIS Manager expand SERVERNAME (Where SERVERNAME is your server name object), expand Web Sites, and then expand Default Web Site.
3. Right-click Default Web site and choose New, then select Virtual Directory.
4. In the Welcome screen click Next.
5. In the Virtual Directory Alias window type Iisadmpwd. Click Next.
6. In the Website Content Directory screen navigate to %Systemroot%\System32\Inetsrv\Iisadmpwd. Click Next.
7. In the Virtual Directory Access Permissions grant Read, Run Scripts and Execute permissions. Click Next.
8. Click Finish.
9. See that the new Virtual Directory is listed in the folder list on the right-pane of the IIS Admin console.
Next, you need to enable the Change Password button in the Registry of the server.
Note: This article was written at a time when there was no other method of performing the above. Nowadays we can use a nice graphic tool called OWAADMIN to perform the same trick (and many others). However even with OWAADMIN you will still need to perform parts of the steps outlined on this current page. The only step you can skip is the following step:
1. Open Regedit.
2. Navigate to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSExchangeWEB\OWA

3. Create a new REG-DWORD value with the name of "DisablePassword" (without the quotes) and give it the value of 0 (zero).
4. Restart the IIS Services (you can do it from the IIS Admin tool).
Now check to see if the Change Password option is available in OWA:
1. Open OWA in a web browser (remember, you're using SSL now, so it has to start with HTTPS://).
2. Logon with your username and password.
3. Click on the Options button.
4. In the Options window scroll all the way down. Notice the Change Password button.
Click it.
5. Notice the Change Password window opening. Try to use it.

NOTES
Just a tip, we have a front end server and 7 back end servers. For this to work correctly in this configuration, your procedure should be followed on the front end server only. Then, the backend servers only require the DisablePassword registry change to be done.
I thought that would be a useful addition to the article.
Indeed. Thanks Brett!
Another reader note: Reader Rob Fisher says:
In the link above, I found a step you missed.
You also have to go into the iisadmpwd virtual folder properties, select configure in the application settings area of the virtual directory tab, and remove the davex.dll. You may get a 501 error if you don't do this. Thanks for the help!
Thanks Rob!
Yet another reader note: Reader Eric Bridie says:
First I want to thank you for the brilliant articles. I just have an extra comment regarding password changes in OWA.
My environment is a Windows 2003 SBS SP2 R2 Enterprise. To get the OWA password change working I needed to change a firewall rule. The change is: Add the Iisadmpwd directory to the SBS OWA Publishing Rule. Hope other people can use this info.

Can I stop Outlook from asking me for my password when connecting to the Exchange Server?

It is possible to save your password in Outlook 2003 and 2007. You must be running on Windows XP or Vista (any edition except Windows Home).

Note: These steps do not work when you have Outlook configured to use RPC over HTTP. For instructions on how to save your password using RPC over HTTP, please see KB Article 1399.

Here are the steps you need to take:

1. Open the Windows Key Manager:
* Click Start > Run
* Type "control keymgr.dll"
* Click OK, then Add
* Enter your Server Name. It can be found in HostPilot > Get Started > Advanced Settings under Exchange Server.
* Enter your domain\username as a user name instead of the mailbox address:
What is my User Name and Primary Email Address for my Exchange mailbox?
What is my Exchange Domain?
* Enter your mailbox password
* Click OK and then Close
2. Open Outlook:
* Choose a Outlook profile (if there are more than one) and click Ok.
* Enter your domain\username as a user name instead of the mailbox address:
What is my User Name and Primary Email Address for my Exchange mailbox?
What is my Exchange Domain?
* Check the box "Save the Password"
3. Close Outlook after login is complete
4. Launch Outlook again
5. When prompted for your password, click Remember Password
6. Close Outlook
7. Launch Outlook - This time you should not be prompted for your password.

'Error in registry for extension "Exchange Extensions;?"' in OUTLOOK 2003

Outlook 2003 connected to Exchange 2003 gives error like 'Error in registry for extension "Exchange Extensions;?"' OK box 3 time continuesley, but then it starts work normally. This will happen when you try to start out look or try to access properties page of any folder.

Solution: Download and install SP 3 for Microsoft Office.

Cant dismiss reminders in outlook 2007

Cannot dismiss reminders in outlook 2007. It pop up again and again.
Outllok connected to exchange server 2003. This issue only for a single reminder, the rest of them are ok.

Solution: I tried to start outlook with /cleanreminders switch, but invain. Download Messaging API (MAPI) Editor from Microsoft and run it.
You can locate the problem reminder in it and delete it from there.

MS Word crashes with event ID 1000

Microsoft word crashes when user tries to edit and save documents. Event Id 1000.

Solution: Check your default printer. Change your default printer in to software printers like send to one note or cute pdf wtriter. Otherwise uninstall all printers.