Microsoft Office Forums Mail Merge - Bullets and Enter

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2018, 11:37 AM
RMerckling RMerckling is offline Mail Merge - Bullets and Enter Windows 7 64bit Mail Merge - Bullets and Enter Office 2010 32bit
Novice
Mail Merge - Bullets and Enter
 
Join Date: Jan 2018
Posts: 29
RMerckling is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-22-2018, 12:35 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge - Bullets and Enter Windows 10 Mail Merge - Bullets and Enter Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,757
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

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)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-27-2018, 10:02 AM
RMerckling RMerckling is offline Mail Merge - Bullets and Enter Windows 7 64bit Mail Merge - Bullets and Enter Office 2010 32bit
Novice
Mail Merge - Bullets and Enter
 
Join Date: Jan 2018
Posts: 29
RMerckling is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 03-27-2018, 01:39 PM
macropod's Avatar
macropod macropod is online now Mail Merge - Bullets and Enter Windows 7 64bit Mail Merge - Bullets and Enter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,482
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Although the bullets may disappear from the field coding, properly implemented they will re-appear when the merge is executed.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-28-2018, 07:24 AM
RMerckling RMerckling is offline Mail Merge - Bullets and Enter Windows 7 64bit Mail Merge - Bullets and Enter Office 2010 32bit
Novice
Mail Merge - Bullets and Enter
 
Join Date: Jan 2018
Posts: 29
RMerckling is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 03-28-2018, 02:08 PM
macropod's Avatar
macropod macropod is online now Mail Merge - Bullets and Enter Windows 7 64bit Mail Merge - Bullets and Enter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,482
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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:
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa.{IF{MERGEFIELD Bullet1}<> "" "
Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna."}
• Nunc viverra imperdiet enim.¶
• Fusce est.¶
• Vivamus a tellus.¶
Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Mauris et orci.¶
with the paragraph break within the mergefield (i.e. ) formatted as per the paragraph's own Style and the one following the mergefield (i.e. ) formatted with the bullet.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
bullet, enter, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Bullets and Enter 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
Mail Merge - Bullets and Enter How to interchange from numbered bullets to bullets ep2002 Word 8 11-05-2013 06:53 AM
Mail Merge - Bullets and Enter Enter + Alt + Enter is not working inside the text box! why???? Jamal NUMAN Word 3 04-17-2011 05:35 PM


All times are GMT -7. The time now is 04:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft