| View previous topic :: View next topic |
| Author |
Message |
TheBigYin
Joined: 23 Mar 2007
Posts: 190
Location: Middlesbrough, Cleveland
|
 Posted: Tue 14 Aug 2007 4:48 pm Post subject: |
 |
|
Exactly what I was thinking of Tich...good lass.
_________________
John H Baker
The old saying that there are LIES, DAMN LIES AND STATISTICS has never held so true in today's United Kingdom! |
|
| Back to top |
|
 |
Tich
Joined: 17 May 2007
Posts: 329
Location: York
|
| Posted: Tue 14 Aug 2007 4:51 pm Post subject: |
|
|
| TheBigYin wrote: | | Exactly what I was thinking of Tich...good lass. |
Who you calling lass - I've got long hair but that's taking it a bit too far 
_________________
Rauchen macht mich zum Verbrecher |
|
| Back to top |
|
|
Pete J
Joined: 25 Feb 2006
Posts: 819
Location: Portsmouth
|
| Posted: Tue 14 Aug 2007 4:52 pm Post subject: |
|
|
Tich.
Absolutely its a great substitute to MS's offering.
BUT it will not use the macros created in office. I have not had open office long enough to have written an appropriate macro for it so if you want to use my excel template's macro button you will not be able to.
I will do this soon, however you can still use the format on the second sheet to send to me for inclusion in the database.
If anyone has any software problems for using the files I have created please PM me I CAN help you out.
Yours
Pete
_________________
Pete J
"DON'T PANIC"
A lie can run around the world while the truth is still putting its boots on. (Terry Pratchet) |
|
| Back to top |
|
|
TheBigYin
Joined: 23 Mar 2007
Posts: 190
Location: Middlesbrough, Cleveland
|
| Posted: Tue 14 Aug 2007 6:22 pm Post subject: |
|
|
What's a macro?
Joke, don't like macro's.
_________________
John H Baker
The old saying that there are LIES, DAMN LIES AND STATISTICS has never held so true in today's United Kingdom! |
|
| Back to top |
|
|
Pete J
Joined: 25 Feb 2006
Posts: 819
Location: Portsmouth
|
| Posted: Tue 14 Aug 2007 6:34 pm Post subject: |
|
|
A macro is a custom writen function attached to the file.
In the case of the Excel sheet, it takes the pasted data from Yell and converts it into the format required for the mail merge and the database.
Yours
Pete
_________________
Pete J
"DON'T PANIC"
A lie can run around the world while the truth is still putting its boots on. (Terry Pratchet) |
|
| Back to top |
|
|
Nico
Joined: 08 Mar 2006
Posts: 3160
Location: Derbyshire
|
| Posted: Tue 14 Aug 2007 8:43 pm Post subject: |
|
|
Hughster, I have about 70 left from DE area but holding on until leafletting resumes.
Pete J once completed I will send you Excel Database, can you pm me your e-mail address I will send as an attachment.
Also I tried downloading your instructions ect, but am getting error message as not available - please advise
Nico
_________________
Loss of freedom seldom happens overnight. Oppression doesn't stand on the doorstep with toothbrush moustache and swastika armband -- it creeps up insidiously... step by step, and all of a sudden the unfortunate citizen realizes that it is gone |
|
| Back to top |
|
|
Pete J
Joined: 25 Feb 2006
Posts: 819
Location: Portsmouth
|
| Posted: Tue 14 Aug 2007 9:03 pm Post subject: |
|
|
Nico.
I don't know why.  It worked when I posted.
Will try and set up an alternative download.
Please bear with me.
Sorry everyone, normal service will be resumed ASAP.
Yours
Pete
_________________
Pete J
"DON'T PANIC"
A lie can run around the world while the truth is still putting its boots on. (Terry Pratchet) |
|
| Back to top |
|
|
Hughster
Joined: 22 Apr 2007
Posts: 513
Location: Peterborough
|
| Posted: Tue 14 Aug 2007 9:11 pm Post subject: |
|
|
| Belinda wrote: | | Always nice to get feedback, had a call from a Cambridgeshire bar today (trying to get Lol) who are dead excited by this leaflet they had in the post and are going to join us along with a couple of their customers, and feel that we have got things very well organised. Keep it up, these leaflets will be a godsend to some of these people out there ... |
I don't know why I didn't pick this one up before (Belinda posted this weeks ago)
Belinda, do you know what the name of this Cambridgeshire bar was and where exactly it was located? I can't be far away so I'd like to pay it a visit... |
|
| Back to top |
|
|
catweazel
Joined: 29 Dec 2006
Posts: 344
Location: Manchester, UK
|
| Posted: Tue 14 Aug 2007 9:53 pm Post subject: |
|
|
| Pete J wrote: | Nico.
I don't know why. It worked when I posted.
Will try and set up an alternative download.
Please bear with me.
Sorry everyone, normal service will be resumed ASAP.
Yours
Pete |
I read the instructions this afto, but now, when I've come to download the files...there there were --GONE--
_________________
Force, violence, pressure or compulsion with a view to conformity, are both uncivilized and undemocratic. -- Mohandas Karamchand Gandhi
http://www.myspace.com/saburac |
|
| Back to top |
|
|
Pete J
Joined: 25 Feb 2006
Posts: 819
Location: Portsmouth
|
| Posted: Tue 14 Aug 2007 10:04 pm Post subject: |
|
|
Dont panik (it says so at the bottom of my post)
I think I shall have it sorted within the next 15 mins.
Please bear with me.
_________________
Pete J
"DON'T PANIC"
A lie can run around the world while the truth is still putting its boots on. (Terry Pratchet) |
|
| Back to top |
|
|
Belinda
Joined: 20 Oct 2005
Posts: 1401
Location: Edinburgh
|
| Posted: Tue 14 Aug 2007 10:14 pm Post subject: |
|
|
That was Blue Ball Inn, Grantschester, Hughster. Do you know it?
_________________
Belinda |
|
| Back to top |
|
|
Pete J
Joined: 25 Feb 2006
Posts: 819
Location: Portsmouth
|
| Posted: Tue 14 Aug 2007 10:35 pm Post subject: |
|
|
OK folks crisis over.
The links are now working again.
And just to be sure you all know ill post them again here.
To download right click on the link and select "save file as" or "Save target as"
The Tutorial.
The Excel File.
The Word File.
Yours
Pete
_________________
Pete J
"DON'T PANIC"
A lie can run around the world while the truth is still putting its boots on. (Terry Pratchet) |
|
| Back to top |
|
|
Hughster
Joined: 22 Apr 2007
Posts: 513
Location: Peterborough
|
| Posted: Tue 14 Aug 2007 10:44 pm Post subject: |
|
|
| Belinda wrote: | | That was Blue Ball Inn, Grantschester, Hughster. Do you know it? |
I do know Grantchester (subject of that famous Rupert Brooke poem), and it's not that far from me really. I'll pop down there this weekend. How keen did they sound? Would they appreciate a poster or two? |
|
| Back to top |
|
|
Belinda
Joined: 20 Oct 2005
Posts: 1401
Location: Edinburgh
|
| Posted: Tue 14 Aug 2007 11:04 pm Post subject: |
|
|
Oh yes ... He was very keen and Lol has also spoken to him.
_________________
Belinda |
|
| Back to top |
|
|
|
