REMOVE BLANK LINE IN MAIL MERGE

N

Nancie

I am using Office 2007 and can't get see where to tell my mail merge (data is
a .csv file) to remove the blank line if no data exists. Does anyone know?
 
G

Graham Mayor

Although the old mailmerge helper, which contained that options is still
buried in the program, with that option, which may even still work (you can
add the command to the QAT (Quick Access Toolbar) ) the better way is to use
conditional fields eg

{Mergefield Fieldname1}{IF {Mergefield Fieldname2} <> "" "
{Mergefield Fieldname2}{IF {Mergefield Fieldname3} <> "" "
{Mergefield Fieldname3}{IF {Mergefield Fieldname4} <> "" "
{Mergefield Fieldname4}etc

Use CTRL+F9 for the field brackets if entering directly from the keyboard.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Justification function versus wide spaces 0
Mail Merge Directory Conditional Page Break 0
Mail Merge skipping records/sending one at a time 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Set as Default Template not working 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Replace Text with Merge Field vs. Insert Text with Merge Field 1

Top