2. Outlook Email - Move It!

Outlook email can be moved into a folder using the text that appears in the subject line. When you sell a book through Amazon you receive a message that

always has "Sold It!" in the subject line. I created a subfolder in my Outlook Inbox called Amazon . Then, in the Amazon folder I created a subfolder called "A:Sold". This is the folder to which I re-directed all my Sold It! messages.

The following figure shows the hierarchy of folders in my Inbox that relate to Amazon Sold It! emails:

Figure 1: The Outlook Email Folder Hierarchy

You can, of course, use any folder name you like and place it in any hierarchy under the Outlook email Inbox. But in the discussion that follows I will assume you have called the folder A:Sold.

To force the Outlook email Sold It! messages into the A:Sold folder use the Outlook Rules Wizard.To do this, from the Outlook window,choose:

Tools → Rules Wizard → New → Move New Message From Someone → Next → With Specific Words in the Subject 

Then, in the ‘Rule description’ box in the Rules Wizard, click on specific words and specified folders to set up the move. This means all the Sold It! messages will be sent to one folder; they can now be manipulated together without affecting other items or messages. This makes VBA programming tasks MUCH more straightforward, as you will see in subsequent chapters.

In passing, note that "A:" is in front of "Sold" because folders appear in alphabetic order. By using A: I forced this folder to appear at the top of the list of folders in my Amazon folder. The other folders are “B:Dispatched” and “C:Delivered”. By moving the original Sold It! messages from folder to folder, you can track your mail deliveries through different stages of the posting process.