Document Actions
MS Office Tip
Up one levelDocument Actions
How to customise the Places Toolbar in MS Office
If you are like me (and thousands of other users) then I am quite certain that you do not save your documents, spreadsheets, presentation in the My Documents folder on your computer. There is nothing wrong in doing that. But we just don't do it. At homes we like to create a folder by our names and then save in our stuff in there and in office we all have been allocated a home drive and / or a shared folder on the network drive. Saving your stuff in the My Documents and it's sub folders makes sense if you are the only one who will be accessing it. Like your tax records or personal information. In a situation where you have to share it with many people, it makes sense to store it in a common location.
How many times do you have to open or save a file in that particular location and always have to navigate to that location. If that location is on the network and network is slow, then it probably takes forever to navigate to that location. Here I offer a way to reduce the amount of time it takes to navigate and save files by adding the location in the "Places" tool bar in Windows. In the open and save dialog boxes, Windows provides a "Places" bar located vertically on the left hand side of the window.
If you are using Office XP or 2003:
- Navigate to the location (folder) that you want to add to the Places bar.
- Click on the tools menu on the right hand side top corner, and click on Add to My Places
If you are using Office 2007 Beta2:
- Navigate to the location (folder) that you want to add to the places bar
- Right click on the Places toolbar itself and click on "Add folder_name".
All the context sensitive functions (by right click) like rename, remove work for these shortcuts as well so you can choose to remove it or rename it if you wish.
The folder will start appearing in the Places tool bar in all office location from the next time. Once you have done that, you can export the registry keys from the registry in case you have to reformat the computer or move to a new location. The registry key is located at:
For Office XP
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Common\Open Find\Places\UserDefinedPlaces
For Office 2003
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Open Find\Places\UserDefinedPlaces
For Office 2007
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Open Find\Places\UserDefinedPlaces
- Category(s)
- Technology
- MS Office Tip
- The URL to Trackback this entry is:
- http://www.dharwadkar.com/weblog/places_bar/tbping
Saving files in 97-2003 format in Office 2007 by default
In addition to some great new features, Microsoft introduced XML based file formats for Word, Excel and Powerpoint 2007. However, the new formats can be the newest annoyance till the time Office 2007 is not deployed and adopted in enterprise and home users. Microsoft Office 2007 saves all the files in the XML formats by default (.docx, .xlsx, pptx extension) which are not readable by the previous versions of Office.
To ensure compatibility with older versions, you have to save the files in 97-2003 format. Trying to remember to do that everytime you create and save a document can be irritating, especially if you create a lot of documents, spreadsheets or presentations.
To avoid remembering to save the document in 97-2003 format, you can setup office so that it saves all new files in the 97-2003 format by default. However, this is not a global setting and this must be done for each of the three office applications, i.e. Word, Excel and Powerpoint.
To change the setting, click on the Office icon in the left hand top corner and click on <Application> Options (Where Application is either Word, Excel or Powerpoint). In the resulting window that is shown above, click on Save to customise the settings and in the Preserve the backup information for your documents section select Word 97-2003 Document (*.doc) from the drop down list next to Save Files in this format: option.
Once you set this option for all office applications, Office will start saving the files you create henceforth in what it calls as Compatibility Mode.
- Category(s)
- MS Office Tip
- The URL to Trackback this entry is:
- http://www.dharwadkar.com/weblog/file_formats/tbping
Sending Auto response directly from MS Exchange Server
Recently one of my co-workers came to me asking me whether it was possible to send automatic response to message directly from the server. There are situations where it is necessary to send automatic response directly from the server. The preconfigured Out of Office rule is a working example of that. Only, it sends a Out of Office: preamble to every message and it sends response only to the first email received from a particular sender. It may be necessary to send response to every message and with a customised subject and message.
Step 1: In your Outlook Client click on Tools --> Rules and Alerts. If you are using Office XP or older, then you will see Rules Wizard instead of Rules and Alerts.
Step 2: In the Rules Wizard select the Start from a blank rule - Check messages when they arrive option and click Next. In Office 2003 and previous versions, the Start from a blank rule option is available at the top of the dialog window. This will apply the rule to messages as they arrive in the inbox. In the next screen don't select anything and click on Next. It will pop-up a warning that the rule will be applied to all incoming messages. Click Yes to proceed.
Step 3: In the next window, select the action have server reply using a specific message. Click on the specific message link in the lower pane and it will open up a new mail message window. Type in the subject and the message you want to send to all leaving the To: and CC: fields blank. Once you are satisfied with the message, click on Save and close at the top left of the message window.
Step 4: In the next window, select the appropriate exclusion option if any and click Next. Give the rule an intuitive name. Make sure that you don't check the check box next to Apply this rule to messages in Inbox folder. Click OK after turning on the rule.
For any message that you receive after this point, the server will send an automatic reply to sender whether or not your Outlook Client is running or not.
- Category(s)
- Windows
- Computer Tip
- MS Office Tip
- The URL to Trackback this entry is:
- http://www.dharwadkar.com/weblog/msexch_tip01/tbping
Re:Sending Auto response directly from MS Exchange Server
I set our Auto Response just like this and it didn't work. What could I be missing here. doug@titleboxing.com
Re:Sending Auto response directly from MS Exchange Server
I agree with doug, there has to be something more than this on the server side... it just isn't doing it. Please help!
Re:Sending Auto response directly from MS Exchange Server
Hi Myles,
I checked out what Doug had said and what he (and probably you are also) was trying to do was a special case of this feature. I have posted another weblog entry to treat this special case (http://www.dharwadkar.com/weblog/msexch_tip02).
Re:Sending Auto response directly from MS Exchange Server
The reason why it is not working for some of you guys is because you have to enable automatic replies in Exchange Server Manager.
Carry out as instructed about and then make sure this is enabled on ESM:
1. Open Exchange System Manager
2. Select Internet Message Formats under Global Settings
3. Double click on DEFAULT in the Right pane of the MMC
4. Select the Advanced tab
5. Select "Allow Automatic Replies"
Thats it.
Re:Sending Auto response directly from MS Exchange Server
How do we keep the original subject? And make the auto reply more personal:
Ie: RE: [original subject]
Dear [Sender Name] Thank you for your email bla bla bla
Sending Auto response directly from MS Exchange Server - Special Case
Thanks to reader Doug Mason who pointed out a special case in setting up an automated response to emails directly from the server. Many a times we have a generic email account that is published on the internet for customers / vendors to send emails to for making inquiries. The emails to that mailbox are generally forwarded to another mailbox of a real person who will then read and respond to the email. Depending on the volume of the incoming email and the nature of the inquiry, the response to the email may take anywhere between 1 day to 7 days. In the meantime we don't want to keep our customers in dark and with a feeling that the emails go into a black hole and want to respond with a canned message which would go out automatically only when an email is received from the generic id and none else. This would be because the person may be receiving emails from many people and it is not desirable to send out this message to them.
In such cases, the previous entry on this subject does not work as intended if you choose the first option "from people or distribution list" (circled in red) and give the generic id as the email address. No email will be sent out to either the original sender or the generic id. This is because when setting up the forward at the server level, Microsoft Exchange instructs the intermediary mailbox to act as a mailman and it does not add any headers to the email. So the final recipients still received the email from the original sender and not the generic id. But in the To: field, the recipient still remains as the generic intermediate mailbox address.
To overcome this, instead of setting the rule to trigger on receiving email FROM someone, set the rule to trigger on receiving email SENT TO someone (in this case the generic Id) by checking the box next to "sent to people or distribution list" (circled in blue).
Once this change is made, this rule will again start working.
- Category(s)
- Windows
- Computer Tip
- MS Office Tip
- The URL to Trackback this entry is:
- http://www.dharwadkar.com/weblog/msexch_tip02/tbping
Re:Sending Auto response directly from MS Exchange Server - Special Case
Using Outlook 2003/Exchange 2003 with the above scenario.
Selecting "Check messages when they arrive", "sent to people or distibution list", "have server reply using a specific message" DOES NOT send an auto-reply as expected. Either this feature does not work, or there is a setting required that is not documented!
Re:Sending Auto response directly from MS Exchange Server - Special Case
I have created the rule, but outlook displays a message that it is client only rule. Is this due to the template is sitting on the client PC?
Please help.
Re:Sending Auto response directly from MS Exchange Server - Special Case
Hi All,
I have done thorough testing for this rule settings and found to be working correctly. I have set similar rules on my mailbox and it is not a client based rule. It is definitely a server based rule.
If anyone of you can send me a email on the email addresses documented on this website, we can troubleshoot further.
Re:Sending Auto response directly from MS Exchange Server - Special Case
I too am using Outlook 2003/Exchange 2003. After following the above instructions, no auto response is generated, even when going into outlook's rules and alerts and clicking "run rules now." Are there more instructions to follow?
Re:Sending Auto response directly from MS Exchange Server - Special Case
No really, there are no other instructions to follow. This is all that is needed to be done. You can send me a set of screen shots on my email and I can take a look at it.
Re:Sending Auto response directly from MS Exchange Server - Special Case
Hi,
I have configured outlook, and auto-response works, but is it possible to set auto-response and then remove mail configuration (Outlook) from all Desktop. Can sender will get Auto-Responce then also as ID is created on Exchange server.
Re:Sending Auto response directly from MS Exchange Server - Special Case
Hi,
I have configured outlook, and auto-response works, but is it possible to set auto-response and then remove mail configuration (Outlook) from all Desktop. Can sender will get Auto-Responce then also as ID is created on Exchange server.
Re:Sending Auto response directly from MS Exchange Server - Special Case
Hi,
When you set up the rule, choose the option, have the server send a reply. If that is done, then it doesn't matter if their is Outlook client present on the desktop client or not. The action to send the response will be triggered at the server itself.
Hope this helps. If not send me an email and we can go in details.
Re:Sending Auto response directly from MS Exchange Server - Special Case
The reason why it is not working for some of you guys is because you have to enable automatic replies in Exchange Server Manager.
Carry out as instructed about and then make sure this is enabled on ESM:
1. Open Exchange System Manager
2. Select Internet Message Formats under Global Settings
3. Double click on DEFAULT in the Right pane of the MMC
4. Select the Advanced tab
5. Select "Allow Automatic Replies"
Thats it.
Re:Sending Auto response directly from MS Exchange Server - Special Case
It works great ,no issues ....Helped me great...
Re:Sending Auto response directly from MS Exchange Server - Special Case
Any ideas on how to "Allow Automatic Replies" in Exchange 2007?
Re:Sending Auto response directly from MS Exchange Server - Special Case
For Exchange 2007:
1. Open Exchange Management Console
2. Expand "Organization Configuration"
3. Select "Hub Transport"
4. Right-click on "Default" in the "Remote Domains" tab and click "Properties"
5. In the "Format of original message..." tab, you can check "Allow Automatic Replies" and "Allow Automatic Forwards".
Hope that helps.
Re:Sending Auto response directly from MS Exchange Server - Special Case
Como puedo hacer si quiero dar una respuesta automatica de los mails enviados a un usuario de la organizacion que ya no labora en dicha empresa, ya que quiero hacerlo directo desde el servidor y no desde el cliente outlook.
Tengo exchange server 2007
Re:Sending Auto response directly from MS Exchange Server - Special Case
No elimine el buzón del usuario desde la que desea las respuestas para ser enviados. Denegar el inicio de sesión para los usuarios y establecer una respuesta automática en el servidor como se describe en el artículo.
How to add another mailbox to your Outlook client
It might so happen that you might have to access another person's email for a number of reasons, or you have a generic common mailbox (say enquiries@yourcompany.com) which you are required to monitor and respond. The easiest way is to configure that person's mailbox in another profile and open your MS Outlook client using that profile. But then that limits your ability to access your own email and it quickly becomes a pain to close and re-open Outlook in different profiles. You might also use another computer to access the other mailbox, but then that is also tedious and a less than elegant / efficient solution. What you really want to do is to open the other mailbox right from within your mailbox and keep it open. Fortunately Microsoft Exchange and Outlook provides such capability.
To add another mailbox to your profile, click on Tools --> Email Accounts (Account settings if you are using Office 2007). In the resulting window that pops up ensure that View or change existing email accounts is selected and then click Next.
In the next window where you see Microsoft Exchange Server, ensure that the Microsoft Exchange Server is selected / highlighted and click on Change. In the next window, click on More settings. In the resulting pop-up window that appears, click on Advanced tab and then click on add. In the next window, enter the user's name and then click OK. You should now see the account name in the previous window. Click OK your way out and you now should see the new mailbox below your regular mailbox.
Note: For this to work, your email administrator must have granted read access to you on the destination mailbox. If not, although you will be able to add a mailbox, you won't be able to access it and get a failure warning.
- Category(s)
- Windows
- Computer Tip
- MS Office Tip
- The URL to Trackback this entry is:
- http://www.dharwadkar.com/weblog/msexch_tip04/tbping




How long do you think it will take MS to have a "Fix" to enable this on Office 2007. I say within a week of the launch date. No corporation will roll out Office 2007 with out way to set the default save as.
I don't think Microsoft will provide a "fix to enable this by default. XML based document format is the direction in which Microsoft wants (us, the customers) to move. It will be up to the individual IT departments to set this in their desktop images or via policy. If you happen to be a home user, well, just remember to save it in 97-2003 format. Good Luck.
What can I do when these settings are not saved.
I'm able to change te settings as described above. When I close Word en start it again the settings remain. BUT when I logoff from my computer and logon again the setting is back to default.
It appears to me as a Windows profile issue. If you are in an Active Directory domain, your administrator might have set a mandatory profile which will overide all your personal settings on log off.
I want to know how to do that from VBSSCRIPT... i have found how for MSWORD to save in .doc but it's look impossible for EXCEL
This work for MSWORD, i have try many other option for EXCEL... No luck
Set objWord = CreateObject("Word.Application")
objWord.DefaultSaveFormat = "doc"
objWord.Quit