Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2020, 10:28 PM
RM1984 RM1984 is offline Formatting bold when last line of address Windows 10 Formatting bold when last line of address Office 2019
Novice
Formatting bold when last line of address
 
Join Date: Jan 2020
Posts: 1
RM1984 is on a distinguished road
Default Formatting bold when last line of address

Hi


I am trying to create a document that merges an address and I want the final line of the address to be formatted in bold.

This is an example of my merge fields
«Contacts_Client_MAILING_NAM»
«Contacts_Client_Mortgagee_MAILING_ADD»
«Contacts_Client_Mortgagee_MAILING_ADD1»
«Contacts_Client_Mortgagee_MAILING_ADD2»
«Contacts_Client_Mortgagee_MAILING_ADD3»

The issue I have is that some client addresses in the database will only have address line 1, others line 1 and 2, others line 1, 2 and 3.

Is there a way I can get it to bold whichever line happens to be the last line of the address?

Thanks
Reply With Quote
  #2  
Old 01-07-2020, 12:02 AM
macropod's Avatar
macropod macropod is offline Formatting bold when last line of address Windows 7 64bit Formatting bold when last line of address Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try a field constructed as:
{IF«Contacts_Client_Mortgagee_MAILING_ADD1»= "" «Contacts_Client_Mortgagee_MAILING_ADD» "«Contacts_Client_Mortgagee_MAILING_ADD»↵
{IF«Contacts_Client_Mortgagee_MAILING_ADD2»= "" «Contacts_Client_Mortgagee_MAILING_ADD1» "«Contacts_Client_Mortgagee_MAILING_ADD1»↵
{IF«Contacts_Client_Mortgagee_MAILING_ADD3»= "" «Contacts_Client_Mortgagee_MAILING_ADD2» "«Contacts_Client_Mortgagee_MAILING_ADD2»↵
«Contacts_Client_Mortgagee_MAILING_ADD3»"}"}"}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field constructions are all required. Instead of the ↵ symbols, you should use real line/paragraph breaks.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting bold when last line of address How to bold a whole line in Word based on a word or character on the line Yancx Word 6 03-21-2018 04:48 PM
Bold each line of text that starts with a recurring symbol qubie Word 6 08-26-2016 07:10 AM
Format Bold in one line makes all lines bold Nitte Word 2 02-07-2013 12:34 AM
Formatting bold when last line of address Making Line Bold janith Word VBA 5 05-30-2012 04:04 PM
Formatting bold when last line of address How to automate BOLD in a line madbrit Word 5 07-02-2011 06:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:32 AM.


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