Tag Archives: Tech Tip

Shortcut to enter date in Excel

If you use Excel, sooner or later you will need to enter the date into a cell. The following shortcut inserts a snapshot of the date into a cell, formatted in whatever way the cell is formatted.

1. In Excel, open the worksheet you need to insert the date into.

2. Click the cell you wish to insert the date into

3. Type CTRL+; (press the Ctrl key followed by the semicolon key)

The date displays in the cell. Format it any way you wish (eg, long date, short date, colour, etc). It is a snapshot, so it will stay the same no matter what other date you open the workbook.


Check out our Archive of Tech Tips – to check it out, click here, then hit the “End” key on your keyboard to jump to the end of the Archive list where the most recent Tips are.

Was this tip helpful to you? Anything else you want to know? Please leave a  comment below.

You’ll find more learning at Learning and Development

Include an email as an attachment

As you probably know, files can be attached to an email message. But did you know that other Outlook items, such as messages, contacts, or tasks can also be included with a message that you send?

Here we’ll look at including an email as an attachment.

There are various ways to do this, but the simplest way is as follows:

1. Create a new email message in Outlook

2. Drag the new email message window to one side so that you can also see your Outlook Inbox

3. From your Inbox (or Mail folders), drag the email messages you wish to attach and drop them into the body of the new email message. Don’t worry, this will not remove them from the Inbox or folders!
– the attached messages are grouped into an “Attached” area on the new email message

4. Complete the email message with your message and recipient(s)

5. Send the email message


Check out our Archive of Tech Tips – to check it out, click here, then hit the “End” key on your keyboard to jump to the end of the Archive list where the most recent Tips are.

Was this tip helpful to you? Anything else you want to know? Please leave a  comment below.

You’ll find more learning at Learning and Development

Email only those who accepted a meeting – Option B

Last week we covered the quicker way to send a follow-up email to people who have accepted a meeting request, while excluding those who have not accepted the meeting.

However that method best suits occasions when there are only a few people who have declined the meeting request.

Today we look at the method to use if you have a lot of attendees who have declined – say, more than 10.

This looks like a lot of steps but it’s actually quite quick.

In the same way you can send a message to all those who gave no response to urge them along a bit. I explained the “None”
response in this Tip titled Are you causing someone else trouble when you accept a meeting?

This option involves a little use of Excel and filtering, but don’t be put off if you  are not familiar with Excel – here’s where you’ll get to learn a very useful feature! (I have added some explanations for you between the steps below.)

  1. View/open the appointment in Outlook.
  2. Click the Tracking button.
    – The names of all those invited are listed, with their acceptance status displayed to the right of their names.image002
  3. Click Copy Status to Clipboard.
  4. Open Excel.
  5. Select Cell A1.
    – This is the top left empty rectangular “cell” below “A” and next to “1”.
    – Click it to select the cell.
  6. Paste.
    – The names of all those you invited to the meeting display in
    columns, along with their attendance status and response.
  7. Widen the columns so you can read their contents clearly.
    – Do this by dragging to the right the thin line between the
    alphabetical letter at the top of each column, eg, A, B, C
  8. Click anywhere in the contents of those columns, eg, click the name of one of your attendees.
  9. Click the Sort & Filter drop-down arrow at the far right end of the Home Ribbon and click Filter.
    – Filters are added to the top of each column. These are drop-down arrows that allow you to sort information in the column.image003
  10. Click the filter drop-down arrow at the top of the Response
    column, and choose Sort A to Z.
    – All the staff who accepted are shown listed at the top of the
    Response column.
  11. Select all the names of the staff who accepted in the Name
    column.
    – To select the names, starting with the first name, click and drag your mouse down over the names you wish to select, in the same way you would select text in an email or Word document.
  12. Copy.
  13. Open Outlook
  14. Create a new message.
  15. Click into the To: field.
  16. Paste.
    – All the names you copied are pasted in.
  17. Press Ctrl+K to force Outlook to reconcile the names with the Name & Address Book.
  18. Write the message and send it.

And that’s it! Let me know how you find it – leave a comment.

Like these tips? Want to see more tips?

Learning and Development

Email only those who accepted a meeting

If you’ve invited a number of people to a
meeting, how do you send a follow-up email
to only those who have accepted?

There are two ways to do this.

Option A is the quicker, simpler way. It’s the one to use if you don’t have too many attendees who have declined – say, fewer than 10. We’ll cover this today.
Option B is the more involved way. It’s the one to use if you have a lot of attendees who have declined – say, more than 10. We’ll cover that next week.

So here is Option A, the simpler option. The one to use if you don’t have too many attendees who have declined.

  • View/open the appointment in Outlook.
  • Click the Tracking button on the Meeting ribbon.Outlook Tracking button               – The names of all those invited are listed, with their acceptance status displayed to the right of their names.
  • Remove the ticks from alongside the names of the people who have declined (the ticks are to the left of their names). Click a tick to remove it.
  • Click the Contact Attendees button on the Meeting ribbon (it is a few buttons to the right of the Tracking button).Outlook Contact Attendees button       – a drop-down menu displays.
  • Click New E-mail to Attendees.
    A new mail message is created, addressed only to those attendees who still have a tick next to their name.
  • Complete the message and send it.
  • DO NOT SAVE the appointment, otherwise all those attendees you un-ticked will be sent a meeting cancellation notice. Instead close the appointment and select Don’t save changes.Outlook Don't save changes

Was this tip helpful to you? Anything else you want to know?
Please leave a  comment below.

Like these tips? Want to see more tips?

Learning and Development