Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2022, 02:14 PM
macropod's Avatar
macropod macropod is offline Mail Merge Windows 10 Mail Merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,382
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


Did you look in the Mailmerge Tips & Tricks 'Sticky' thread (https://www.msofficeforums.com/mail-...ps-tricks.html) at the top of this forum? Your question is ansered there.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
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
Reply



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:45 PM.


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