Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-24-2021, 11:19 PM
zlick47 zlick47 is offline Remove Lines (mixed with non-merge information) Windows 10 Remove Lines (mixed with non-merge information) Office 2019
Novice
Remove Lines (mixed with non-merge information)
 
Join Date: Jul 2021
Posts: 1
zlick47 is on a distinguished road
Default Remove Lines (mixed with non-merge information)

I have tried uploading the relevant files, but the Word file that I wish to use as the destination for Mail Merge is too big (1.17MB).



Therefore, I will describe the situation the best I can:

On my destination Word document, which is pulling into its merge fields information from an Excel file, there are lines that look like this:

<<item>> of a <<appearance>> weighing approximately <<grams1>> grams.

There are ten rows like this, but some are empty in the Excel source file. The result is that when fields in the Excel file are left blank, I get something like this after merging:

Time Stone of a perfect appearance weighing approximately 35 grams.
<<item2>> of a <<appearance2>> weighing approximately <<grams2>> grams.
<<item3>> of a <<appearance3>> weighing approximately <<grams3>> grams.
.
.
.
.
<<item10>> of a <<appearance10>> weighing approximately <<grams10>> grams.

I want it to delete the extra lines that pull from empty Excel rows, but because there is text on the lines that does pull from a source cell on Excel, I cannot figure out a way to do it.

Can anyone offer any suggestions?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Lines (mixed with non-merge information) How can I remove these lines? TonyT Word 3 10-07-2019 06:07 PM
Remove Lines (mixed with non-merge information) Remove table lines gogreen Word 4 02-02-2018 03:14 PM
Remove Lines (mixed with non-merge information) dotted lines under text -- how to remove? Straitsfan Word 1 11-11-2013 11:55 AM
Remove Lines (mixed with non-merge information) remove blank lines in between jolinchew Excel 4 08-01-2013 06:09 AM
Remove Lines (mixed with non-merge information) how to remove two lines? mryevrah Word 2 05-05-2011 01:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.


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