const mytemplate = "My Pages Template"  // change to your template name

const cols = {fname:"B", lname:"A", mname:"C", street1:"D", street2:"E", 
              city:"F", state: "G", code:"H", salut:"I", usr1:"J", usr2:"K"};

             // change column letters between " " above to match Numbers table

Object.keys(cols).forEach(key => cols[key]="ABCDEFGHIJK".indexOf(cols[key]));
             // "A" offset 0, "B" offset 2, "C" offset 3, etc.

const pages = Application("Pages"), 
      t = pages.templates[mytemplate],
      table = Application("Numbers").documents[0].activeSheet.tables[0],
	  notNull = value => value !== null; //function used in filter()

for(let i=1;i<table.rowCount();i++) {

    let rv = table.rows[i].cells.formattedValue(); // get formatted values for row
	
	// name address block
	let name = [rv[cols.fname],rv[cols.mname],rv[cols.lname]].filter(notNull).join(" ");
	let street = [rv[cols.street1],rv[cols.street2]].filter(notNull).join("\n");
    let ctystcode = [[rv[cols.city], rv[cols.state]].join(", "),rv[cols.code]].join(" ");
	let nameaddr = [name,street,ctystcode].join("\n");

	// if remove these, also remove set() below, and placeholder(s) in Pages template
	let salutation = rv[cols.salut];
	let amount = rv[cols.usr1];
	let date = rv[cols.usr2];
	
	// make new doc from template and fill in placeholders
	let doc = pages.Document({documentTemplate:t}).make();
	doc.placeholderTexts[0].set(nameaddr); 
	doc.placeholderTexts[0].set(salutation); // 0 as now 1st placeholder
	doc.placeholderTexts[0].set(amount); // ditto
	doc.placeholderTexts[0].set(date); // ditto
	//doc.print();  // when ready to print, uncomment (remove first set of //)
	
	//pages.activate(); // uncomment if want Pages to pop up in front
    //doc.delete(); // uncomment to delete each doc after print
	//doc.close();  // uncomment for prompt to save each document during printing
}