Office Solutions Archive

In this article, I analyze the “Could not complete the operation. One or more parameter values are not valid” error when trying to manage Outlook rules after a Windows system update. Then provide a solution for the problem.

Hardware/Software Configurations:

My computer has Windows 7(64bit) and Outlook 2010(64bit) installed. Both work perfectly without any problems. But things change after a Windows system update …

Note: I have set Windows system update to auto update mode.

Symptom:

Last night, Outlook continued working smoothly. When I shut down my computer, I see Windows update message “Please do not power off or unplug your machine. Installing update ## of ##”.

As Windows update frequently, I do not pay much attention to that. Just let it go.

However, this morning, when I try to start Outlook as usual, I see a warning message “Outlook is not the default email client”. I just check the option to reset Outlook as the default one and proceed.

Then, in my Outlook inbox, I see a lot of new incoming emails. Originally these emails should be filtered and put into the corresponding subfolders by rules automatically. I immediately notice that there may be something wrong with my Outlook rules. Therefore, I try to click “File” -> “Manage Rules and Alerts”, but “Rules and Alerts” dialog box does not appear. Instead, I get another error message “Could not complete the operation. One or more parameter values are not valid”.

Now all of my rules stop working. I have to pick up hundreds of emails manually. That is a nightmare, especially when I need to do that every day. Therefore, I must fix the problem as soon as possible.

Diagnosis:

At the beginning, I thought the problem is caused by the Windows update, since my Outlook is fine just before the update. And Windows update has a reputation of introducing new problems to an existing stable system.

I have made a backup of the whole system, before the problem occurs. Therefore, that is my last resort to solve the problem.

Before doing anything, I try to contact Microsoft support. And they provide the following solutions:

  1. Use the “Repair” function in Office installer to repair Office, including Outlook.

Result: I try the solution but after the repair process, nothing changes.

  1. Create a new profile. Then recreate all the accounts for the profile and add the existing PST file to it.

Result: I try to create a new profile, create a test account, and then add the existing PST file to the new profile. Then I restart Outlook. This time I can start the rule manager. But all rules disappear. I cannot understand that since in Outlook 2010, the rules are stored in the PST file. Therefore, what I need to do is recreate all the accounts and rules, which is time consuming. Therefore, I finally discard this solution.

  1. For Outlook 2010, the rules are stored in the PST file. Therefore, the support thinks my PST file is corrupt and suggest me to repair it with scanpst.

Result: I don’t think the problem is caused by PST file corruption. To confirm my idea, I try to restore my PST file to an old version before the problem occurs with DataNumen Backup, then restart Outlook. The problem still exists. So, the problem should not be caused by the PST file, but a system update which changes the Outlook executable or dll files.

Deep Diagnosis:

I guess the problem may be caused by a conflict of my existing rules in PST file and the new updated version of Outlook. Therefore, I try to follow this article to write a small VBA code to delete all the rules in my PST file. However, whenever the code steps to the following line:

Set objRules = objStore.GetRules

I will still get a “Could not complete the operation. One or more parameter values are not valid” error again. So the problem jus prevents me from access all the rules via either GUI method or VBA codes. I have to seek other ways to solve the problem.

Solution:

Now based on the above analysis, there are two solutions for my problem:

  1. Restore the whole system to the time point before the system update occurs.
  2. Recreate a new profile, and recreate all the account and rules again.

Solution 2 is time consuming. Therefore, finally I decide to choose the first one, as follows:

  1. Unplug the network cable and disable the wireless network in my computer. To prevent the system from being updated automatically.
  2. Make a backup of the PST file since it contains some new emails after the update.
  3. Restore the whole system to the time point before the update occurs.
  4. Overwrite the old PST file with the new one backed up in step 2.
  5. Start Outlook.
  6. Click “File” -> “Manage Rules & Alerts”, this time the “Rules and Alerts” dialog box will pop up without any problems. And all the rules appear in it.
  7. There may be some rules in the PST file that conflict with the new system update. Since I don’t know which one cause the conflict, I choose to remove all of them.
  8. Re-plug the network cable and re-enable the wireless network in my computer.
  9. Check and perform system update manually. During the update, I can see there is an update for Outlook.
  10. After the update, restart Outlook and re-access the rules via “File” -> “Manage Rules & Alerts”, this time I can still access the “Rules and Alerts” dialog box.
  11. Add all the rules back.
  12. Everything is OK now even with the latest update of Outlook.

Conclusion:

The system update causes a conflict of the existing rules with the new updated version of Outlook. It is better for Microsoft to find a fix for that, or provide an option to remove the conflict rules. However, if none of them are available in a timely manner, we can still solve it by utilizing an old backup.

1 Comment. Join the Conversation

After inserting many comments in an Excel workbook, you may want to customize the fonts of all the comments. In this situation, you can refer to this article. Here we will share you 2 easy methods.

As we can see, the comments inserted in Excel automatically use the default font. At times, you may want to alter the comments’ fonts. If there are a few comments, you can simply use the following Method 1 to manually change them. However, if there are hundreds of comments, you are better off selecting the latter means.

