Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-25-2022, 08:34 AM
WordMonkey1 WordMonkey1 is offline Mail Merge Windows 10 Mail Merge Office 2010
Novice
Mail Merge
 
Join Date: Oct 2020
Posts: 3
WordMonkey1 is on a distinguished road
Default

I did review that thread and attempted to try what it said, and it didn't work.

I want to remove the line in the letter ONLY if the Status Cell says closed, but leave the line if it is empty.

Please note this is a memo so has hard coded wording infront of the merge field, and I would like the entire line clear if the status is closed.

Store # <Store #><Status> <--- if Status is CLOSED remove this entire line
Name <Name>
Address <Address>

Open Store
Store # 1234
Name Company Name
Address 458 Left Lane

Closed Store

Name Company Name
Address 135 Right Avenue
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Is there a way to do a mail merge type of addition of data after a mail merge has been done? mtandino Word 4 06-01-2021 02:00 PM
Mail Merge Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file sureshbvs Word VBA 1 03-12-2021 05:42 AM
Mail Merge Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:22 AM.


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