Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2022, 08:35 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
Question Mail Merge

I have a workbook that has the following columns:

Store# | Name | Address | Store Information | Status

I want to use these fields to merge into a memo that looks like:

Store #
Name
Address



Store Information

Thank you .....

However, If the status column indicates that the Store is Closed, I want the merge document to remove the line of Store #, so that closed stores memos would look like this:

Name
Address

Store Information

Thank you .....

Is there a way to do this? Not sure if it would be the If...Then...Else statement or if I have to manually remove the Store # line for closed stores.
Reply With Quote
  #2  
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: 21,956
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
  #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
  #4  
Old 03-25-2022, 02:36 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: 21,956
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

The approach described in the Mailmerge Empty Line Suppression topic does work for your requirements.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 01:08 AM.


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