Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-18-2020, 10:33 AM
Alex1s85 Alex1s85 is offline Delete comma and space after blank merged value. Also remove Previous space and word before blank Windows 10 Delete comma and space after blank merged value. Also remove Previous space and word before blank Office 2016
Advanced Beginner
Delete comma and space after blank merged value. Also remove Previous space and word before blank
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default

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)


Reply With Quote
  #2  
Old 01-18-2020, 01:52 PM
macropod's Avatar
macropod macropod is offline Delete comma and space after blank merged value. Also remove Previous space and word before blank Windows 7 64bit Delete comma and space after blank merged value. Also remove Previous space and word before blank Office 2010 32bit
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

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]
Reply With Quote
  #3  
Old 01-18-2020, 02:18 PM
Alex1s85 Alex1s85 is offline Delete comma and space after blank merged value. Also remove Previous space and word before blank Windows 10 Delete comma and space after blank merged value. Also remove Previous space and word before blank Office 2016
Advanced Beginner
Delete comma and space after blank merged value. Also remove Previous space and word before blank
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 01-18-2020, 09:59 PM
macropod's Avatar
macropod macropod is offline Delete comma and space after blank merged value. Also remove Previous space and word before blank Windows 7 64bit Delete comma and space after blank merged value. Also remove Previous space and word before blank Office 2010 32bit
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

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]
Reply With Quote
  #5  
Old 01-18-2020, 11:30 PM
Alex1s85 Alex1s85 is offline Delete comma and space after blank merged value. Also remove Previous space and word before blank Windows 10 Delete comma and space after blank merged value. Also remove Previous space and word before blank Office 2016
Advanced Beginner
Delete comma and space after blank merged value. Also remove Previous space and word before blank
 
Join Date: Oct 2019
Location: Thessaloniki, Greece
Posts: 30
Alex1s85 is on a distinguished road
Default

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!
Reply With Quote
Reply

Tags
macropod

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete comma and space after blank merged value. Also remove Previous space and word before blank 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
Delete comma and space after blank merged value. Also remove Previous space and word before blank 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
Delete comma and space after blank merged value. Also remove Previous space and word before blank Cannot delete blank space appearing in footnotes in MS word for Mac 16 Ermmmmmm2222777*** Word 1 09-19-2017 04:54 AM
Delete comma and space after blank merged value. Also remove Previous space and word before blank Significant Blank Space At Top Of Page When Records Merged 1 Per Page JennEx Mail Merge 18 05-05-2017 05:33 AM
Delete comma and space after blank merged value. Also remove Previous space and word before blank Blank space at top of page Vecchia Word 4 12-26-2014 07:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 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