Quickly Check Outlook Junk Folder for Non-Spam Messages

I get tons of spam email in Outlook, even though I’ve set up countless rules to deal with it. Instead of spending time on useful work, I have to scan that folder full of junk, in case any legitimate messages ended up in they accidentally. But I finally found a setting that has been a big help this week.

Continue reading “Quickly Check Outlook Junk Folder for Non-Spam Messages”

Record and Use Notepad++ Macros to Save Time

To save time in Notepad++, you can record and run macros. Here’s one of my favourite macros, and the steps for setting it up.

Repeated Tasks

I keep Notepad++ open all day, making notes as I go, and I like to section things off with lines.

It doesn’t take long to type a string of equal signs, or a line of hyphens. But I make lots of lines every day, and those little bits of time, repeated over and over, can add up quickly!

Video: Record and Save Notepad++ Macros

In this short video, I show how to record a Notepad++ macro, then test it, and save it, to use later.

There are step-by-step instructions below the video.

Macro Makes Lines

So, to save my time every day, I made a couple of macros that I can use, to insert each line quickly.

For example, if I press Ctrl + Shift + =, one of my recorded macros enters a long line of 60 equal sign characters, followed by the Enter key, to go to the next line.

If I use that macro 20 times in one day, I can save over 1000 keystrokes!

Record a Macro

Here are the steps that I followed, to create that type of macro in Notepad++.

  • To start, click in your Notepad++ document, where you want the insertion point
  • Next, click the Macro command, at the top of the screen.
  • In the drop-down list, click Start recording.

Start recording a macro

  • In your Notepad++ file, slowly and carefully use the keystrokes that you want to record in the macro
    • For this example, I typed a long line of equal signs
    • Then I pressed the Enter key, to move to next line in the note
  • When you’re finished typing, go to the Macro command again, and click Stop recording.

Tip:

  • It doesn’t matter how slowly you do the steps while you record them!
  • Notepad++ plays back the keystrokes that you record, as quickly as possible.

click Stop recording

Test the Recorded Macro

The next step is to test what you’ve recorded.

  • Click in the note, to place the insertion point
  • Click the Macro command again, and then click Playback.

test the recorded macro with Playback

The recorded code will run, and it should create a new line, like the one that you recorded.

  • OK: If the playback worked as expected, you’re ready to move on to the next step.
  • Not OK: If there was a problem, go through the macro recording steps again.
    • Take your time while doing the steps, to ensure that there aren’t any problems this time.

Save the Macro

After the playback is correct, it’s time to save your macro.

  • Click the Macro command, then click Save Current Recorded Macro.

savethe recorded macro

  • When the Save Macro dialog box opens, fill in the required information.
    • For example, call this macro MY LINE =
  • Next, choose the shortcut keys that you want to use
    • For this macro, I used Ctrl and Alt
    • In the drop-down list of characters, I chose the equal sign.
  • Finally, to save the macro, click the OK button

enter the macro shortcut settings

Run the Saved Macro

After a macro is saved, you can run it any time you’re working in Notepad++

  • First, click where you want the text to be inserted
  • Next, press the macro’s shortcut key combination, to run the macro

In this example, if I press Ctrl+Alt+=, Notepad++ inserts a long line of equal signs, at my insertion point.

Run Macro from Toolbar

If you haven’t used a macro recently, you might not remember its shortcut keys.

Another way to run a macro is with menu commands

  • First, click where you want the text to be inserted
  • Next, click the Macro command on the toolbar
  • Click on one of the macros that’s listed there, to run that macro.

Run a Macro Multiple Times

Most of the time, I only want to run a macro once. But if you want to run a macro multiple times, there’s a built-in command for that.

  • Click the Macro command, then click the Run a Macro Multiple Times command.
  • When the dialog box opens, click the drop down arrow, and select the name of the macro that you want to run.
  • Next, click the Run option, and type the number of times that you want to run the macro
  • OR, clicNextk the Run until the end of the file option
  • After you’ve entered those settings, click the Run button.

Note: In the screen shot below, I hadn’t clicked the Run option yet

Run Notepad++Macro Multiple Times

Notepad++ Macro Conflict

When you’re saving a Notepad++ macro, be sure to use a unique shortcut key combination.

  • If you use a shortcut key combination that’s already used, a conflict warning will appear at the bottom left of the Shortcut dialog box.
  • In the screen shot below, I used Ctrl + Alt + = and there’s already a saved macro with that shortcut.
  • A CONFLIC FOUND warning is showing, at the bottom left of the dialog box.

However, Notepad++ doesn’t stop me from using the shortcut again.

  • I can click the OK button to save this duplicate macro shortcut

macro shortcut conflict found

Modify Shortcuts or Delete Macros

To manage your macros, you can open the Shortcut mapper dialog box

  • Click the Macro command, then click the Modify Shortcuts/Delete Macro
    command.
  • When the Shortcut mapper dialog box opens, it shows a list of the saved macros, along with their shortcut key combinations.

In the screen shot below, two of the macros are highlighted in red, because they have the same shortcut key combinations

macro shortcut mapper with conflicting macros

Fix Conflicting Macros

If there are conflicting macros, you should fix that situation, to prevent problems.

  • In the screen shot below, macros number 9 and 11 have the same shortcut keys.
  • I’ve clicked in macro 11, to select it, and it has a brighter highlighting now.
  • In the box below the list, it shows the conflict details:
    • Macros – 9 – MY LINE = (Ctrl+Alt+-)
  • Because macro 11 is a duplicate of macro 9, I will delete it

At the bottom of the Shortcut mapper dialog box, there are 4 buttons – Modify, Clear, Delete, and Close

  • With Macro 11 selected, I clicked the Delete button.

