Tip o’ the Week #109 – SkyDrive on the move

clip_image001Everyone should know about SkyDrive – the free Microsoft service that gives users with a Live ID (including MSN, Hotmail etc) a 25Gb storage space online, accessible ostensibly from anywhere?

Well, it’s just been made more convenient to access SkyDrive files from mobile devices, thanks to SkyDrive Mobile. In the case of Windows Phone and iPhone (and iPod Touch, and iPad too), there are apps specifically built to make the interface to SkyDrive more smooth – otherwise, it’s still possible to get there via a browser from other devices, albeit maybe a little more clunky.

We’re increasingly stepping up efforts to support non-Microsoft devices in accessing our services – as well as SkyDrive and Tag, there is a growing number of Microsoft apps for iOS and Android.
An example is the newly-released MSN App for the iPad – link via iTunes here.

One of the more useful tricks with SkyDrive is to use OneNote for home-based note taking (making sure you don’t fall foul of MS security policy and use it for work related, potentially confidential stuff) – with a OneNote stored in SkyDrive, it’s accessible from your phone, from multiple clip_image002PCs using OneNote just as  normal, and from any browser you care to point in the right direction. It’s a huge boon for taking notes like holiday booking reference numbers, insurance claim notes, shopping lists etc. We’ve covered this a while before in ToW #52 here, and there’s also an article in the online help.

We’ve also looked in the past at an unsanctioned but still potentially useful 3rd party PC app called SDExplorer, which lets you access SkyDrive folders directly from within Windows Explorer, and therefore within any application. There’s a free version that’s limited in some functions, and a trialware pay-$20-for variant that’s a bit more capable. Have a look but do remember that it’s subject to break any time the SkyDrive team make major changes – the SDExplorer authors seem to have done a reasonable job keeping up, but as they say, YMMV.

Tip o’ the Week #102 – When did someone really put something in their calendar?

I’ve been thinking about writing this tip since the ToW started almost exactly two years ago (yay!) but for various reasons, competitive advantage amongst them, I’ve held off. I figure it’s now time to relent and share.

genesis

The tip concerns the differences in Outlook between appointments, meetings, and meetings where you are the organiser. Huh? Well, an appointment is something you put in your own calendar. A meeting is created from an appointment when you invite someone else – or are invited by the organiser – to take part. Outlook exposes a whole load of variance in what you can do when you’re in each of these 3 scenarios, but in 2 of them – namely, appointment and being the meeting organiser, it doesn’t tell you when the appointment/meeting was created.

When you look an invitation sent by someone else, you can see not only when you accepted it, but when it was sent. Well so what, you might ask?

What if you look in your own calendar and see something you created, but don’t recall when? It can be quite handy to remind yourself when it was added – maybe you will find some emails around the same time that might give you more information on why you put that appointment in there.

The same rules apply when you’re looking at someone else’s calendar. What if you invite someone to a meeting (and this is where the competitive advantage bit comes in, perhaps), and they decline because they have a “conflict”. was the conflict merely an appointment they created after your invite. (covering tracks, perhaps)?

In a more benign scenario, what if you’re trying to bag a meeting room, but it’s booked out. maybe for a team meeting or some such. If you could see that the meeting was created 2 years ago, then you might contact the organiser to see if it’s still happening or even realise that the organiser no longer works here, and therefore a cancellation can’t be sent out to free the room, but it’s most likely not going ahead.

method

The beginnings of this method regards customising or designing Outlook “forms”. There’s a little more info on Outlook Forms in ToW#44 if you’re interested. In a nutshell, items in Outlook (appointments, messages, contacts etc) are simply a collection of fields, and use a designated – and customisable – form to display the fields’ values. In the example of a self-created appointment or a meeting you’ve organised, the standard Outlook form doesn’t display the date of creation, but it still exists behind the scenes.

To view the date, a simple way is to start by adding a new command to the “Quick Access Toolbar” that’s shown on the top left of your Outlook form:

  • Open the appointment or meeting you’re looking to get more information for, then click on the little down-arrow to the right of the Quick Access Toolbar.  then look at the bottom of the Customize list and choose “More Commands”
  • Next, change the “Choose commands from:” drop down to be “Developer Tab“, then on the left-hand side of the  dialog, scroll down the commands list to find Design This Form, (NB don’t choose “Design a Form”), then Add it to the list on the right by clicking the button. Press OK to return to the item. This will now put a new icon on the Quick Access Toolbar, that looks like a pencil, ruler and set square. Very retro design tools.

