Office

If you do not know which version of Office you have installed, the name of the .msi file requested indicates the Office version you have. The following tables tell which .msi files go with which Office versions.

Office 2003 .msi files

Office XP .msi files

Office 2000 .msi files

Note  In Office 2000, the file name data1.msi does not clearly identify which version of Office you have. In this case, you need to inventory the installation of Office programs on your computer by examining your Start menu entries or click Add or Remove Programs in Control Panel and scan through the list of entries to determine the version of Office that is installed.

You will need two columns. One will hold the data for the barcodes, the second will hold the barcode. In the second field, enter ="*"&A2&"*", replace A2 in this example with the field where the data is held.

Select the desired Barcode font and size for this Cell (where the barcode is), using the Excel Font and Size selection boxes

Be sure to have a database open than you can modify. The best way to do this is to make a new database, just be clean and delete it afterwards.

1. On the Create tab, in the Other group, click Macro, and then click Macro.
2. On the Design tab, click Show All Actions in the Show/Hide group.
3. On the Macro1 tab (right below where you just were), select RunCommand in the Action column, and then below, select WorkgroupAdminstrator in the Command list.
4. In the Tools group, click Run. (the red !, top left).
5. Select Yes. Then select OK.

Then join them in as you would normally in other version of Access.

Most versions of Microsoft Excel have an option to open multiple Excel windows for mulitple documents, or keep them in all one window (i.e. MDI interface) that can be enabled/disabled to suit different users tastes. First, go to Tools, then Options on the Excel menus.

Next, check or uncheck Windows in Taskbar to suit your preference, then hit OK.

Sometimes When out of the office, you might want to auto respond with an email letting other users know you are out, and also send a copy of your message to a co worker or someone else.

Note: For a primer on the Out Of Office Assistant, see:
http://it.precisemachining.com/kb/index.php?/archives/7-How-to-use-the-Out-of-Office-Assistant-in-Outlook.html

Forward without notification

You should use this method if you do not want people sending you email to be aware that your mail is being forwarded, nor that you have an alternate email address.

To set forwarding without notification:
1. In the Outlook Inbox, click on Tools | Rules and Alerts to display the Rules and Alerts dialog box.  If a window appears asking whether to keep “Client” rules or “Server” rules, click on the Server button.
2. In the Rules Wizard dialog box, click on the New Rule button to display the first step in the rule creation wizard.

3. Click in the Start from a blank rule box, make sure that the Check messages when they arrive option is selected and click on the Next button.  The second step in the rule creation wizard will be displayed. This step lets you set conditions.
4. For the rule to apply to all incoming messages, make sure that none of the conditions are ticked and click on the Next button. A warning message will be displayed.
5. Click on the Yes button to confirm that you want the rule to be applied to all incoming email. The third step in the rule creation wizard will be displayed. This step lets you set actions.
6. In the list of actions, tick redirect it to people or distribution list. (Do not tick “forward it to people or distribution list” as this option is a client only action and requires Outlook to be running for it to work.)  The redirect statement will be added to the rule description area.
7. In the rule description area, click on the blue underlined phrase people or distribution list to set the address to send messages to.  The Rule Address dialog box will be displayed.
8. An internal address can be selected by choosing it from the list in the left pane and clicking on the To button. An external address can be typed directly into the right pane.
9. After specifying the address to forward to, click on the OK button to return to the Rules and Alerts step 3 dialog box.
10. The redirect action only forwards a copy of the incoming mail to the specified destination. The original message will remain in your LSE Inbox.  To avoid a build up of forwarded mail in your Inbox, it is recommended that you also tick the delete it option.  This will only delete the LSE copy of the message and not affect the forwarded copy. (Do not tick the “permanently delete it” option as this option is a client only action and requires Outlook to be running for it to work.)

Note: Selecting the delete option in addition to the redirect option will forward a copy of the incoming message and then move it to the Deleted Items folder. It will remain there until the Deleted Items folder is emptied. Messages in the Deleted Items folder count towards the size of the mailbox and can cause the mailbox to go over quota. Emptying the Deleted Items folder regularly will prevent this from happening. The Deleted Items folder can also be emptied via the web email service by clicking on the “Empty Deleted Items Folder” button.

11. Click on the Finish button and the rule will be listed in the Rules and Alerts window.
12. Click on the OK button.

Forward with notification

Using this method to forward mail from your Microsoft Exchange Inbox automatically informs your correspondents of your alternate email address along with an appropriate message.

to display the Out of Office Assistant dialog box.To set forwarding with notification:
1. In the Inbox, click on Tools | Out of Office Assistant to display the Out of Office Assistant dialog box.

2. In the dialog box, click on the I am currently Out of the Office button.
3. In the rectangular text box headed AutoReply only once to each sender with the following text, type in your message that will be autoreplied with.

4. Click on Add Rule button to display the Edit Rule dialog box.
5. In the Perform these actions section of the Edit Rule dialog box, click in the  Forward check box (located three rows from the bottom of the dialog box) until a tick or check mark appears and the To: text box to the right of it brightens up.
6. Click on the To button to specify an address to forward to and the Choose Recipient dialog box will be displayed.
7. An internal address can be selected by choosing it from the list in the left pane and clicking on the To button. An external address can be typed directly into the right pane.
8. After specifying the address to forward to, click on the OK button to return to the Edit Rule dialog box.
9. From the drop-down list next to Method, select the option Leave message intact.
10. The Forward action only forwards a copy of the incoming mail to the specified destination. The ‘original’ message will remain in your Inbox. To avoid a build up of 'forwarded' mail in your Inbox it is recommended that you also tick the Delete option in the Perform these actions section of the Edit Rule dialog box.  This will only delete the local copy of the message and not affect the forwarded copy.
11. Click on the OK button at the top right of the Edit Rule dialog box.
12. Click on the Yes button in the message box asking you to confirm the action.  The Inbox Assistant dialog box will be displayed with your forwarding rule listed.
13. Click on the OK button to return to the Microsoft Outlook window.

Cancel a forwarding rule

When you return and wish to have regular access to your email, you will need to cancel the forwarding rule.

To cancel a forwarding rule:
1. On the Tools menu, choose either Rules and Alerts or Out of Office Assistant - according to which you used to set up your forwarding rule.
2. In the list of rules either:

• untick the rule to deactivate it
  
  OR

• highlight the forwarding rule and then click on the Delete button.  A warning message will be displayed.

3. Click on the Yes button to confirm that you want the rule to be deleted.

Note: If using the Out of Office Assistant, click on the option “I am currently in the Office” to cancel it.