10-25-2016 07:23 AM
If you're doing a mail merge in ACT to send out some letters via Microsoft Word, but some of the contacts have a blank field, how do you prevent a subsequent blank line from appearing in your letters for those contacts that don't have any info for a particular field?
For example, with the code shown below:
<Business Line 1>
<Business Line 2>
the Microsoft Word letters for those contacts that have no info in the <Business Line 2> field will then have a blank line in their letter. Is there a way to avoid this blank line from appearing in the letter? Am really just looking to tidy up the letters that are created via a mail merge.
10-25-2016 09:29 AM
There is no login in word to suppress a blank field, nor is there the ability to concatenate (combine) fields.
So the best work around I would have for you would be to remove the line break after business line 1 and just put it in 1 line.
So in the case the following
123 Eldridge Road
would just be
123 Eldridge Road Unit B
Not perfect, but a work around
10-26-2016 02:51 AM
Thanks for your reply and the suggested workaround.
Yes, it looks like one of these things that can't really be avoided.
I thought I did see a solution to this problem on this forum a few months ago, but maybe I just dreamt it!
10-26-2016 04:38 AM
10-26-2016 04:43 AM
This needs to be fixed for all current versions too because it's too basic not to be ignored !!
10-26-2016 04:56 AM
10-26-2016 05:48 AM - edited 10-26-2016 06:27 AM
Hi Gary and David,
Somebody suggested a possible solution to this problem back in 2008:
I don't know if it works, though. UPDATE: just tried what Jeff Granger suggested (i.e. hitting the 'return' key), but the unwanted line break still appears in the letters.
10-26-2016 01:54 PM
Could you provide your full Act! version number (from Help > About Act!), and also the version of Microsoft Office you are using?
The specific defect Gary refers to only occurs when two concurrent mail merge fields are blank. Single blanks should collapse correctly but I'd like to retest using matching Act! and Word versions.
10-27-2016 03:21 AM
I just wonder what happens if you change all addresses to the standard contact addresses rather than a mix of Business and Contact addresses.
10-27-2016 05:18 AM
Thanks for your message.
It's Act! Premium Version 126.96.36.199 (Update 2), and it's Microsoft Word 2013.