Databases
StackOverflow2013
Postsdbo
POForce the `Recipients` object to update when the To: text box has been edited
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POForce the `Recipients` object to update when the To: text box has been edited
    primarykey
    data
    text
    <p>I sort recipients when composing an email.</p> <p>If I have 3 recipients (for example), run the sort macro, and then remove a recipient from the To: text box, running the macro a second time causes the removed recipient to re-appear. When I step through the macro on the second run, I can see that both <code>.CurrentItem.To</code> and the <code>Recipients</code> object still have all 3 recipients.</p> <p>It is intermittent. Is there any way to force the <code>Recipients</code> object to update when the To: text box has been edited?</p> <p>I can't find anything in the <a href="http://msdn.microsoft.com/en-us/library/aa210995%28v=office.11%29.aspx" rel="nofollow noreferrer">Outlook VBA documentation</a> and trial and error has proved fruitless.</p> <p>Code excerpt:</p> <pre class="lang-vb prettyprint-override"><code>Public Sub SortRecipients() With Application.ActiveInspector If TypeOf .CurrentItem Is Outlook.MailItem Then Debug.Print "Before: " Debug.Print "To: " &amp; .CurrentItem.To Debug.Print "# of recipients: " &amp; .CurrentItem.Recipients.Count ' Force an update if recipients have changed (DOESN'T HELP) .CurrentItem.Recipients.ResolveAll Set myRecipients = .CurrentItem.Recipients ' Create objects for To list Dim myRecipient As recipient Dim recipientToList As Object Set recipientToList = CreateObject("System.Collections.ArrayList") ' Create new lists from To line For Each myRecipient In myRecipients recipientToList.Add myRecipient.Name Next ' Sort the recipient lists recipientToList.Sort ' Remove all recipients so we can re-add in the correct order While myRecipients.Count &gt; 0 myRecipients.Remove 1 Wend ' Create new To line Dim recipientName As Variant For Each recipientName In recipientToList myRecipients.Add (recipientName) Next recipientName .CurrentItem.Recipients.ResolveAll End If End With End Sub </code></pre> <h2>Steps to reproduce:</h2> <ol> <li>Add 4 recipients to the "To" line of a new email in Outlook 2007 (click "Check Names" to resolve the addresses.)</li> <li>Run the SortRecipients macro. (Recipients are now sorted)</li> <li>Delete one recipient, re-run the SortRecipients macro.</li> <li>After doing this, I still have 4 recipients (the deleted one returns).</li> </ol>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USjjeaton
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POForce the `Recipients` object to update when the To: text box has been edited
      1. USjjeaton
      1. VTFavorite
    2. VO
      singulars
      1. POForce the `Recipients` object to update when the To: text box has been edited
      1. USjjeaton
      1. VTBountyStart
    3. VO
      singulars
      1. POForce the `Recipients` object to update when the To: text box has been edited
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI use outlook 2010 and your code works without problems (except for an odd 'end if' below recipientToList.Add myRecipient.Name that is probably a leftover from copying your code excerpt and causes a compile error.
      singulars
      1. POForce the `Recipients` object to update when the To: text box has been edited
      1. USEddy
    2. CO@eddy, fixed the code. Added tag for Outlook 2007. I am trying this on Outlook 2007, which is where it needs to work. Did you delete a recipient, and re-sort? It sorts fine, just re-adds the deleted recipients when running again after the sort.
      singulars
      1. POForce the `Recipients` object to update when the To: text box has been edited
      1. USjjeaton
    3. COYes I sorted, removed and ran macros again. It worked for me. Don't have 2007 around anymore so can try it there
      singulars
      1. POForce the `Recipients` object to update when the To: text box has been edited
      1. USEddy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload