Ebay plug-in for Excel

http://pages.ebay.com/Excel_Plugin/

manage up to 5,00 entries right there in Excel to your Ebay account !!

Social scenes in 2010

http://office.microsoft.com/en-gb/outlook/social-connector-for-microsoft-outlook-HA101794273.aspx

Merge and Mail in 2010

Merge them, mail them
http://office.microsoft.com/en-gb/word-help/use-mail-merge-to-create-and-print-letters-and-other-documents-HA101857701.aspx

Mail merge in Word and Outlook 2010 is the easy way to create standard documents for a large group of contacts. If you're sending a new year release or a marketing mailout it's simple to prepare personalised material for your clients or a subset of them if you prefer. It's not just letters - emails, envelopes or mailing labels are just as quick to do. Find out how.

Conversations in Outlook 2010

How to converse in Outlook 2010

http://office.microsoft.com/en-gb/outlook-help/video-introduction-to-conversations-VA101822182.aspx

Conversations are a way of grouping your emails so you can easily follow what's going on in a particular topic - even if you've filed individual emails in separate folders. And if you don't need to keep following something, you can even clean it up and Outlook automatically puts the emails in your delete folder.

Wow, over 2 thousand page views !!

"thats great news, over 2 thousand page views, many thanks people.
I will promise to keep adding new things going into 2011 as I have been neglecting the site on favour of twitter as its quick on the move to keep up to date but blogs are brilliant to educate and train/inform people and help you out with your apps issues."

Jamie J
xxx

Happy New Year for 2011

Happy New Year fellow bloggers and tweeters as this year draws to an end I wish you all health wealth and good fortune and fun for the coming year 2011.
I have had many challenges over 2010 and many memorable moments during my travels.
January was quietish but Feb I popped over to Amsterdam to deliver Excel training to a corporation I have worked with before, this was a good laugh as I had a mixed bunch of Dutch, English, Italian and Belgians on the courses.
My work has taken me far and wide across the UK, only recently down to Stonehenge for a few days work teaching Windows basics and Excel stock order systems.
Many a trek to Milton Keynes now completed I am actually starting to remember the islands !!
Manchester is imprinted on my brain aswell now.
Birmingham sees my company more than most and we are moving offices with one client I work with to new facilities which will be good.

So good luck all and enjoy your PC experiences in 2011.

All things Word and Wonderful, all blogs great and small !

http://www.shaunakelly.com/word

enjoy
J

mass emailer for Excel

http://www.rondebruin.nl/sendmail.htm


this is VERY useful as it allows you to email to multiple people with attachments and TO, CC settings from a database list in Excel 97 - 2010.
install the add-in and away you go, it really works !!!
 
I had this a few years ago and its just as good now
 
J
 

test via Outlook 2010 to Blogger

Fingers crossed this works !!!

 

Jamie Johnson

 

Office 2003 to Office 2010 guides

http://bit.ly/cAxXMe

Use the link above to get your hands on some Official Microsoft QRG's for your shiny new Office 2010 software.

JJ

Spotify for instant access to millions of tracks

Playing with http://www.spotify.com/ allows you to search and listen to tons of tracks via its friendly interface.
Imagine you have your iTunes Library but suddenly there are millions of tracks to choose from, thne you have Spotify.

OK after your trial period runs out of about 20hrs then its £6 or so per month but that wouldnt even buy you 1 CD at todays prices.
I searched for a lot of stuff and it nearly always came up with the goods, The Hurts, Vampire Weekend, Elvis, Beatles, Ultravox, Sisters of Mercy, whatever !!!

You can tag them as favourites and create groups of tracks to play whenevr you like.

ENJOY !

iTunes Remote Control using your iPhone

Wow, this is fun.
I can control my iTunes application on my PC and listen to my favourite tracks, search, change the volume, pause, listen to Albums, Podcats, Playlists all via my Apple iPhone.

Download the FREE app from the App Store called "Remote" and then connect to your Library remotely.

Within seconds you will be able to crank up your speakers and listen to any of your iTunes Library via the phone.
I can see this developing so with blue tooth speakers downstairs I can easily listen to my favourite music via the iPhone, Awesome !!!

JJ

New improved Blogger.com

New improved Blogger.com website makes it easier to Preview prior to posting your Blog Posts, so check it out on
http://www.blogger.com/ and click that preview button.
You can post from email aswell or a mobile phone or even from Word or Wordpress.

JJ

It's been a while ......

Hi there folks !
It's been quite a while but I have been busy with my Contract work, since setting up my own IT Training Company: www.jjsurf.co.uk I havnt had much time to update my blog aswell as my constant twittering on www.twitter.com/jjsurf but today I will be posting some things on Office 2010 and other interesting tech.

Many thanks

Jamie

Office 2010 is here ....

Yes its here and a lot of people are liking it so far.
www.microsoft.com/office2010 Download a trial here.

BACKUP
Note:
Make sure you backup your user files on a regular basis, I had a crisis call from the family after pictures were deleted by mistake in Picasa, luckily the recycle bin came to the rescue as they had been deleted also from the Camera card.

JJ

Lynda.com

Hi there, its been a while as I have been very busy on Train the Trainer assignments.

Anyway if you are short of time for training why not have a look at Lynda.com for all your web based video training needs.

some of the content is free to begin with so you can see if you like the style.

enjoy,

Jamie

Skyping !

Just set up Skype and tested it out with a landline call, great quality through my speakers and the end user agreed the call was very clear.

I will be testing the video once my contacts accept my Skype requests.

www.skype.com for the FREE download, Skype to Skype is FREE over your BBand, Skype to LandLine is about 12p per minute in the UK.

Cheers
Jamie

Getting the month end date in Excel

You need the month end dates for a range of dates on invoices, no problem in Excel

The calculation uses DATE to format the cell with Y M D and we add a month then take 1 day off it to get month end :

Happy with your IT Manuals ?

Need some Training Manuals pronto ?

then use www.happymanuals.co.uk for all your training manual needs.

Register then download, then pay a small fee.

JJ

Free WINZIP

Want a Free copy of Winzip ???

http://www.trialpay.com/checkout/?c=aeee19dbebf71b8adc4a35f072102b43&tid=RHy3zTu

then use the link above, subscribe to the offer and get Winzip in free with the deal , saves you £22

JJ

More followers needed

Follow me !!!

as we march towards Office 2010 and Windows 7 !!!

see you there

http://www.nationaltrust.org.uk/main/w-bonus-day.pdf

Fancy a FREE weekend pass to some National Trust properties ?


http://www.nationaltrust.org.uk/main/w-bonus-day.pdf

use this link and print out the voucher PS ONLY for weekend of 20/21 March 2010 and NOT all National Trust properties

enjoy !

Desktop Wallpaper needs a Spring Clean ?

http://www.smashingmagazine.com/2010/02/28/desktop-wallpaper-calendar-march-2010/

Look no further as here is a link to a massive amount of March Desktop backgrounds and they even come with a built in calendar if like me you never got round to buying one in December !

great !!

Jamie

http://www.jamessenior.com/

Social Web Guy and Web Evangelist has a new platform, check it out.
http://www.jamessenior.com

All things web and ASP with lots of useful stuff thrown in as well

thanks James

Jamie

http://mthomas.co.uk/the-powerpoint-comma-bug/

The comma bug when linking in PPT,
thanks to Mike Thomas for this one, If you hyperlink to a slide with a comma in its title the hyperlink just doesnt work, so follow the work-around to fix it.

http://mthomas.co.uk/the-powerpoint-comma-bug/

cheers

Jamie

Visual Basic for Access & other things SQL Database related

www.functionx.com

Use the above link for a fantastic array (joke) of programming information, I especially like the VBA stuff in here, many hours of really useful help and worked examples of code you can copy and paste and test/run in your own systems to see exactly how it works.

well done !

Jamie

Want a better set of IT Training Manuals ?

Then try www.watsoniapublishing.co.uk

I have just got their MS Project 2007 manuals Level 1 and 2 and they are very, very detailed, excellent reference and training sources. The files are downloadable from their site and you can order individual manuals or as many as you need for a class in colour or b/w.

JJ

http://www.speakingaboutpresenting.com/

http://www.speakingaboutpresenting.com/ this link takes you to a nice blog with lots of help and links to useful Presentation books.
e.g.
Slideology

The Backchannel: How Audiences are Using Twitter and Social Media and Changing Presentations Forever

Made to Stick

Presentation Zen

JJ

Windows 7 - selling well and people are happy !!!

Windows 7 - 13 Days to launch !!!

Get ready for Windows 7
The countdown is on! With Windows 7 releasing October 22, here's everything you need to be prepared.
Get started

Want hundreds of FREE Office 2007 PPT's

http://office.microsoft.com/en-us/training/HA101926501033.aspx
yes thats right FREEEEEE templated PPT Presentations on all aspects and every package in the MS Office 07 suite for u 2 use !

Jamie

(well maybe not hundreds ..)

Useful link for Office 2007 Manuals

http://eu.wiley.com/WileyCDA/Section/id-302479.html?query=microsoft%20office%202007

Moving to 2010 !!

Link to main Office 2010 website from Microsoft

http://www.microsoft.com/office/2010/

Direct link to Office 2010 "First look-see" from Microsoft(C)

http://www.microsoft.com/officebusiness/office2010/

Office 2010 videos

You have got to be joking, I am sure many clients of mine are still thinking of going to 2007 or not just yet and here is 2010 !!!

Well have a look maybe its a case of skiping 07 and going straight to 2010 and the same with Vista, go straight to Win 7 ????

cheers again for the link on Chris's site

http://blogs.technet.com/chrisp/archive/2009/07/21/introducing-microsoft-office-2010.aspx

Mail Merge - Compare Word 2007 v Open Office

Lets do a comparison MS Word 07 v a rival in the form of Open Office

Thanks to Chris P for this gem, check out his blog aswell.


http://blogs.technet.com/chrisp/archive/2007/05/08/microsoft-office-word-2007-and-openoffice-org-2-2-0-mail-merge-comparison.aspx

YOU only pay for what you get, dont skimp if its your business !!

Link to an Office Blog

Have a look at the link below:

http://www.mymsoffice.net/

contains links to videos on Office 07

Thanks
J

The Office Values - Microsoft UK Training with David Brent 4

final part

http://www.youtube.com/watch?v=IXdKMoFqHWA

J

The Office Values - Microsoft UK Training with David Brent 3

next part :

http://www.youtube.com/watch?v=pEOz7nxky6Y

J

The Office Values - Microsoft UK Training with David Brent 2

Part 2 of the David Brent videos !! ha haaa

http://www.youtube.com/watch?v=XKXz2qDTiBU

Jamie

The Office Values - Microsoft UK Training with David Brent

here is a bit of fun from Mr David Brent and the gang on Microsoft.
LOL

http://www.youtube.com/watch?v=oKyV-l8i5lg

Jamie

Listen and watch Jensen Harris from Microsoft who is discussing the reasoning and development processes behind the new (ish) Office 2007 Interface design and how it came about
NOTE : its split into ten minute sections so you will need to get the next one from you tube

Here is the link to part 2 where it gets more interesting :

http://www.youtube.com/watch?v=IYg647Jx7Y8

very useful !!!

part 3 :
http://www.youtube.com/watch?v=7i3E-ZfMVNQ
Jamie

WOLC the WOLC, TALK the TALK

Dont forget the World Of Learning Conference is on today and tommorrow at the NEC, Bham and is full of all your favourite IT Training and Development needs.
I shall be there to make new contacts and see what's happening out there in the current world of training.

Many key companies and trainers will need to think of new dynamic approaches to training as the reccession bites and budgets are at rock bottom.

Smart Training is required and cost effective approaches to training your staff.

Courses are being condensed as TIME is a costly asset for Managers, a day out of the office for 2 or 3 delegates is difficult as work demands have doubled and even tripled for our poor IT workers as other staff have been made redundant or have been given other duties to juggle.

Good Luck

JJSurf IT Training Ltd hits the waves !

Hi all,
Don't forget to check out my new website on www.jjsurf.co.uk
I shall be developing this a little bit as time goes by but it contains all my contact details.

If you need IT Applications Training give me a call. I am Midlands based but can travel if required. I cover all MS Office apps plus a few extras. My CV is downloadable via the website.

email : jjsurf@btinternet.com

Thanks again

Jamie Johnson
MCT, TAP, MCAS and MOS Master

Free to Fly !!

Having been freed today of my Corporate Bondage, I am now free to fly as a Freelance IT Trainer and Contractor.

So onwards and upwards !!!

Many thanks to all my colleagues old and new and keep watching this space for news and help on everything Microsoft Office related.

Plus I will be expanding a little into Technology, everyone loves a bit of Gadge !! now and again !!

Jamie

Geek T-shirts

Hi all,
While I am waiting here for Visio 2007 to install I am perusing the web and came across a link to cafepress, here you can find all manner of geeky, nerdy T shirts so I have put a link for you below ... go on you know you want to click it ...

http://t-shirts.cafepress.com/geek_mens-clothing?fp=25198913

J.

PowerPoint Heaven ..in the Spring

Hi all , Spring has springed and daffodils are everywhere again !

Why not revamp and spring clean your dusty PowerPoint slides with a few squirts of elbow grease and a little help from the following sites :

http://www.pptheaven.mvps.org/

http://www.fotosearch.com/

http://www.istockvideo.com/

http://www.freestockfootage.com/

Happy Spring Cleaning !!!

J.

Blog changes

New Year - New Template !!

I thought I would just refresh the Blog site and change templates to a more wintery, icy feel especially in these times of snow and ice we are all having.

KEEP WARM !!

Jamie

BT Vault for useful files - EXCEL

Hi everyone, many thanks for your comments on the Blog DBUI who ever you are !!

I have now sorted out some web space to post files for you all, so use the link below to gain access to EXCEL TOOLS, to begin with. it contains Duplicate Master and Excel Dictionary.


http://digitalvault.bt.com/invite/login?c=383730393732&i=17852a-11ef224ac95-gemini05&t=d966a1c919f343f8&r=mg&lang=en

More to follow,

enjoy

Jamie

Happy New Year 2009 to all Bloggers ...

Jamie

Microsoft Video Website

http://preview.microsoft.com/video/


A new site , here you can watch videos about new MS Products inc Office and Vista.
Check it out on the above link.

JJ

Microsoft Office Labs

Fancy doing some undercover Microsoft Research into new products and up and coming ideas/software betas ???
then have a look at this link below ...

http://www.officelabs.com/Pages/About.aspx

go to the home page once you have looked at the about page.


... dont tell anyone else !

Jamie

PowerPoint Delivery Shortcuts ....

When the pressure is on and you need to deliver the goods during your Presentation don't forget the following shortcut blags :

F5 to run the Presentation, shift F5 to run from current slide in PPT 02 and 03/07

1. Use B or W to Blackout oe Whiteout the screen during talk time or using a whiteboard.
2. Use Spacebar to progress the slides and backspace if someone asks a question and you need to go back to a previous slide.
3. ESC quits the presentation
4. You can use N for next and P for Previous slide
5. dont forget Annotations, right click and choose a pen colour to then write notes on ths slides during delivery and save them at the end of your presentation for further use later !

Good luck and relax/smile and crack a few jokes ....

JJ

Blog from your Email to your Blogsite DIRECT !

Yes,

Hi Folks

I have now discovered you can email from anywhere you have web access straight into your blog site, either as a draft or straight to live !! via a configurable email address on blogspot.

Very useful !!

This message was emailed via Outlook 2007 to the Blog site !

Jamie

Office 2007 Certification Program [MCAS/MCAP]

Hi all,
If you are now happily playing with Office 2007 then isnt it time you got some qualifications on it ?
try out this MS Link below to take you to the new certification for Office 07 and Vista via Certiport, we at QA-IQ use them to test and take exams with for our delegates and our own staff !

http://www.certiport.com/Portal/desktopdefault.aspx?page=common/pagelibrary/mbc_mcas.html

Jamie

You turn your back and ...

IE8 is on the doormat ...

Well not quite on general release yet but it's coming soon , watch out !!
http://blogs.msdn.com/ie/

JJ

IE for the Web !

Internet Explorer has it's own blogsite, oohh get you !


http://blogs.msdn.com/ie/

Vista Blog for the masses !!!

Link below for Vista News

http://windowsvistablog.com/blogs/windowsvista/

Any Office Zealots out there ??

This site has some up to the minute office news and interesting articles.
Plus its now moved onto a SharePoint platform !

http://www.officezealot.com/Pages/index.aspx


enjoy !!!

