Hello-
We do several events per year where I need to create a roster using participant's info-name, compnay, address, phone email etc. that is collected in Excel. Now the easiest way to make a roster is to do a mail merge using labels. The only thing is, while the data comes out in columns, which I want, it reads across the page like this:
|
Jane Doe 123 street city, state zip |
John Johnson 456 street city, state zip |
Mary Smith
789 street city, state zip |
instead of down the column, like this: Any suggestions/advice would be much appreciated.
|
Jane Doe 123 street city, state zip |
|
John Johnson 456 street city, state zip John Johnson |
| Mary Smith
789 street city, state zip |