#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
The approach described in the Mailmerge Empty Line Suppression topic does work for your requirements.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 - Create seperate Mail merge pdf for each sheets of an excel file | sureshbvs | Word VBA | 1 | 03-12-2021 05:42 AM |
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 |