Module: Form_Contract Mail Merge

Type: Form
Lines of Code: 401
Source: ms_access_files\garnet\Forms\Frm Contract Mail Merge.txt

Dependencies

Module Dependencies: - QryRecSet - Actdatabase - EntRecSet - RecSet

Tables Accessed: - Qry - QryRecSet - Commitment - Contract - Temp - Email - the

Forms Referenced: - Frm

External References: - Excel.Application

Type: Public Sub
Lines: 20

Calls: UpdateNumber, OpenRecordset

Type: Private Sub
Lines: 19

Calls: DeleteRecs_Click, Column, Selected

Type: Private Sub
Lines: 296

Calls: Year, SendOutlookMessage, Dir, Month, Cells, OpenRecordset, DoTheExport_Click, Columns, Worksheets, Workbooks (+3 more)

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ Large procedure (296 lines)

Type: Private Sub
Lines: 13

Calls: CloseFOrm_Click

Complexity Notes: - ⚠️ Contains GoTo statements

Type: Private Sub
Lines: 7

Calls: IsLoaded, Form_Close

Type: Private Sub
Lines: 35
Parameters: Cancel As Integer

Calls: Fields, Form_Open, OpenRecordset