by Jonathan Adams (1 Submission)
Category: Microsoft Office Apps/VBA
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (5 Votes)
The code will allow you to pass a template name and a recordset to ONE routine and this will then create you a Word Mail Merge document based upon the selected template. If no template is found then a blank file is created
Now upated to include ALL code required to run ;)
Inputs
Usage :-
Dim iobj_word as cls_wrd_report_manager
Set iobj_word = New cls_wrd_report_manager
rs_data =the recordset to output
s_report_path :=Patha and filename of template document
b_Print := True or Fales (Print or Show)
Call iobj_word.produce_mail_merge(rs_data, s_report_path, b_Print)
Code Returns
A Boolean value for success or failure
Download Creating a Word Mail merge document using a Record set (8 KB)