ListManager.Union
.gif "Ee784620.c++_on(en-US,CS.10).gif")
.gif "Ee784620.vb_off(en-US,CS.10).gif")
Use this method to produce a union of two mailing lists, placing the result in a third mailing list. A union is a combination of the two lists with any duplicates eliminated.
Definition
Sub Union(srcList As Variant,addList As Variant,resList As Variant,errLimit As long,bAsync As Boolean,Optional pvarOpID As Variant)
Parameters
srcList
A Variant that contains the ID or name of the source list.
addList
A Variant that contains the ID or name of the add list.
resList
A Variant that contains the ID or name of the list into which the results of the union operation will be placed.
errLimit
A Long that is not used.
bAsync
A Boolean that specifies whether the copy operation is performed synchronously or asynchronously. A value of True indicates asynchronous processing. A value of False indicates synchronous processing.
pvarOpID
An optional Variant used to return an Operation ID. This Operation ID is used in subsequent processing concerning this operation.
Error Values
This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to either standard or custom COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors.
The following table shows the custom COM errors that this method can return.
| Constant | Value | Description |
| E_LM_LIST_BUSY | &H8C400008 | The specified list is currently busy with another operation. |
| E_LM_LIST_IN_FAILED_STATE | &H8C40001D | The specified list is in a FAILED state and may not be used for the operation. |
| E_LM_LIST_NOT_FOUND | &H8C400006 | The specified list does not exist. |
| E_LM_MAILABLE_REQUIRED | &H8C400011 | The operation requires a mailable list and the specified list is not a mailable list. |
| E_LM_OPER_CANCELED | &H8C40000B | The operation was canceled. |
| E_LM_SQLERROR | &H8C400003 | Error while executing SQL/ADO operation. |
| OLE_E_BLANK | &H80040007 | The ListManager object has not been properly initialized. |
Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.
Remarks
The result list must exist prior to calling the method, however, any data in the list will be overwritten.
This method keys on the rcp_email column and thus, both the source (srcList parameter) and add (addList parameter) lists must be Mailable lists (LISTFLAG_MAILABLE set to True). All the records from the source list are copied to the result (resList parameter) list. All records from the add list that do not have duplicate e-mail addresses (rcp_email)**in the source list are also copied to the result list. Any existing data in the result list is deleted.
The parameter pvarOpID contains valid data only if the union operation is performed asynchronously.
For more information about memory ownership issues related to COM property and method parameters, see Managing COM Parameter Memory.
Example
oListManager.Union "{2B544800-4169-4C49-8713-1B794078B4C9}", _ "{454799A2-312B-4F5F-90A0-F514FBA0EC5A}", _ "{7131B794-5448-078B-B544-799A2311B79A}", 10, False