entering data in separate rows within a cell

[drsuis]

I am creating a mail database and need to have the ability to paste different rows of data from Word into a single cell in Excel. Right now when I paste the data in Excel, it enters it into separate cells. Any help will be greatly appreciated.

[macropod]

This appears to be related to https://www.msofficeforums.com/mail-...ail-merge.html. I suggest you deal with the problem at its source, rather than trying to work around it.

FWIW, you also don't necessarily need to convert the data to Excel. A Word mailmerge can also use another Word document as a datasource.