|
We Passed!
It’s that time again. Sage Line 50 2007 and Sage Payroll 2007 has been out since
August and as part of our commitment to Sage as an accredited
Business Partner, we have to take regular exams.
Every year we are tested on our knowledge of the software, user and
technical. If we do not achieve a minimum of 90% within the exam, we
fail and then can potentially loose our Business Partner
accreditation.
Tammy studied hard for the exams and despite some really bizarre
questions, passed both the Accounts and Payroll exams with flying
colours.
Thanks to Tammy, AKM can continue to support and service all your
Sage Line 50 and Payroll needs as an accredited Business Partner.
Improving our service to you
We are again looking to improve our service to you. We have
developed an application which will get installed onto all Gold and
Platinum Assist customers servers which will keep us informed on the
status of your backups. This will enable us to report on whether a
backup was successful or not every day of the week. With that
information we will be able to inform you of any problems within 24
hours and diagnose/fix faults as they are found. We current provide
regular server health checks but this takes our service to the next
level ensuring that your backups are happening and that they contain
all your vital data.
At a later date this system will be extended to provide us with
additional information from your servers including errors logged on
a server, hard disk storage status indications and hardware errors.
In the long run this will enable us to become even more pro-active
in detecting and preventing future issues.
If you are a Gold or Platinum customer then we will be contacting
you shortly to ask permission for the use of this software on your
server.
If you have any questions or suggestions about this please email me
at chris@akm-it.co.uk or ring me on 0870 0429076.
Sage tip – Printing
If you find that when you are printing onto Sage stationery, for
example P14/60’s or invoices, that the printing does not line up.
This can often be corrected by using a print adjustment within the
preview. To adjust the document printing, follow the simple steps
below:
For Sage Line 50 Accounts V12.xx and below or Sage Payroll 2007 and below:
1 Run the report or layout to preview then print the report or
layout and measure how far the text needs to be moved.
2 From the preview, click on Page Setup, then to adjust the print,
amend the Print Adjustment as follows:
To move the print up
Decrease the Vertical setting by the amount required.
To move the print down
Increase the Vertical setting by the amount required.
To move the print left
Decrease the Horizontal setting by the amount required.
To move the print right
Increase the Horizontal setting by the amount required.
3 To confirm the change click on OK, then print the report again and
if necessary repeat the steps above until the printing is lined up.
Notes:
By default the measurement is set to inches. To check which
measurement you require, from preview, click Page Setup, then select
the Size tab and check the Paper Width and Paper Height to see if it
is set to inches or centimetres. To return to the preview click OK.
In Sage Line 50 2007, run the report to preview then use Printer Offsets
to adjust the printing.
Ely Chamber of Commerce
As many of you are aware, Tammy joined the Ely Chamber committee
back in April last year. It was the first time that Ely had had a
chamber presence and whilst the last 12 months have been hard work
for all committee members to establish the chamber within the
business community, the committee has been making a difference.
Elections took place last month for the Ely Chamber and as a result
Tammy was elected as joint Vice-Chair of the committee.
So it would appear that running AKM with Chris, giving birth to her
second child only last week and continuing to work full time is not
enough! Some people are just glutton for punishment…..
Ely Chamber Exhibition
On Wednesday 16 May, the Ely Chamber of Commerce held its first
business-to-business exhibition.
The event was at the Soham Lodge Hotel and was attended by a number
of local businesses all keen to see how they could improve upon
their business operations.
AKM was there supporting the Chamber. Despite being the first time
that the Chamber had organised such an event for Ely and the
surrounding villages, all agreed that it had been a success and were
keen to make it a regular annual event.
The Techie Bit.
Ever wondered how to do a mail merge on one of your letters to make
life easier, using Excel?
Well here’s how!
First you need to have an Excel Spreadsheet with your contacts name
in one column, first line of address in the second column, third
line of address in the third column and so on. You must have the
same type of contact in the same column as everyone else, if you
want it to look right.
Once that is done, have a cuppa! That was the hardest part and takes
the longest.
Then,
• Open up the letter in Word that you want to send out to everyone.
• Go to the toolbar at the top of the screen and click on Tools,
then Letters and Mailings, then Mail Merge.
• A column will appear on the right side of your screen where you
will start the mail merge.
• You need to click the letters button at the top of this column
(select document type).then click next on the bottom of the column.
• Next you need to click “use the current document” button, then
next.
• Then you will need to click “use an existing list” button and then
the blue “browse” button below it, which will bring up another box
in the middle of your screen.
• Next go to the folder where you saved the spreadsheet and click on
the spreadsheet file, then on the table and then click ok.
• This will bring up a mail merge recipients box where you can check
all the details and if there are people you don’t want to send to
you can tick the left hand box to remove them . Then click ok
followed by next at the bottom of the right hand column again.
• Have another cuppa – nearly there
• Ensure that the curser (flashing line) is in the place on the
letter where you want the address to be.
• Click “address block” in the mail merge column. This will bring up
an address block where you will enter the mailing details. Un-tick
recipients name and then click “match fields” at the bottom of the
block.
• Another box will open with drop down boxes inside (a box with a
downward pointing arrow). You need to click on the arrows on the
Company, Address1, City and Post code (possibly Address 2 and 3) and
match them up with the name inside the box. It could be Post code
for Post code or an F3, depending on what your spreadsheet said.
Then click ok until all the boxes have gone. Where the curser was in
your letter should now be something like this - <<AddressBlock>>.
This is now where all the addresses will be made.
• Don’t worry if you can’t remember what they were as you can back
track 1 stage and look again. The name will be along the top of the
columns in the spreadsheet.
• You have just about finished, if you click next in the mail merge
column on the right, you can preview your letters and see if
everything matches up.
• Next you complete the merge and print them off or edit individual
letters.
Well Done! You’ve just completed your first excel mail merge, wasn’t
that scary was it?
This month’s Offers
From 1st May 2007 support and development for Sage Line 50 v8 and v9
and Sage Instant Accounts v8 customers will be withdrawn.
If you have Sage Line 50 v8 with Sage Cover or Sage Line 50 v9 (with
or without Sage Cover) and want to upgrade the package, then you can
receive:
10% off Sage Cover Extra or 20% off the upgrade to Sage Line 50 2007.
If you have Sage Instant Accounts v8 with Sage Cover then you can
receive:
20% off the upgrade to Sage Instant Accounts v12
The upgrade offers are effective immediately until 30 June 2007.
Help Please !!!
One of our customers is desperately looking for new premises in the
Ely, Witchford or Queen Aldelaide area.
He is looking for 1/4 - 1/3 acre of land that he can build on or a
building of 3000 sq ft that can be developed for his business needs.
Do you know of anywhere that could be suitable?
If you do please contact Dave Dummett on 07771 537570 – I’m sure he
would be pleased to hear from you!
|
