I’m looking for ideas and suggestions for future posts. Since Outlook is my specialty, I’m particularly interested in features or capabilities you wish it had. Keep in mind that I don’t work for Microsoft and cannot change the basic product itself. I can pass suggestions on to the folks at Microsoft though. While I cannot promise that I’ll use every suggestion or that I can even come up with a solution, I will do my best to respond to all of them, even those that don’t have anything to do with Outlook. If you’d like to share an idea, then please add it as a comment to this page.

621 comments on “Suggestions

  1. Hi David,

    Could you please share some article on auto reply mail for below scenario,

    Step 1: Mail sent to support team with Subject:”Error: found in the text1″
    Step 2: Auto reply mail sent acknowledging the step 1 mail based on Subject keyword – “Error”
    Step 3: On the same thread,again one more Mail sent to support team on top of Step 2 mail with Subject:”Error: found in text 2″

    Step 4: Now the Auto reply mail doesn’t acknowledge my Step 3 mail , as Step 2 was in replied state(ie:”RE:”)
    since I have added an exception for auto reply to not send the reply when the subject keywords are like “RE:” or “FW:”

    I need to acknowledge the mail even if it is same thread.

    how can i overcome this scenario.I understood that if any of mail threads have “RE:” or “FW:” apart from latest mail received,auto reply is not working.

    Give some suggestions on the above.

    • Hi, R.B.

      Outlook has at least three ways to “auto reply” to a message.

      1. Out of Office. While it’s turned on, OOF will automatically reply once to each sender, regardless of subject or message contents.
      2. Rules. You can construct a rule that will reply to any message that meets a condition you define in the rule. Outlook will send a reply every time it receives a message that meets the rule’s condition.
      3. Macros. You can construct a macro that behaves the same as a rule. The advantage of using a macro is that you can create conditions and take actions that are impossible to do with a rule alone. The disadvantage of using a macro is that macros are only available when the computer is on and Outlook is running. Contrast that to rules which run from the server, assuming of course that your mail is hosted on an Exchange server.

      If your mail is hosted on an Exchange server, then using a rule is probably the best approach. Rules run all the time, even when Outlook is not running. If your mail is not hosted on an Exchange server, or if you need to use a condition that is not available via rules, then a macro solution is best. However, for that to work you must have Outlook open and running all the time. If you don’t, then the solution cannot respond to messages as they are received. Instead, it will respond to them when you start Outlook.

  2. Hi
    Some great stuff on here – thanks for your generous time donation.

    I have a frequent need to categorise selective emails and file them to a folder. Category and Fold are linked. So, I could categorise and then move them, each using aright-click; or categorise and periodically run a rule to move them;

    But, being somewhat retentive about filing things I like to do them as soon as I’ve dealt with them. I’m sure its simper to do it so a button click can categorise and file selected email(s) in one go; multiple buttons for different category/folder combinations even… yet not so simple for me to succeed, I’ve tried merging various items from your site, with a startling lack of success.

    Can you help?

    • Hi, Mark.


      How many categories/folder combination would you have? If I knew that I’d be in a better position to suggest a solution.

  3. Dear David,

    Thank you so much for your sharing and help. I’ve been studying your codes practicing and learning VBA. While I play with different versions of this exporting appointments trick of yours, I created a simple scenario, it is like, after the appointment list in full detail is exported to a CSV, there’s another excel with another set of code, to search full the CSV, look for set of matches then according to the result it will gather data reference to the match and export to different CSV in different file locations. e.g. The script looking at the appointment list’s “location” column, then if result match location A, the appointment’s start time, end time, host and location these info go into folder A’s CSV file. I’ve taken example of conversation of you and another reader, about searching and editing for exact match data in cell. I’d also love to, at your most convenience, be advised by you, or maybe look at some examples in your next post of similar feature. Looking forward to your feedback. Cheers 🙂

  4. Hope you can assist us.

    We have an excel named “MASTER”
    Sheet 1 is named “ACTIVE” and is protected by password “TEST”.
    Column 2 (B) contains names (ex: Duck, Donald).
    Column 52 (AZ) has the text “ACTIVE” entered automatically, by formula, when a date is entered in column 4 (D).
    When cell 52 is changed to “DISCHARGE” need a verification message to appear stating “Are you sure you want to discharge Donald Duck”?

    If answer is yes, need Discharge text to remain in column 52 and the entire now needs to be deleted from “ACTIVE” and text pasted on the next available row of the sheet named “DISCHARGED”.

    If the answer is no, column 52 is to revert to “ACTIVE”.

    Thank you in advance for you help!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s