This should be a one-time exercise, that will now allow you to peek inside any Outlook item once you’ve opened it up (whether it’s from your own mailbox, or someone else’s calendar).

show me

Now, when you click on the Design This Form icon in the Quick Access Toolbar on an open item, it switches the form that’s being used to display that item into the “designer” mode, which shows any hidden tabs that the form might have (denoted as such by their names being in brackets). One of the hidden tabs on every form is “All Fields”, which lets you explore the values of every field that exists within the item that the form is displaying. Are you still with me?

Click on the All Fields tab and select “Date/Time fields” from the drop-down box, and hey-presto, you get to see every date field – like the Created date.

If you want to explore the differences between the various item types in Outlook, try looking at “All Mail fields”, “All Contact fields”, “All Appointment fields” etc.

Tip o’ the Week #98 – OneNote calendar front-end

clip_image002[4]Here’s a doozy of a little application that provides a great front-end to OneNote 2010, from Omer Atay of the OneNote development team.

clip_image001In short, it’s a separate app which shows a calendar view of all the OneNote pages you’ve written, arranged by date. If you have several notebooks open (maybe a Work one, a Home one that’s synchronised with SkyDrive etc), and like to have lots of sections and subpages, it’s an ideal way of referencing what you’ve been doing, chronologically.

Omer initially released the app inside Microsoft, but I’m pleased to see he’s making it available externally, for free, too.

To use, visit the application page from Omer’s own web site. It’s available as a stand-alone app from here, the idea being that you’d save the executable file to your PC somewhere and just pin it to your start menu to run. Alternatively, enter %programdata%\Microsoft\Windows\Start Menu\Programs into the search box on the Start Menu, and create a shortcut to the OneCalendar executable in there, so it’s not pinned but can be easily found again – either by name, or just by typing “OneCal” into the Start Menu to find the program again.

 

OneCal. ah, those of a certain age can reminisce about 1980s TV adverts, too.
(check out the YouTube collection of classic ads from 1983. they sure don’t make ’em like they used to.!)

Another was of getting hold of OneCalendar would be to install Omer’s Onetastic addin to OneNote – it allows you to pin an individual OneNote page to your desktop, cleans up multi-page printouts (where you print from another application into OneNote) and also launches OneCalendar from within OneNote. See more here.

Tip o’ the Week #96 – Reining back Outlook’s file size

clip_image002

Outlook likes to cache lots of information on your PC – which is generally beneficial. All of the email in your mailbox, for example, is already on your hard disk, so when you open a message or an attachment, it can open it clip_image003quickly. This is a Good Thing. In fact, it’s the reason why Office 365 works.

One feature added in 2007 was that Outlook also cached other users’ calendars after you’ve previously opened them, so that if you open them again, the data is already there. That is also good (pretty much).

In fact, Outlook will happily trundle through a long list of calendars, updating them in the background: you might find that since it caches all those users’ & meeting rooms’ calendars, that you have rather a lot of space being consumed by the offline file. If you’re running a laptop or desktop with a traditional spinning hard disk, you probably won’t even notice – but if you’re lucky enough to have a Solid State Drive, where storage capacities are typically much lower, then it could cause you a problem.

Outlook’s OST file (that’s the offline cache), can get pretty large – by default (in Outlook 2010), it won’t warn you until the OST is 47.5Gb in size, and it won’t let the file grow to more 50Gb. Note that we’re talking about the size of the offline cache file, not the size of the user mailbox, which will typically be an order of magnitude smaller. Nevertheless, having such a big OST file will cause the machine’s performance to suffer somewhat, since it will be indexing all of the data as well as probably maintaining lots of calendars or other shared folders (as well as whatever is in your own mailbox). I first hit this problem when the Outlook cache file was taking up about one quarter of my disk space, meaning the PC was running low of free space.

To see your OST file size, copy %userprofile%\AppData\Local\Microsoft\Outlook to the clipboard, bring up the Windows Start menu and paste that into the search box and press Enter. That will open up the folder where Outlook keeps all of its offline files, so don’t worry if you see lots that you don’t expect. If there are any big files with a really old date, then they are not being used by Outlook and might be safe to remove… though take a backup copy just in case…

clip_image005How to reclaim your disk space

If your OST file is particularly large (ie several times the size of your mailbox – and you can find out how large that is from the File menu in Outlook), then there are a few things you can do to reclaim the space back.

Delete the OST