delete macro in shortcut mapper

A confirmation message appeared:

  • Are you sure?
  • Are you sure you want to delete this shortcut

There are OK and Cancel buttons, and I clicked the OK button, to delete the conflicting macro

confirmation message for deleting Run Notepad++Macro shortcut

Modify a Macro Shortcut

Another way to fix a conflict is to modify the macro shortcut.

  • Select the macro in the list
  • Click the Modify button, to open the Shortcut dialog box
  • You can change macro name, and/or the shortcut keys
  • Click OK to complete the change

Cannot Modify Recorded Keystrokes

Unfortunately, you can’t modify the recorded keystrokes.

  • To use different keystrokes, record a new macro, with the keystrokes that you want to use
  • Then, save the new macro, and delete the old, incorrect one.

How Will You Use Notepad++ Macros?

Try recording one or two macros in Notepad++ to see if that helps you save time.

  • What Notepad tasks do you repeat several times a day?
  • Or, are there daily entries that take a few seconds every day, several time a week?

Those tasks could be perfect as macros!

____________

Make Text Files Open With Notepad++ by Default

All day, every day, I make notes in the Notepad++ application while I’m working. First thing in the morning, I open my Daily Notes file, using a desktop shortcut.

It’s quick and easy – right-click the desktop icon, point to the “Open with” command, and then click on Notepad++.

Open with command, click on Notepad++

Continue reading “Make Text Files Open With Notepad++ by Default”

Grow Your Small Business–Task Challenge–Summer Season

Is summer a quiet time for your small business? If so, it could be the perfect time to work on growing your business! And I’ve got a couple of free Excel workbooks to help you!

My Contextures site features Microsoft Excel tips, videos and tutorials, and things slow down in the summer. People are at the beach, instead of in their offices or classrooms!

Summer Business Task Challenge

I’ll take some time off too, but I also want to work on growing my business. It’s a never-ending job!

To make things more fun, I created a Business Task Challenge template in Excel (and you can get a copy).

  • In the file, I’ve listed about 90 tasks that I could do this summer, or have my summer intern work on.
  • We’ll each pick a target number of tasks to complete
  • Excel formulas will track our progress

This task challenge will help us focus on getting things done,:

  • Our goal tasks will be selected at the beginning of the summer season
  • We won’t waste any time, wondering what to do next!
Grow Your Small Business–Task Challenge - Summary
Grow Your Small Business–Task Challenge – Summary

List Your Business Tasks

If you’d like to do a task challenge too, you can get the template on my Contextures site, on the Sample Files page.

  • In the Functions section, look for FN0079 – Business Task Tracker

To help you get started, I made a list of 89 business tasks. You can work with my list, or customize the list with your own tasks.

Formulas at the top of the worksheet show the total number of tasks, and how many are finished.

Check the “Done” box, for each task, when you’ve finished it.

  • Note: If you don’t have check boxes in your version of Excel, you can use TRUE and FALSE in the Done column.
Grow Your Small Business–Task List - Excel
Grow Your Small Business–Task List – Excel

Filter the Task List

To make it easier to choose your tasks, there are two Slicers on the Excel worksheet.

  • Category – click one of the category names, to see only those tasks in the list
  • Who – click one of the “Who” names, to see only the tasks for that person

Later, to see all the tasks again, click the “Clear Filter” button, at the top right of each Slicer.

Filter the Task List with Slicers
Filter the Task List with Slicers

Vision Board Tasks

Another type of  task challenge is based on a  vision board bingo card.

  • Put 24 tasks or goals in a grid
  • Cross off the tasks, when you finish them

I made an Excel Vision Board bingo template, that you can get on my Contextures site.

  • Note: The vision board template uses the FILTER function, which is available in Excel 365

Video: Vision Board Demo

You can see a quick demo of my vision board in the video below. I show how the Vision Board bingo template works, and how you can customize it, to use your own goals and tasks.

Vision Board Example

The screen shot below shows some of the goals in my sample file.

  • I’ve put 92 goals in the file
  • You can mark any 24 of them, for the bingo card
  • Later, mark different tasks, for a fresh bingo card

You can also edit, delete or add goals and tasks in the list, to customize it for your own business tasks or personal goals!

vision board bingo card in Excel
vision board bingo card in Excel

‘______________________________

Fairy Houses in Tinker Park Rochester New York

One of our favourite fall vacations is a short trip to Rochester, New York, to do some shopping and sightseeing. We didn’t get there this year, so I dug out some photos from our visit in October 2016. The highlight that year was a forest trail filled with tiny fairy houses! Continue reading “Fairy Houses in Tinker Park Rochester New York”

Fix HTML DataTables Interactive Search Box Missing

On my Contextures Excel Tutorials website, there are a few pages with long lists. To make it easier to find information in those lists, I’ve used DataTables, so people can sort the columns, and search for specific text.

Broken DataTable Features

This week, I noticed that, on one page,  the table wasn’t showing its interactive features. The Search Box, the column sorting arrows, and the items per page drop down, were all missing.

It took me a while to find and fix the problem, but it’s working correctly now. If you have a similar problem with DataTables, I hope the notes below help you fix the problem.

Continue reading “Fix HTML DataTables Interactive Search Box Missing”

How to Fix Microsoft Access Warning Messages Not Working

Yesterday, while I was working on monthly reports in Microsoft Access, I noticed that the standard warning messages weren’t appearing. Here’s how I fixed the problem, with an easy solution. And it’s not one of the 2 suggestions that you’ll see in most places!

Continue reading “How to Fix Microsoft Access Warning Messages Not Working”