Kindly delete this please

Kindly delete this please

Consider using the Mail Merge option in Word ("Mailings") to generate a list of the BANK sheets

The WORD document is the same format as the BANK tab where you assign fields (Column Headings in Excel sheet) to the Word "template". You then pass a file of records to WORD which generates a letter per page,

Kindly delete this please

See attached

The Excel file has sheet "MM" with several rows of data: this used by the WORD mail merge.

Save Excel file (on Desktop for ease), then open Word document. Reply "no" to form that appears.

In WORD document, click "Mailings".."Select Recipients" >>"Use existing list" --Select Excel file and then sheet "MM""

"Edit Recipient List" to include first few records then "Preview Results""

You can of course add details of the recipient of the letter: I didn't do this but it just means adding more fields in the "MM" sheet and adding these into the Word template.

You may (will!) need to reformat the Word document as I simply copied and pasted the Excel "Bank" sheet.

Kindly delete this please

You a very welcome. Come back to the forum if you need further help.