1. Icloud Mail
2. Microsoft Word For Mac Mail Merge Avery Labels
3. Word 2011 For Mac Mail Merge Suppress Blank Lines 2010

Hello All, I am trying to work out how to supress a line field in the mail merge from being displayed in the event it has no associated data. Specific example. I have an aged debtors list in numbers going back 9 months lets say Jan-September. When I do the merge I get blank spaces for accounts that had no data say in months Jan-July leaving an unsightly space followed by the invoices from August at the bottom of the page.

Icloud Mail

In the generated document, if the merge field corresponding to the second line of the address does not have a value, a blank line may be present. In Microsoft Word, a blank line generated during a mail merge can be suppressed using application settings. Suppress blank lines in a list in a Word for Mac 2011 mail merge Using Office for Mac 2011. I am a beginner and thank all in advance for your assistance worded for a novice; ) I'm making a mail merge letter from an Exel spreadsheet for all our staff. The following are the codes for 3 consecutive fields in my Word mail merge. I've checked in the ISP's server and the only thing different about this e-mail to others is that there is no header information in the message. After the DATA smtp command there are no from:, to: lines. From InDesign Help: Remove Blank Lines For Empty Fields Remove paragraph returns inserted for empty fields. This is especially useful for mailings in which you have an optional address field. I am trying to send out a mass mail merge email to clients who are in an accreditation process. I am using an Excel spreadsheet in the merger, and in the datasheet if the client has taken a class I indicate it with the number of credit hours (so they can also be added up as part of the letter).

I can manually delete the spaces for each month with no date or divide the spreadsheet up by month - both of which are tedious. What I'd like is the ability to supress the field if no data is in numbers. For the life of me I can't work out a solution to what seems a fairly simple and common problem.

Microsoft Word For Mac Mail Merge Avery Labels

Thanks everyone, problem sorted. That is right Barry, there are 12 fields for each month with amounts and payments - so 48 fields in all with many empty. Jerrold's method would get rid of the blanks for just one field. How to change font on skype for mac. There is just no way to suppress blank lines dynamically with the Merge.

Word 2011 For Mac Mail Merge Suppress Blank Lines 2010

I finally solved this (as suggested by Yvan but I did not fully understand his comment at first) using brute force by replacing the 12 month fields (Jan-Dec) with First Invoice Date, Second Invoice Date etc. And built a separate Numbers table extracting just the pertinent data starting from the first invoice date, and following sequentially on by date. It would be so useful to have checkbox option on the merge command that just says: If data field is empty suppress line entirely leave blank field in place. Message was edited by: thomasthetomcat.

Download LogMeIn free from MacAppsPortal.com.• How do I access the free LogMeIn download for PC? Just click the free LogMeIn download button at the top left of the page. We recommend to download the latest version of LogMeIn because it has the most recent updates, which improves the quality of program.• How much does it cost to download LogMeIn? Logmein free download for mac.