Send free e-tickets to helpers and sponsors using the spreadsheet template

Whilst it is possible to send tickets to volunteers and/or sponsors individually, it is a time consuming process and not recommended.

Instead we suggest that you fill in a spreadsheet with the essential information and send it to us to be uploaded and processed automatically.

You can download the spreadsheet template here. We suggest you do this because there are various fields which need to be complete if the system is to accept the spreadsheet. Without them it just produces errors.

Once you have the spreadsheet open please fill in the fields taking care to include the name as separate first and second names.

The most important field is the email address, so please take the time to check these have been entered correctly and that there are no extra spaces before or after the email address.

Address fields, including the postcode, can be fake e.g. use the venue address instead. This also applies to the phone number.

The Event ID and Product ID are Future Ticketing references. Please insert the Event ID for your event in that column and fill down the column so the number is the same in each row.

EventEvent ID
Belvoir161
Brocklesby159
Cottesmore160
Fernie186
Fitzwilliam185
Melton Hunt Club187
Pytchley175
Quorn162
Revesby119
South Notts222
Woodland Pytchley184

The Product ID for free tickets is currently 54 so please do the same to fill that column with the number 54.

Country ID and Delivery ID are to be left as they are.

Please ensure the Quantity field is also complete as this affects how many tickets are sent to each email address. Please don’t add extra, unnecessary tickets as these tend to go to the wrong people in the end.

When the spreadsheet is complete please send it to Nico as an attachment and he will go through the process of uploading it to the system.

If you wish to customise the email which goes with the tickets, please send the text you’d like to use with the spreadsheet.

Midlands Pointing Logo