SendEmail.dll

Contents Show

The SendEmail.dll is used to send predefined e-mail messages. E-mail messages are predefined per system. The SendEmail.dll uses the mapiSession and mapiMessage controls provided with Visual Basic to facilitate the sending of the e-mail messages. An e-mail client profile must be setup on the computer that the SendEmail.dll runs on for it to work.

There are two database tables that support the sending of the e-mail message. These tables will contain the information needed to send the e-mail message and will be predefined and somewhat static in content. The tables are:

EMAILCONTENT Table

The EMAILCONTENT table contains the information needed to build the content portion of the e-mail message. The following columns are in the EMAILCONTENT table:

Column

Description

SystemName

Primary Key

Subject

Subject line for the E-mail Message

Priority

Importance Level for the E-mail Message

0 - Low importance

1 - Normal importance

2 - High importance

MessageContent

E-mail message text

EMAILRECIPIENT Table

The EMAILRECIPIENT table contains the recipient information needed to send the e-mail message. The following columns are in the EMAILRECIPIENT table:

Column

Description

SystemName

Primary Key

E-mail

Recipient e-mail address

RecipientName

Display name for the Recipient

RecipientType

Distribution type for Recipient

1 - To recipient

2 - Copy recipient

3 - Blind copy recipient

To use the SendEMail.dll, you must do the following.

0 - attachment is a data file.

1 - attachment is an embedded OLE object.

2 - attachment is a static OLE object.

|

Scheduled Job Administration