![how to mail merge labels from excel to wordperfect how to mail merge labels from excel to wordperfect](http://techhelptoday.com/wp-content/uploads/2016/08/Mail-Merge-Confirm-Data-Source-2.png)
I have managed to do so, but some addresses are shorter than others, ie there is an empty field, which shows as a blank line in the middle of the address. I'm trying to create address labels from a spreadsheet.
#HOW TO MAIL MERGE LABELS FROM EXCEL TO WORDPERFECT HOW TO#
To do so, follow the steps in the How to Remap a Mail Merge Field section in this article Office 2010 Don't print blank lines when data fields are empt To work around this problem, manually remap the Mail Merge fields so that the Courtesy Title is mapped to the correct Mail Merge field. To do so, follow the steps in the How to Initiate a Mail Merge from Outlook 2003 section in this article. Place your cursor before the closing bracket and type: \# $,#.00 (There is a space between the first # and the $. I'm missing some little item in the syntax.
![how to mail merge labels from excel to wordperfect how to mail merge labels from excel to wordperfect](https://img.yumpu.com/53869280/1/500x640/using-wordperfects-merge-to-create-mailing-labels-from-a-quattro-pro-.jpg)
The condition that if the field contains two dashes (-) do not print anything is working, however it leaves an empty/blank line. IF fields and INCLUDETEXT fields) an In the Merge dialog box, under When Merging Records, click either: Don't print blank lines when data fields are empty I am getting blank lines with Mail Merge. spaces, tabs, manual line breaks) and in which all mergefields are blank does not occur when the field is nested inside another field (e.g. However, there are limitations: acts only on paragraphs that contain only mergefields and white space (e.g. Home How do I get rid of blank lines in mail merge Wordīy default, Word's mailmerge suppresses blank lines.