JJ

News for Developers and Microsoft people from Redmond, USA

http://reddevnews.com/default.aspx

Visio and Infopath Blogs

http://blogs.msdn.com/visio
http://blogs.msdn.com/infopath

I still keep finding 'em !! :)

JJ

Groovy Project

http://blogs.msdn.com/groove
http://blogs.msdn.com/project

more links to useful blogs, telling us all about the funky stuff in 2007 products !!!

JJ

More Blogs from those nice MSDN people

http://blogs.msdn.com/access/
http://blogs.msdn.com/outlook
http://blogs.msdn.com/powerpoint

MSDN Excel Bloggers

MSDN provide a wealth of MS Office related Blogs, so try one for Excel for a start :

http://blogs.msdn.com/excel/


JJ

Office 2007 Bible

http://pschmid.net/blog/2006/10/09/58

Use this link above to peruse the why's and wherefore's of Office 2007, from it's innception to it's features and menu's.

Many thanks to it's contributor's and collaborator's. [it is their views, so take that into account !]
This was from 2006

Jamie

Microsoft keyboard shortcuts
The following table contains keyboard shortcuts for use with Microsoft keyboards.
Press this key To do this
Windows logo key Open or close the Start menu
Windows logo key +BREAK Display the System Properties dialog box
Windows logo key +D Display the desktop
Windows logo key +M Minimize all windows
Windows logo key +SHIFT+M Restore minimized windows to the desktop
Windows logo key +E Open Computer
Windows logo key +F Search for a file or folder
CTRL+Windows logo key +F Search for computers (if you are on a network)
Windows logo key +L Lock your computer (if you are connected to a network domain), or switch users (if you're not connected to a network domain)
Windows logo key +R Open the Run dialog box
Windows logo key +T Cycle through programs on the taskbar
Windows logo key +TAB Cycle through programs on the taskbar by using Windows Flip 3-D
CTRL+Windows logo key +TAB Use the arrow keys to cycle through programs on the taskbar by using Windows Flip 3-D
Windows logo key +SPACEBAR Bring all gadgets to the front and select Windows Sidebar
Windows logo key +G Cycle through Sidebar gadgets
Windows logo key +U Open Ease of Access Center
Windows logo key +X Open Windows Mobility Center

UAC is a pain in the AC

There you are with your brand spanking new Vista laptop and everything is fine but every time you want to do something a little more “adventurous” the screen dims and you have to click Continue to the security prompt just to run a utility. Its YOUR LAPTOP why keep asking for raised privileges all the time just to run stuff in the Control Panel !

Well with help from the Dummies Guide to Vista ! I managed to switch off this annoying facility, its probably great for users on a network where the stressed out admin guys are sick of users trying to install games and screen savers etc but if its your own machine why have all the extra security ?

Its called UAC, “User Account Control” and it can be disabled for all users via:

Control Panel – Administrative Tools – System Configuration -Tools – Disable UAC
(Requires a reboot unfortunately!)

The Missing Manuals

Hi all,
I have discovered after a lengthly flick through most of the Office books at "Borders" that the missing manuals books are very good. I have purchased Access 2007 and Project 2007 to start with and these say on the front :
"The book that should have been in the box". This is true, it's got a wealth of useful extras, background help, interesting utilities that I have not come across in other manuals. they are written in a nice relaxed style, brave enough to even say when a facility is rubbish or never took off.

Check them out ...


The Access 2007 book covers macros, VB, SQL ,all the basic Objects and Database theory as well.
Jamie

TOP TIPS for Office

http://www.microsoft.com/uk/atwork/tips/default.mspx

Use this link above to gain access into a wealth of top tips and shortcuts/useful things to know in Office via our friends at Microsoft !

Jamie

Want a copy of Office Ultimate 2007 ??

SAVE £500 on Office 2007 !!!!!!!!

http://www.theultimatesteal.co.uk/

As long as you are a registered student you can get a FULL version of Office 07 for £38.95 as opposed to £549 !

Do you know your RSS from your elbow?

see the link below for all info re RSS and Blog elbows !

http://www.microsoft.com/uk/atwork/rss.mspx

thanks,
Jamie

Fed up with the backs of envelopes? Try OneNote instead

"OneNote is a really easy way to take notes, manage and share them. You can input your own notes, grab pages from the Internet, import and annotate documents from other Office programs and organise the information to suit the way you work. You can even include audio and video notes.
Everything is stored in searchable electronic notebooks. Set up sections within a notebook, or multiple notebooks for different projects. Using hyperlinks between sections or notebooks means you can quickly access and deal with complex information. And it's all on one screen.
Take a trial Why not try OneNote for yourself? Download the trial today, and get ready to be even more productive!
Watch the demo If you'd like to find out more about OneNote's features, check out the demo. You may never buy another notebook again." - Taken from the "At Work" MS Office newsletter Jan 08

Duplicates Addin for Excel

The previous Link is for EXCEL
and it works a treat on column data when you are checking for duplicate data between the columns or rows or a highlighted area of your sheet !

Please think about donating to the creators !

JJ

The Duplicate Master

Happy New Year folks !!!

Having trouble finding duplicates and highlighting them or maybe you want to remove or delete them via a utility.
Then try this Add-in below, you will need to be able to install addins to your PC for this to work.

http://members.iinet.net.au/~brettdj/


Cheers

Jamie

Creating GRaphical Indicators in MS Project

Hi again
Have a look at my latest posting , below I ahve placed a link to TechTrax website that explains the different types of graphical indicators within Project and how to set them up.
You can have "Traffic Light Indicators" for tasks overbudget or slipping dates, etc and Drop down menus (combo boxes) to allow the end user to only choose from the given list, e.g. Task Name , Dept ( Custom Field) etc.


http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=403

Thanks

Jamie
PS have a Merry Xmas and New Year to all the bloggers out there !

Blogging via Word 2007 Blog Editor !!!

Yes I created this using the Blog option now within Word 2007 and then setup my Blogger account within Word to Publish directly to my Blog site.

Give it a try as you then get much better editing and formatting options supported by Microsoft Word 2007.

Thanks
Jamie

MS ACCESS - Input mask syntax and examples

Many people struggle with input mask special characters so here is the help file from MS Access:

Valid input mask characters

Microsoft Access interprets characters in the InputMask property definition as shown in the following table. To define a literal character, enter any character other than those shown in the table, including spaces and symbols. To define one of the following characters as a literal character, precede that character with a backslash (\).

Character Description
0 Digit (0 through 9, entry required; plus [+] and minus [-] signs not allowed).
9 Digit or space (entry not required; plus and minus signs not allowed).
# Digit or space (entry not required; blank positions converted to spaces, plus and minus signs allowed).
L Letter (A through Z, entry required).
? Letter (A through Z, entry optional).
A Letter or digit (entry required).
a Letter or digit (entry optional).
& Any character or a space (entry required).
C Any character or a space (entry optional).
. , : ; - / Decimal placeholder and thousands, date, and time separators.
(The actual character used depends on the regional settings
< Causes all characters that follow to be converted to lowercase.
> Causes all characters that follow to be converted to uppercase.
! Causes the input mask (input mask: A format that consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered as well as what kind of data and how many characters are allowed.) to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.
\ Causes the character that follows to be displayed as a literal character. Used to display any of the characters listed in this table as literal characters (for example, \A is displayed as just A).

Password
Setting the InputMask property to the word Password creates a password entry text box. Any character typed in the text box is stored as the character but is displayed as an asterisk (*).
Input mask examples
The following table shows some useful input mask (input mask: A format that consists of literal display characters (such as parentheses, periods, and hyphens) and mask characters that specify where data is to be entered as well as what kind of data and how many characters are allowed.) definitions and examples of values you can enter into them.
Input mask definition

Examples of values
(000) 000-0000
(206) 555-0248

(999) 999-9999!
(206) 555-0248
( ) 555-0248

(000) AAA-AAAA
(206) 555-TELE

#999
-20
2000

>L????L?000L0
GREENGR339M3
MAY R 452B7

>L0L 0L0
T2F 8M4

00000-9999
98115-
98115-3007

>LMaria
Pierre

ISBN 0-&&&&&&&&&-0
ISBN 1-55615-507-7
ISBN 0-13-964262-5

>LL00000-0000
DB51392-0493

Getting data into your Oulook Calendar from EXCEL !!!

I now use this to import my weekly/monthly calendar data across into my Outlook Calendar at home to keep me up to date with my latest whereababouts, thanks to Allister for the loan of this information .....

Wednesday, May 11, 2005 3:35 PM by Allister_Frost


Another handy way to add appointments to your calendar is by importing from Excel. To do this you first need to create an Excel file containing the appointment information Outlook needs. Your first row should contain columns titles which match Outlook's appointment fields. You don't need many fields to get started, just try the following for a basic import of all day appointments:

Cell A1: Subject
Cell B1: Start Date

Now add the data you'd like to import into your Outlook calendar under each of these column headings, for example: cell A2 could be "Bob's Birthday" and cell B2 could be "11/05/2005"
Now, here's the important bit. Highlight the entire range of cells that you've used (in my example this would be A1:B2) and give this range a name under Insert, Name, Define (or just type into the Name Box just above the top of column A). Outlook needs this range name so it knows where to find the data to import. Save your Excel file and close it.

Now just pop into Outlook and choose File, Import and Export. Then select Import from another program or file, hit Next, then choose Microsoft Excel and hit Next again. Now locate the Excel file you created earlier, hit Next, select your Calendar, press Next again and check that Outlook finds the correct Range Name in your Excel file. Now press Map Custom Fields to verify how Outlook is mapping your Excel column headers to its own Calendar Appointment fields, changing if necessary, then hit OK, then Finish.

If you've done everything right, your Outlook Calendar will now contain the appointments you created in Excel.

There are 22 fields you can import into Outlook in this way. These are: Subject, Start Date, Start Time, End Date, End Time, All day event, Reminder on/off, Reminder Date, Reminder Time, Meeting Organizer, Required Attendees, Optional Attendees, Meeting Resources, Billing Information, Categories, Description, Location, Mileage, Priority, Private, Sensitivity, Show time as.

Top tip: try importing in this way to your Task folder rather than your Calendar. This is a great way to move a list of 'to do' items from Excel or Project directly into your Outlook calendar.

SQL Query Criteria

Hi all,
See this link below for the Microsoft guide to Query criteria and SQL commands :

http://office.microsoft.com/en-gb/access/HP051885161033.aspx?pid=CH063608261033

Thanks

Jamie

next simple code sample !

'Code to set the current active cell value to something

Sub SetValue()
Worksheets("Sheet1").Activate
ActiveCell.Value = 35
End Sub

More Office Manuals ...

Dont forget to check out www.interquadbooks.co.uk for a now updated library of Computer Reference Books !


Jamie

Get your Code into Action ...

I almost forgot ....

Copy and Paste the code into the VB Editor window maybe on the first sheet or the This Workbook page, Save it !!! and then test it out by running the Code from the Run icon.


PS you could create an icon on the Toolbar to run the Macro later if you are feeling brave !!

Jamie

VBA for EXCEL Code Snippets

Hi all ,
I will be adding a little bit of code here and there to the BLOG in the form of Excel Code as I find out a little more on the subject as I go along the path to becoming a VB person !! [anorak not included]

Heres some code that uses the InputBox Function to then add a number of required additional worksheets to your Spreadsheet.

' Code to create additional Worksheets
Sub AddXWorksheets()
Dim myNum As String

myNum = Application.InputBox("Enter the number of additional WorkSheets required")
Worksheets.Add After:=Worksheets(Worksheets.Count), Count:=myNum
End Sub

Thankyou !

Need some sample data to play around with Excel 2007 ?

Then try Mr Excel ...

http://www.mrexcel.com/miraclesfiles.html

These files are from the Book : Excel 2007 Miracles Made Easy by Bill Jelen.

Download a Sudoku Solver here !

"Yes you can solve Sudoku in seconds with MS Excel !"

thanks to Mikes spreadsheet of VB magic !

download from :
http://www.mikeoldroyd.com/

PowerPoint Links

Need some professional backgrounds and templates, then check out these links below :
obviously a lot of these sites you will have to pay for the goods !!

http://www.ppted.com/

http://www.powerfinish.com/

Also check out Microsoft Office Online site for some free templates !

http://office.microsoft.com/en-gb/templates/results.aspx?qu=powerpoint&av=TPL000

And also check out :

http://www.presentationhelper.co.uk/free_powerpoint_template.htm

free templates !

Note in PowerPoint 2007 you can have access to a wide range of pre set templates and colour combinations, it makes a lot of the older templates look "out-dated" by comparison.

Thanks

Jamie

Microsoft At Work Website

Useful tips and tricks for Office lovers everywhere !

http://www.microsoft.com/uk/atwork/default.mspx

First look at Office 2007

Try this website for a first look at the advances with MS Office 2007 !
Its a huge new version with lots of great time saving and impressive features across all the applications :
http://www.microsoft.com/uk/office/newday/default.mspx?nav=v1xcsubmenuxi0&WT.mc_id=Online

Good luck

Office Books anyone ?

Web page detailing MS Office books available !

http://www.mousetrax.com/books.html#office

Monthly Training Journal

Hi try MouseTRax for training resources, I found some good help here on all MS Office related apps. You can subscribe for free to get a monthly magazine !

http://www.mousetrax.com/TechPage.html

Cheers
Have a nice Summer break for those of you going on holiday in 2007 !! :)

Jamie

Red RAG to a bull [ Red Amber Green Graphic Indicators]

Hi all
Just done a Project 2003 course and we discovered you can set up graphical indicators for your Project Tasks or overall Project status such as a red dot for Warning, Amber and green dot aswell !

I will document the process in a later Blog, but its a New Custom Field then choose Graphical indicators, when the user selects a drop down option such as R, A or G it uses a graphic instead of text.

A more interactive approach lets you copy a Number column such as Cost or Variance and Paste link it over the top of the indicator column so it keeps changing dependant on the numbers linked to it.

more to follow ...

Jamie

Outlook Keyboard Shortcuts

In a hurry with E-Mail , then peruse the shortcuts below :

Function keys

F1 -- Open Help
F3 -- Open Find dialog or Find pane.
F4 -- Expand dropdown menus, use arrow keys to select from list
F5 -- Refresh the current window (Outlook 2003) - Send/Receive in older versions
F6 -- Move to next window element
F7 -- Run spell check F9 -- Send/Receive


Number Keys

Ctrl+1 -- Inbox
Ctrl+2 -- Calendar
Ctrl+3 -- Contacts
Ctrl+4 -- Tasks
Ctrl+5 -- Notes
Ctrl+6 -- Folder list
Ctrl+7 -- Shortcuts
Ctrl+8 -- Journal
Ctrl+Y -- Folder picker dialog

Print a list of shortcut keys from within Word ..

Ever wondered how to get your own list of keyboard shortcuts ???

Read on .....

1. On the Tools menu, point to Macro, and then click Macros.
2. In the Macros in box, click Word commands.
3. In the Macro name box, click ListCommands.
4. Click Run.
5. In the List Commands dialog box, click Current menu and keyboard settings.
6. Click OK.
On the File menu, click Print.

MOS SOS !!

Become MOS qualified and be the best !!

http://www.microsoft.com/learning/mcp/officespecialist/default.mspx

JJSURF

Demystify a few computer terms and get on with your life

Crabby to the rescue to bust some jargon !
http://office.microsoft.com/en-gb/help/HA010429491033.aspx

JJSURF and Crabby Office Lady.

Put Word to work for you!

Five handy tips for use with MS Word courtesy of Microsoft :
http://office.microsoft.com/en-gb/word/HA101154421033.aspx

JJSURF

Pretty Ribbons ....

Here's the Ribbon. Note the expandable Groups such as Clipboard and Font. The Office button at top left gives you access to the File Open, Save, Print commands plus others.

Home , Insert Page Layout etc are positioned across the top of the Ribbon.

Dont worry you will soon get used to it !!!

JJSURF

The Crabby Office Lady is alive and well !!!

Yes folks she's still around dishing out advise, like it or not check out her latest Office ravings below :

http://office.microsoft.com/en-gb/help/FX101679371033.aspx

JJSURF

You can use Shift Control + H to open a Word, Excel or PowerPoint document from within MS Outlook.. give it a try !!

JJSURF

Looking to Office 2007 .... the keyboard !

Keyboard shortcuts in the 2007 Office System Whatever your reason for preferring keyboard shortcuts, take this training course and get the low-down on new and and easier ways to use the keyboard with Microsoft Office 2007.