Suppress blank line in mail merge

		Microsoft Office Forums > Microsoft Word > Mail Merge
Suppress blank line in mail merge

FAQ

Thread Tools

Display Modes

03-06-2022, 05:49 PM

macropod

Windows 10 Suppress blank line in mail merge

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Quote:

Originally Posted by BernieB

Another question: Is there a way to put the comma between City and Province somewhere else in case there is no City or Province?

You could conditionally insert the comma and its space into the Province output using the \b switch. See the Mailmerge Empty Space Suppression topic in the Mailmerge Tips & Tricks thread.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Making mail merge blank fill a line to highlight that line	rgm60527	Mail Merge	2	02-22-2022 11:13 AM
Suppress paragraph mark in mail merge field	acerview	Mail Merge	3	12-22-2015 07:44 PM
Suppress comma in "city , stat zip" line when blank	DHammer	Mail Merge	1	05-30-2014 02:43 AM
Suppress blanks in mail merge	0nyx175	Mail Merge	11	01-07-2014 02:45 PM
Easy mail merge but want to suppress rows	ClaireAMAdams	Mail Merge	5	04-30-2013 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 PM.