I have multiple records that I need to Mail Merge and each record has a comment field that is of a different length. I would like to get as many records on a page as possible. The number of total records is currently unknown (likely over 500) as is the length of a given record’s comment field. Below is a table with sample data.
| ID | Name | Comment |
|---|---|---|
| 1 | Joe | Res ipsum |
| 2 | Frank | Lorem ipsum dolor sit amet consectetur adipiscing elit. Quisque faucibus ex sapien vitae pellentesque sem placerat. In id cursus mi pretium tellus duis convallis. Tempus leo eu aenean sed diam urna tempor. Pulvinar vivamus fringilla lacus nec metus bibendum egestas. Iaculis massa nisl malesuada lacinia integer nunc posuere. Ut hendrerit semper vel class aptent taciti sociosqu. Ad litora torquent per conubia nostra inceptos himenaeos. |
| n | A | B |
Here is what my current Mail Merge looks like. As written, it puts each record on a separate page (not what I want).
Name: «Name»
«Comment»
