Hi, new poster. I'm trying to mail merge address info onto a envelope, but some of the cells on the excel fill has multiple line breaks and doesn't show up when I Mail merge and when I try to get rid of wrap text on the cells I end up with no spaces, I guess what I'm trying to ask is there a way to remove extra lines automatically or delete wrapping and have spaces inbetween instead of line breaks?
Although the source data can have a return in a cell, when saved/exported to a comma or tab delimited format for data merge, the return will result as a new record.
If the hard return is needed, here is a workaround. In Excel (or the data app that you are using) search and replace return with a unique character string, and do not include return. Perform the datamerge and create new document. Then search and replace the unique character string, replacing with a return.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices