|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Good evening,
I'm facing a difficult(for my level as a mail merger) issue. I need to merge 800 letters -data from excel - to individuals referring to their accounts which remain unpaid. The fields which i have to merge are as the following: Section A [CUST_LAST_NAME] [CUST_FIRST_NAME], [Adress], [city], Postal Code[Postal Code],Social Security Number: [CUST_Social Security Number] and Section B Bla bla bla [CONTRACT_1], [CONTRACT_2], [CONTRACT_3] , [CONTRACT_4], [CONTRACT_5], [CONTRACT_6] bla bla bla bla. So, this is what i need to solve: In section A, i don't have data for every [CUST_Social Security Number], so when data cell in excel is blank, i have to remove the previous: " ,Social Security Number: " from the letter. In section B, i have [CONTRACT_1] for every letter but not 2-6 for everyone, so i have to remove all the following commas and spaces between mergefields and keep only one space. Any help please???? I've tried to delete commas between CONTRACTS from template and to update mergefield with \f ", " but the problem didn't solved because i don't want to have comma after the last CONTRACT Here is an example of the problem: Section A Alex Alexiou, Chalandri, Attica Greece, Postal Code 32100, Tax Number: In this section, i want to auto-remove the underlined text when Tax Number value is blank in my excel Section B Bla bla bla bla bla bla01188204, 01188205, 01188206, blabla bla bla In this section, i want to eliminate the comma after the last CONTRACT number (i have a range 1-6 contract numbers) |
#2
|
||||
|
||||
See Mailmerge Empty Space Suppression in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: Mailmerge Tips & Tricks
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you for your reply!
I have seen the Thread before the post but it is quite difficult for me to understand how to combine the switches in order to suppress the last comma from my letter. Could you please give me an example for my problem? S.O.S Kind regards Alex |
#4
|
||||
|
||||
For example:
{MERGEFIELD CONTRACT_1}{MERGEFIELD CONTRACT_2 \b ", "}{MERGEFIELD CONTRACT_3 \b ", "}{MERGEFIELD CONTRACT_4 \b ", "}{MERGEFIELD CONTRACT_5 \b ", "}{MERGEFIELD CONTRACT_6 \b ", "}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thank you very much!! You solved my problem!!
You are such a great person! Thank you again and i wish all the best for Australia! |
Tags |
macropod |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to remove almost a full page of blank space in between Word table rows | garrisonsdad | Word Tables | 4 | 10-18-2018 09:09 PM |
Why when I paste text into word, blank space appears after a paragraph & I can't delete it? | AWD | Word | 3 | 10-16-2018 01:10 PM |
Cannot delete blank space appearing in footnotes in MS word for Mac 16 | Ermmmmmm2222777*** | Word | 1 | 09-19-2017 04:54 AM |
Significant Blank Space At Top Of Page When Records Merged 1 Per Page | JennEx | Mail Merge | 18 | 05-05-2017 05:33 AM |
Blank space at top of page | Vecchia | Word | 4 | 12-26-2014 07:44 AM |