ListManager.Subtract
.gif "Ee784336.c++_on(en-US,CS.10).gif")
.gif "Ee784336.vb_off(en-US,CS.10).gif")
Use this method to subtract one mailing list from another mailing list, placing the result in a third list.
Definition
Sub Subtract(srcList As Variant,lessList 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 list from which elements will be subtracted.
lessList
A Variant that contains the ID or name of the less list.
resList
A Variant that contains the ID or name of the list into which the results of the subtraction 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 less (lessList parameter) lists must be Mailable lists (LISTFLAG_MAILABLE set to True). Records from the source list that do not have duplicate e-mail addresses (rcp_email)**in the less list are copied to the result (resList parameter) list. Any existing data in the result list is deleted.
The parameter pvarOpID contains valid data only if the subtraction 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.Subtract "{2B544800-4169-4C49-8713-1B794078B4C9}", _ "{454799A2-312B-4F5F-90A0-F514FBA0EC5A}", _ "{7131B794-5448-078B-B544-799A2311B79A}", 10, False