Recent articles

  • VE Day 75 – Friday 8th May 2020

    Our Memorial Hall was built to honour the fallen in two world wars and give thanks to those who returned. It is appropriate therefore that we play our full part in the national celebrations and village activities planned for May Day Bank Holiday 2020 - moved to Friday 8th May for this purpose.Our afternoon begins with a what is hoped will be a re-enactment of what is believed to have been a visit to Metcalfe’s shop by ‘Monty’ which will continue on to The Joiners where there will be renditions of the Last Post and The Battle’s O’er following by a Toast to the Heroes as per the suggested national programme, with the Ukulele Band providing additional entertainment during the afternoon. The evening ends with a 40's Dance Party at the Memorial Hall.
  • UCI Road World Cycling Championships Come Through Hampsthwaite 2019

    Click on the NYCC Interactive Map below to see details of all road closures, parking restrictions, diversions and race timings. Briefly for Hampsthwaite they are as follows:Tuesday 24th Sept. 2019 for High Street and Elton Lane : No Parking: 23 Sep 22:00 - 24 Sep 18:30 - Road closed:  08:30 - 17:30 Mens U23 Individual Time Trial due to come through between 10:35 and 12:18 Women Elite Individual Time Trial due to come through between15:07 and 16:35 Saturday 28th Sept. 2019 for High Street and Elton Lane : No Parking: 27 Sep 22:00 - 28 Sep 16:00 - Road closed: 28 Sep 13:40 - 15:00 Publicity Caravan - leaves Ripon at 12.34 so due here around 1.10pm Women Elite Road Race due to come through between14.29 and 14.47 Click on the FanZone image to see full details of the many attractions on Harrogate centre during race week
  • Plans, Layouts and Resources

    Hampsthwaite Memorial Hall can provide facilities and resources for most events and has a good car park with marked spaces for over 50 cars. There is a well-equipped kitchen and catering area with dishwasher, water-heater, micro-wave, Rangemaster Pro induction cooker and ample supplies of crockery, glassware and cutlery. Adjacent to the Kitchen is a Servery with hatchways through to both the Main Hall and Dining Room (or small hall) which can be used as a bar. The Memorial Hall is licenced to sell alcohol. The Main Hall includes a well-equipped stage area and Green Room at one end, with P.A. system, both rear and front projection facilities for DVD, Blu-ray or data, ample stage-lighting, star-cloth, a mirror ball, and can be rigged with a ceiling canopy if needed. The Main Hall can open out into the adjacent Sun Lounge to accommodate larger numbers or as a bar area. The Dining Room, or small hall, is used for meetings, for groups, to place a buffet for example, or as another alternative bar area. There are ample chairs to furnish each of the spaces using either rectangular or circular tables. Table cloths and chair covers are available on request.
  • George Frederick Grimshaw - biography

    George Frederick Grimshaw 20th October 1914 - 17th June 1940
  • Roman Roads in Yorkshire.

    Gazetteer by the Roman Roads Research AssociationCovering all of Britain’s Roman roads, the Gazetteer, when completed, will be the first survey of Britain’s Roman roads since Ivan Margary’s final edition of Roman Roads in Britain in 1973. We aim to provide an up to date evaluation of each Roman road and, since new discoveries are being made all the time this online resource gives us the flexibility to make amendments and additions.
  • Yoga for Health and Happiness

    Beginners’ 10 week course starts 29th April 2019 at Hampsthwaite Memorial Hall Monday 9:30am – 10:30am Course fee £60  Places limited For more info and to book, contact Sue Beever Mobile 07801 064819 Email suebeever@gmail.com
  • Hampsthwaite’s Dancing for Well-Being group on ITV

    A film featuring Dancing for Well-Being’s Hampsthwaite group will be shown on ITV’s Calendar North News at 6.00 p.m. on Friday 5th April.  From 1st April you can also see the film on the People’s Projects website – www.thepeoplesprojects.org.uk/projects/view/together-through-dance
  • Privacy and Cookies

    This privacy and cookies policy sets out how Hampsthwaite Village 2011 uses and protects any information that you may give Hampsthwaite Village 2011 when you use this website.
  • Sunnyside Cottage, Carpenter's Cottage and Croft View

    (click photo to enlarge)
  • Sunnyside Cottage, Carpenter's Cottage and Croft View - photo

    (click photo to return to full article)
RSS Feed of this page

Mail Merge Lists

Contact details of friends and family for example, can be entered into a spreadsheet or database application to create lists which can be stored, edited, sorted and used to produce outputs such as address labels.

Common 'Office Suites' of software include both a spreadsheet application and a wordprocessor which, when used in combination, can accomplish the task.

Creating a Contacts List

This task can be accomplished used a spreadsheet application or one of the Office Suites of software or even one of the two online versions.
 

Creating Address Labels and Mail Merging

Moving data between applications

In general, most software applications save out files ‘in their own image’, as proprietary file types, and it is these you can usually just click on to open and run the program. To see what else is available, it is often necessary to select 'Export' or 'Save as . .' and click down arrows against prompts such as 'Save as type' to reveal the range of possible file types to export into.

Similarly, applications are increasingly able to receive files in a range of file formats and these can be seen via drop-downs alongside Open or Import options found in File menus.

Saving worksheets:

A common basic file format for spreadsheets is CSV (comma separated variable) and almost all will save out and/or accept data in this format.

The 'native' output format for MS Office Excel however is XLSX (or XLS for older versions) and LibreOffice defaults to ODS but these can be changed if required using the Save as... option.

MS Excel Online will automatically be stored on your One Drive but can be saved on your computer as an XLSX file using the Download a Copy... option from the More menu (indicated by a 3 dots graphic at top right).

Similarly, Google Sheets will automatically be stored on your Google Drive but can be saved on your computer in any of the formats mentioned using the Download as... option from the File menu

Opening or importing worksheets:

Both MS Office and LibreOffice will accept CSV, XLS, XLSX and ODS simply by dragging and dropping the file on to an empty worksheet (although Excel hiccups a little when offered ODS in this way!).

To use an existing spreadsheet within MS Excel Online, it must first be uploaded on to your One Drive using the Upload option. All file formats mentioned are accepted.

Similarly, spreadsheets are first Imported on to your Google Drive from where they can be accessed by Google Sheets for editing.

Viewing file format extensions:

The file extension showing the file format (e.g. CSV or XLSX) is often hidden from view on Windows computers but can be revealed by opening a folder (eg My Documents), and ensuring the box against File name extensions in the View menu is ticked.

Alternatively find 'Folder options'. (e.g. by simply searching for Folder Options). Choose the View tab from the top and look down the list to find the box marked 'Hide extensions for known file types'. Ensure this box is not ticked.

 

Mail Merge Lists

Contact details of friends and family for example, can be entered into a spreadsheet or database application to create lists which can be stored, edited, sorted and used to produce outputs such as address labels.

Common 'Office Suites' of software include both a spreadsheet application and a wordprocessor which, when used in combination, can accomplish the task.