ListManager.Subtract

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

See Also

ListManager Object

All rights reserved.