#1
|
|||
|
|||
Mail Merge - Bullets and Enter
Hi all,
I've got a bulleted list and I want to add a few additional bullets if the field is not empty within a mail merge. If I place the bullets in and add the mail merge fields, if the fields are empty that get merged in, the bullets are still there with no data. I can manually enter a bullet with alt-0149 after \b in the field code but the bullet is small and doesn't look clean at all or match the other bullets in the list. Also, after the first bullet, I need 3 additional bullets that are indented. Any help would be greatly appreciated Thanks, Rich |
#2
|
||||
|
||||
If you are using an automatic bulleted style, put the conditional field at the end of the previous bulleted line, after the paragraph break e.g.
end of bulleted line¶ { IF { MERGEFIELD fieldname } <> "" then "¶ { MERGEFIELD fieldname }" }¶ Next bulleted line .....¶ where ¶ indicated a paragraph break entered from the keyboard by pressing the enter key. Then format the paragraph break at the end of the bulleted line before the conditional field as hidden.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Graham, thanks for the reply.
However, this doesn't seem to work for me. When I have my IF statement and hit Enter within quotes, the bullet for that line goes away. • end of bulleted list { IF { MERGEFIELD fieldname } = "" "" "¶" (once I hit ¶ at the end of this statement, the • before "end of bulleted list" disappears) also, I have the IF statement on this line opposed to the next because if I start it on the next line, then the bulleted list will have an empty bullet at the end if the field is blank. Any ideas? Thanks. |
#4
|
||||
|
||||
Although the bullets may disappear from the field coding, properly implemented they will re-appear when the merge is executed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Hey Paul, maybe I'm missing something?
After writing in the code for these lines I only get a bullet on the very last line. If I have separate statements, I get bullets for each line but they don't go away if the fields are blank. |
#6
|
||||
|
||||
The implementation is perhaps counter-intuitive. What you need to do is to attach the field code for the conditional bulleted paragraph to the preceding paragraph:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Hello there. I am also facing pretty much the same situation as the original poster. I was unable to comprehend what are you implying by your last comment. Please post an elaborate explanation if possible.
|
Tags |
bullet, enter, mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Mail Merge is Deleting objects in my header and footer during the merge | bgranzow | Mail Merge | 9 | 06-05-2015 05:03 AM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
How to interchange from numbered bullets to bullets | ep2002 | Word | 8 | 11-05-2013 06:53 AM |
Enter + Alt + Enter is not working inside the text box! why???? | Jamal NUMAN | Word | 3 | 04-17-2011 05:35 PM |