Electronic Stationery Orders

Printing and Stationery Services have designed an electronic stationery order form to replace the current paper form. The idea is to make the ordering process easier for you whilst saving costs and generally making the whole process run much smoother.

Instructions

Before you start

You will need to change a security setting in Excel. Open Excel and click on 'Tools' then select 'Options'. Click the 'Security' tab and then click the 'Macro Security' button. Click 'Medium' then 'OK' and 'OK' again. You will only need to do this once on your machine.

You will also need to create a numbering system for your stationery orders. We will quote these numbers in any correspondence and on the internal re-charge.

Using the spreadsheet

The spreadsheet has been changed to prevent it from running when Macros are disabled. Follow the on-screen instructions to enable the Macros.

Click here to access the spreadsheet then click 'Save'. Select a location to save the spreadsheet, click 'Save'. The file will download and on completion click 'Open'. You will get a security warning - click 'Enable Macros' then the spreadsheet will open in Excel - you may need to click on the Excel button on your task bar to see the spreadsheet. You may see a yellow screen briefly flashing as the spreadsheet opens or closed. This is normal behaviour and can be ignored.

Please ensure that you complete all details on the top of the form. You will need to enter an order number to your form as this will be used to track your order.

To quickly find the section you require click on the second tab at the bottom of the page named ‘Headings Lookup’ and then click on the section that you require. This will take you directly to the beginning of your chosen section. Place the numbers of items required into the box in the ‘Units Required’ column.

If you require any items that are not listed on the form please enter the details in the section at the end of the form entitled ‘Non-Stock Items.’ Please complete all sections and if ordering items that are from another source than Lyreco please type N/A in the code number and page number boxes. Note, with effect from 14 February 2007 your Dean, Associate Dean (Resources) or Head of Service will need to sign the stationery form if you are ordering non-stock items. Click here for more information.

Once you have finished your order click on the ‘Complete Order’ button. You will then be prompted to print your form. Only the items that you require will appear on your print out. You will now need to acquire a sanction signature before putting your form in an envelope addressed to 'Printing and Stationery, Emersons Green'.

Things that might go wrong

When opening the spreadsheet you only get a yellow screen telling you macros are disabled
Macros are not enabled on your machine. They must be enabled for the form to work. Follow the instructions provided.

You can't print the order form.
Printing the form before pressing the 'Complete Order' button will generate an error message telling you to press this button. This change has been implemented to reduce waste. If you do not get an error message check you can print from another spreadsheet or application before contacting Printing and Stationery.

You don't see the Security Warning and the buttons on the spreadsheet don't work.
This is because the macro security settings have not been set to Medium, so follow the instructions above.

Nothing happens after clicking the link on the web page.
Because you are opening an Excel spreadsheet from Internet Explorer the Security Warning does not always pop up in front of all your other windows. Click the Excel button in your task bar (the line at the bottom of the screen) and you should see the message.

You click the 'Complete Order' button before you have finished.
You will either need to start again from the web site link or print the order you have completed and then create another one for the remainder of the order.

You see a yellow screen briefly when opening or closing the spreadsheet
This screen advises users that they have macros disabled. It will briefly appear when macros are enabled when opening and closing the spreadsheet. You only need to take action if this is the only screen displayed when opening the spreadsheet.

You want to save the whole spreadsheet so you can easily access it again.
Please don't! We will be constantly updating the spreadsheet and uploading on the web site. If you save a copy you will not have the current product details or any improvements to the macros. There is no reason why you cannot save the completed spreadsheet but note that if you click the 'Complete Order' button again you will get an error message - this is working as designed!

Notes

You are still required to print the form and send a signed hard copy to us as you would with the green order form.

Please ensure that you give each order submitted a unique reference. You will need to quote this reference if you contact us.

Please contact our Stationery Coordinator if you have any queries.