You could quit Outlook, delete the OST file altogether and then restart Outlook – causing it to rebuild the whole thing from scratch. The downside to this approach is that it will take ages to complete, your PC will need to re-index all of the content to make it searchable, and you might end up with a similarly-sized file anyway since it will re-cache everything your Outlook profile tells it to.

clip_image006Be rid of Calendars

It is possible to get Outlook to discard some of the data it’s cacheing – a simple bit of housekeeping would be to prune the list of other calendars shown on the list to the left of your own calendar, thereby reducing the amount of background work it has to do to keep them up to date, and reducing the size of your offline cache file.

You can remove them one by one (though this could be laborious, it at least will let you decide which – if any – to keep), or simply right-click on any groups of calendars and ditch the lot. You can always add people back as and when needed. Go on, it’s quite cathartic.

clip_image007Stop the cacheing of other folders altogether

If you’d rather not cache calendars at all, you can switch off the whole functionality – simply (!) go into File | Info | Account Settings | Account Settings, and then double-click on the Exchange Server account that’s listed there. Within the ensuing dialogue box, click on More Settings then Advanced Settings. Now, you can choose to just not download (and cache) the shared Calendars or other shared folders. The downside is that you can’t see other people’s calendars when you’re offline, but that isn’t important, you might want to look at this option.

Compact the file

It may be worth trying to reduce the size in your OST file, and if you have done either of the previous 2 options, then you will definitely need to compact it. Outlook will reduce the OST file size in the background over time, reclaiming unused space in the file, but if you make large changes by deleting lots of infomration, you will need to force it to do some maintenance. A word of warning though – this will take a long time. We’re talking many hours, maybe even more than a day – so, it’s one to do overnight at best or over the weekend.

clip_image008To compact the file in size (and mine went from well over 30Gb to less than a third of that), follow the instructions to get to the Cached Mode Settings above, and click on the Outlook Data File Settings button at the bottom, and you’ll see the properties of the data file. Click on the Compact Now button and wait. Oh, and you can’t use Outlook whilst it’s compacting, so do not try this during the work day….

Hopefully this will help you keep your Outlook OST file size in check. It will free up space, it will give your PC less work to do in keeping a list of calendars updated and maintaining the searchable index of all your data.

Tip o’ the Week #92 – Take and Share better meeting notes

clip_image002[4]Be the scribe

OneNote is a great audit tool.

When you’re in meetings with customers and partners why not offer to take the notes on your tablet, slate or laptop and then when the meeting is done simply save the notes as a PDF to create a simple, (almost) non editable version of the notes that you can share with colleagues, customers and partners.  This is especially useful if you hook up your device to a projector (using duplicate screen mode) and use your tablet as an electronic whiteboard. 

To export your results to PDF, choose “File”, “Save As” and then “PDF”. When the save dialog is displayed you can choose to save selected pages, the current section or even the whole notebook. If you don’t want the PDF step you can share your notes even more quickly by using the Share tab and selecting the “E-mail Page” button to send the page as a picture. The “audit” part comes in because both you and the customer has a permanent copy of the notes – this has extricated me from a number of potentially taught situations?

For collaborating with colleagues, an even better option is to use shared notebooks. Using SharePoint 2010 (e.g. your MySite) you can create shared notebooks which are synchronised between team members and always kept clip_image002up to date.

This is great for going to a customer meeting, taking notes and then automatically having them shared with your extended account teams. The only thing to be aware of is that shared notebooks (especially with ink) can take up a fair bit of disk space – but don’t worry, a call to 5000 or through ITWeb can get your quota increased easily.

To share a notebook that already exists go into “File”, “Share” and then choose the SharePoint server (“Network” option) server where you want to store it. When you’ve done this make sure that the location you stored the notebook has the correct permissions for your colleagues. To share a new notebook on SharePoint, go into “File”, “New” and select “Network” and choose the SharePoint. This is great for collaboration but even better for showing customers how we “live the dream”clip_image003.

Did you know you can create a meeting note directly from an Outlook Appointment, and that note will contain the date, time, location and names of all the attendees of the Outlook item?

Just go into the meeting in Outlook and you’ll see a nice big OneNote icon – click that and the rest is obvious.

Using and creating templates

clip_image004One way of gettng better organised might be to use a common template for meeting notes – if you click on the down-arrow next to the New Page command in the sidebar, you’ll see available templates and a link allowing you to set up new templates or find others online.

Some templates on microsoft.com.

