Recipients.Add method causing Error 287

[Excel1user]

I am writing vba code to create Outlook tasks for various employees from an Excel spreadsheet. The spreadsheet contains a list of reports under review and who is assigned to review the task.
I want the vba code to create an Outlook task for the individual assigned to review the report. I have found a number of websites with example code of how to do this, but everytime I have tried to use the code I get the same error on the "Recipients.Add" line. The error is vba "Run-time error '287': Application-defined or object-defined error".
Here is the code I'm using: (It is interesting to note that I have written code that successfully writes an e-mail, but that code uses the ".To" method, instead of the "Recipients.Add" method. Unfortunately the ".To" method is not available for Task Items.)

Option Explicit
Sub createtask()
    Dim olApp As Outlook.Application, olNs As Outlook.Namespace, olTask As Outlook.TaskItem
    Set olApp = Outlook.Application
    Set olNs = olApp.GetNamespace("MAPI")
        olNs.Logon
    Set olTask = olApp.CreateItem(olTaskItem)
    olTask.Assign
    olTask.Subject = "Test"
    olTask.Body = "Testing macro"
    olTask.Recipients.Add ("myemail@myemail.com")
    olTask.Display
End Sub

 

[totalnanerdoza]

Very curious if anybody was able to figure this one out. I'm getting the same error in the exact same point and have scoured the web for a solution. The SendKeys thingy seems to be closest to a workable solution here but I'm losing sleep over this one - why, Excel, why!

 

[totalnanerdoza]

Well,

this is all well and good but apparently the SendKeys method is not great if you have multiple meeting requests (as have I ). The macro actually creates the meetings faster than the SendKeys types in the names. Of course, I can make the application wait but that's not very efficient. Any ideas are most welcome.

Very curious if anybody was able to figure this one out. I'm getting the same error in the exact same point and have scoured the web for a solution. The SendKeys thingy seems to be closest to a workable solution here but I'm losing sleep over this one - why, Excel, why!