home > office integration

micosoft office 2000 · 2002 (XP) · 2003 · 2007 integration

We integrate the Access, Excel, Word and Outlook programs in Microsoft Office to make information flow with the minimum of hassle for the user and to automate the sometimes complex tasks that otherwise require boring, time-consuming and repetitive manual operations and are prone to human error.

A main aim of ours is to make the information a client holds readily available from a single source to anyone in their business who needs to use it. Thus efficiency gains are achieved in data collection, maintenance and storage, and in information distribution and reporting.

example of office integration

This is a simple example of how information stored centrally in a Microsoft Access contacts database is made available for use in:

Letters and faxes
E-mails
Mail shots and news letters
Invoices and statements
Printouts for inclusion in filofaxes
Downloads to PDAs
Christmas-card lists
Mailing labels.

For instance, when a user starts a new letter based one of our Microsoft Word letter templates, information in the database is drawn in by the template to provide the name, address and salutation for a letter:

Opening the Contact list makes Word link with details in the Access database to present an alphabetical list of the people in the database:

Completing the rest of the dialog box and clicking the OK button puts the user in their letter with these bits already completed for them:

Full name and address (drawn from the database)
Their Ref, if any
A subject, if any
Salutation "Dear Anthony" (name drawn from the database)
Sign off "Yours sincerely, ... David Wallis".

Advantages include:

Names and addresses don't need retyping
Address information available throughout the business
Addressing consistent and accurate
Templates ensure corporate style.

london, kent, surrey, east sussex, west sussex

We travel regularly to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit throughout Kent, East and West Sussex, Surrey and London.

For example, client locations have included Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Ewell, Godalming, Harefield, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells, Whitstable and Westerham.

Where our special skills were required further afield we have travelled to Basingstoke, Chelmsford, Devon, Hatfield, Hemel Hempstead, High Wycombe, Little Barford (Cambridgeshire), Manchester, Milton Keynes, Northampton, Rickmansworth, and Thatcham (Berkshire).