Tip o’ the Week #91 – So you’re OOF? Meh.

clip_image001[7]Now that Outlook, Exchange and Lync all provide a way of showing that someone is Out of the Office (aka OOF, not OOO), it should be no surprise when you send email to someone internally, that you get an Out of Office message.

clip_image001

Outlook’s tool tip tells you they’re out, Lync’s status icon shows the small * to indicate the same, and if you hover over the person’s name, you’ll see the same message shown at the top of the information balloon from Lync. clip_image003Maybe it’s time to ditch the receipt of old-fashioned OOF message altogether, at least by taking them away from your inbox…?

Fortunately, a simple Outlook rule will take care of that. We’ve talked about Outlook rules before in previous ToWs… #9 and particularly, #29. ToW #29 introduced a way of having multiple rules working to remove everything from your inbox that met a bunch of conditions, meaning that what’s left is likely to be important. If you get too many emails, check it out.

A short bit of theory

Now, you might not know this, but every “item” in Outlook (eg. email, contact, appointment) is really just a blob of data with some specific fields defining the shape of the item – obvious stuff like when was it created, sent, who was it sent to, what was its subject, etc. One of the more important fields is the “message class” – that’s the information that tells Outlook how it should be displayed, and what kind of functionality the user will have. Outlook needs to use a very different form to display a contact, for example, than a regular email message, yet underneath there’s actually very little difference other than which fields exists and what their values are.

So what? Well, it turns out OOFs use a specific message class, and can therefore be filtered out based on that.

clip_image005Create the rule

To set up the rule, go to the Home tab in Outlook’s main window, and under the Rules icon, create a new one. Now, go straight to Advanced Options button in the lower right. In the Condition(s) page of the rules wizard, scroll down and look for which is an automatic reply and tick it, then click Next. Now clip_image007you can decide what you want to do with it (Delete? Move to another folder, etc). It’s pretty self-explanatory after this point.

One nice side-effect here is that Outlook typically strips a lot of its internal information on an email that is sent externally – so if you get an OOF from a customer or partner, it won’t have the classification of being an automatic reply… it’s just a regular email as far as Outlook is concerned. So the filtering will only remove OOF messages from internal people and will leave external OOFs in your inbox.clip_image001[4]

If you’re feeling particularly adventurous, you could create other rules to handle messages based on type by using the “uses the form name condition… Just make sure you don’t squirrel important messages away too deeply, in case you might actually need to read them…

Tip o’ the Week #77 – Saving docs straight to SharePoint

clip_image002Here’s a simple tip inspired by Luke Debono, who was asking how he could save directly from within an Office application to our departmental SharePoint site, using Office 2010 and SharePoint Server 2010.

clip_image003Now, if you open a document from a SharePoint site then you might get to view/edit it in a browser, or perhaps open and edit within an Office application. On the backstage/File menu, you’ll see a few clues that the document is on a SharePoint site – like the location, or (depending on whether the functionality is enabled on the SharePoint) the ability to check the document out & in, see previous versions etc.

clip_image005If you’re writing a new document and want to publish it directly to SharePoint, you can do so directly from within Word, Excel & PowerPoint – go to the File menu and select the Save and Send option, at which point you’ll be able to save it straight to the SharePoint of your choice, maybe even one of the more recently used sites…

URL or UNC? U B the judge