Method 1: Change One by One

  1. First off, select a comment in the worksheet.
  2. Then, right click on it and select “Format Comment” from the context menu.

    Select "Format Comment" Menu Item

  3. Next, in the small popup dialog box, you can select fonts and styles to your liking.

    "Format Comment" Dialog

  4. Ultimately, click “OK”.
  5. Later, you can use this way to manually change comments one by one.

Method 2: Batch Change via VBA

  1. For a start, launch Excel VBA editor with reference to “How to Run VBA Code in Your Excel“.
  2. Then, in the “Microsoft Visual Basic for Applications” window, put the VBA code below into a project or module.
Sub BatchChangeFontsOfAllComments()

    Dim objWorksheet As Excel.Worksheet

    Dim objComment As Excel.Comment

   

    'Process all worksheet one by one

    For Each objWorksheet In ThisWorkbook.Worksheets

        If objWorksheet.Comments.Count > 0 Then

           For Each objComment In objWorksheet.Comments

               With objComment.Shape.TextFrame.Characters.Font

                    'Specify font name and size

                    .Name = "Comic Sans MS"

                    .Size = 10

                    'Use RGB function to create a color value

                    .Color = RGB(255, 0, 0)

                    .Italic = True

                    .Bold = True

               End With

           Next

        End If

    Next

End Sub

 

VBA Project

  1. Later, run this macro simply by pressing “F5” key button.
  2. Eventually, after macro finishes, back to the worksheets.
  3. As you can see, the fonts of all comments have been changed, as shown in the following screenshot:

Change Comment Font Result

Comparison

Advantages Disadvantages
Method 1 Quick and easy to process a small amount of comments Very troublesome in case of too many comments
Method 2 Very efficient regardless of the number of comments Increase risks of virus infection

Restore Compromised Excel File

When your computer suddenly shut down, if some Excel files haven’t been saved, the next time when PC boots back up, you may find the Excel files are corrupted. At this point, if you would like to get back the files, you have no choice but to take aid of a powerful and reliable Excel recovery tool, like DataNumen Excel Repair, which can recover corrupted Excel data with effortless ease.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including fix sql and outlook repair software products. For more information visit www.datanumen.com

When flagging a contact, some users hope to get a standard Outlook task in To-Do List instead of a flagged contact. Now, in this article, we will introduce a method to let Outlook auto create a task for call the contact person later when flagging a contact.

As we all know, when flagging a contact, the contact will display in the To-Do list. But, most of time, what we really want is a standard task for calling this contact later and contains the telephone numbers of the contact only in task body. Hence, here we will introduce a method to configure Outlook to auto create such a task. Read on to get more details.

Auto Create a Task to Call the Contact Person Later when Flagging a Contact

  1. At first, launch Outlook VBA editor with reference to “How to Run VBA Code in Your Outlook“.
  2. Then, open the “ThisOutlookSession” project and put the following code into it.
Private WithEvents objContacts As Outlook.Items

'Works for contacts in the default Contact folder
Private Sub Application_Startup()
    Set objContacts = Outlook.Application.Session.GetDefaultFolder(olFolderContacts).Items
End Sub

Private Sub objContacts_ItemChange(ByVal Item As Object)
    Dim objContact As Outlook.ContactItem
    Dim objTask As Outlook.TaskItem

    If TypeOf Item Is ContactItem Then
       Set objContact = Item

       If objContact.IsMarkedAsTask = True Then
          If objContact.TaskCompletedDate = "1/1/4501" Then
             'Create a task for calling this contact
             Set objTask = Outlook.Application.CreateItem(olTaskItem)
             With objTask
                  .Subject = "Call " & objContact.FullName
                  .StartDate = objContact.TaskStartDate
                  .DueDate = objContact.TaskDueDate
                  .Attachments.Add objContact
                  .Body = "Business: " & objContact.BusinessTelephoneNumber & vbCr & "Home: " & objContact.HomeTelephoneNumber & vbCr & "Other: " & objContact.OtherTelephoneNumber & vbCr & vbCr
                  .ReminderSet = True
                  .ReminderTime = objContact.ReminderTime
                  .Save
                  .Display
             End With
             objContact.ClearTaskFlag
             objContact.Save
        End If
      End If
   End If
End Sub

VBA Code - Auto Create a Task to Call the Contact Person Later when Flagging a Contact

  1. After that, put cursor in the “Application_Startup” subroutine and press “F5” key to activate this macro.
  2. Finally, exit the VBA editor and try this macro right away.
  • Select or open a contact and flag it.Flag a Contact
  • At once, a new task will be displayed, like the following screenshot.Popup Task
  • Meanwhile, as you can see, the contact’s flag is automatically removed.

Repair Compromised PST Files

Like Word documents, Outlook PST file is also prone to corruption. Many users have been plagued by the problems related to inaccessible PST files. Fortunately, Outlook comes pre-installed with an inbuilt repair utility – Scanpst. It is indeed able to fix a majority of small PST issues. Yet, when confronting seriously corrupt PST file, it seems ineffective. Thereby, at that time, you have to take aid of a more powerful tool, like DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and outlook repair software products. For more information visit www.datanumen.com