title: Using the .Restrict method in Outlook VBA to filter on single recipient email address
body: <p>I have code in Access that gets all emails in the user's Inbox that are sent by an individual email address. This code (simplified, below) works fine:</p>
  
  <pre><code>Dim outItems as Outlook.Items
  Dim strEMAddress as string
  Dim outFolder as Outlook.MAPIFolder
  
  Set outFolder = outNS.GetDefaultFolder(olFolderInbox)
  Set outItems = outFolder.Items
  
  str="my@email.com"
  
  Set outItems = outItems.Restrict("[SenderEmailAddress] = " &amp; "'" &amp; strEMAddress &amp; "'")
  </code></pre>
  
  <p>I am looking for something that will do likewise on the SentMails folder, restricting the items to those sent to a specific email address.</p>
  
  <p>I know this is complicated by the fact that .Recipients is a collection (as items can/do have more than one recipient).  I am hoping there is a way to return a list of items that contain the email address I am looking for in any of the sent fields (To/CC/bcc - but happy with just To if this is easier).</p>
  
  <p>I have searched online and found .To is no good (is not the email address) and I can't get pseudo code such as this work:</p>
  
  <pre><code> Set outItems = outItems.Restrict("[Recipients] = " &amp; "'" &amp; strEMAddress &amp; "'")
  </code></pre>