I would like an Excel (VBA) macro that merges select Excel records with a PDF Form and sends to printer, and optionally saving the PDF file(s). Saved file(s) to be given unique, sequentially numbered filename(s).
Fieldnames to be derived from left-most contiguous cells of first row of worksheet.
Record(s) to print to be a choice of a) 'All Records'; or b) 'Selected Records'. If 'All Records' is chosen, it is to be assumed that the first record is Row 2 and the last record is the last contiguous row with data in Column 1.