If you’re working outside of Office applications but still want to save your stuff straight into SharePoint (your MySite for example?), then it’s still possible. SharePoint is clearly accessible via a URL (eg http://sharepoint etc), but you might not know it’s also available via the old-fashioned “UNC”…

clip_image006universal naming convention
A naming convention for files that provides a machine-independent way to locate the file. A UNC name usually includes a reference to a shared folder and file accessible over a network rather than a folder and file specified by a drive letter and path.

UNCs were used in the old LAN Manager and NT days, to connect to file servers. They took the form of \\server_name\share_name, characterised by the phrase “whack whack” – as in “connect to “whack whack server_name whack share_name”…

In this instance, you can generally convert the SharePoint URL into a UNC by ditching the http:// piece and substituting forward slashes to back-slashes. If you’re in the File dialog of any application, you can type a UNC into the “File Name” box and hit Save or Enter, then the File dialog will be re-pointed to that location… allowing you to save your file (under a chosen name) into that location.

Once you’ve pointed the File dialog to browse into your SharePoint, you could even add it to Favo(u)rites to make it easy to get there in future… bearing in mind if you jump straight to \\sharepointemea\00sites\sitename then you’ll see all the other SharePoint folders that go to make up the site.

Tip o’ the Week #71 – Formatting tips for Office apps

In various Office applications, pressing the F4 key will repeat the last command (if possible). Examples could be applying formatting to document elements (like turning text in Word into a header, or the borders of a table), where you could do it once then simply hit F4 to repeat it to other parts.

The uses are myriad – pretty much any repeatable command, from formatting, lining up shapes, table commands – just try pressing F4 to repeatedly do the same thing, rather than having to go back and forth to the menu. Deleting whole columns or rows in Excel is another great use – rather than right-click/delete row for each one, or clicking on the left hand border then pressing Delete to clear its contents, you could do it once then move the cursor to the next row you want to affect, press F4, and Robert’s your auntie’s live-in lodger.

The Tech for Luddites blog described F4 as the “Magic Office key no-one knows about”. It’s been a feature of Office for years. Yet I bet most of the ToW readers haven’t heard of it before…
I hadn’t, until Luke showed it to me…

There are other ways to repeatedly apply formatting design – such as the Format Painter, that lets you select something you want to copy (a paragraph in Word, for example), and by clicking the paintbrush icon, you can quickly apply the same formatting onto other selected area – and if you double click the Painter icon, you can keep applying in multiple places until you press Escape. [NB: the screen shot is from Word, where there’s a handy shortcut key to the format painter… sadly, Excel doesn’t have a shortcut so you have to use the menu].

On another note, the Office Labs team has released a great new version of their popular “Ribbon Hero” addin to Office – test your own skills in using Office applications, and maybe find a few new ways to make yourself more productive…

Tip o’ the Week #69 – Keep your favourites and Office settings synchronised

clip_image001We covered using Windows Live Mesh to synchronise OneNote files between computers in ToW #52, but overlooked one really simple but useful check-box capability – the ability to sync your IE favourites between PCs, and to sync your Office settings too. Jamie Burgess suggested this would be worth covering.

In essence, this gives you a one-click (on each PC) means to keep your favourites up to date across multiple home and work PCs, as well as keep your Office spelling dictionaries, templates and email signatures up to date too.

clip_image003If you have multiple PCs and one of the first things you need to do when building a new machine is to recover your Outlook signature and IE favourites, then this is just for you.

To switch on, install Live Mesh (as part of Live Essentials) if you haven’t already, then switch on by entering “mesh” into your start menu and then click on Windows Live Mesh to open up the settings. More detail here.

Turn on and off with a single click and you’re done. For the more advanced users, you could set up a Sync Folder to copy your Favourites (generally found in c:\users\<alias>\Favorires) etc to SkyDrive, and that way they’d be available from any PC (via http://skydrive.live.com), or a useful way of backing up your settings if you only use one PC.

Tip o’ the Week #67–Lync Conferencing Tips

clip_image002An earlier Tip o’ the Week featured “5 Golden Rules” for OCS and Lync conferencing, and those tips still stand.

If you host or participate in a Lync conference, you can dial-in to the meeting from a phone as well as joining from your PC – eg for Microsoft-hosted Lync conferences, attendees can find numbers here when joining from elsewhere. The same URL can be used to set your conferencing host PIN, so if you dial the access number, you can sign in as the meeting leader.

Enter the conference ID that’s listed in the appointment, or which can be gleaned from the Lync client in the conference itself – so the leader could potentially pass on the joining instructions to other users who are not online.

Lync has some touch-tone commands that can be used to control the phone call – as an attendee, the most important is possibly *6, which mutes/unmutes your phone. Do everyone a favour if you are dialling in to a conference call, and mute your phone when you don’t need to talk. You’ll hear confirmation that “you are now muted” or the reverse, so it should be pretty clear what your current status is. Hopefully no embarassment of you starting to talk while still on mute and wondering why no-one’s listening, or the even less desirable inadvertent heavy breathing that can distract everyone else on the call.

Other touch-tone commands can help to provide the kind of info you can see when you join a conference call using the Lync client directly. Examples:

*1 – plays a list of conferencing commands you can use
*3 – plays a list of other attendees’ names
*4 – Toggle “audience mute”
*6 – Mute yourself
*7 – Lock/unlock the conference
*8 – Admit all participants currently in the lobby
*9 – Enable/disable announcements while entering/exiting

Clearly, some of these are only applicable if you’re a conference leader: it is worth remembering that you can still dial in and control a conference, even if you aren’t able to join from a PC.