Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2015, 11:27 PM
acerview acerview is offline Suppress paragraph mark in mail merge field Windows 10 Suppress paragraph mark in mail merge field Office 2010 32bit
Novice
Suppress paragraph mark in mail merge field
 
Join Date: Dec 2015
Posts: 2
acerview is on a distinguished road
Default Suppress paragraph mark in mail merge field


Is it possible to suppress the paragraph mark in specific mail merge field?
That mail merge field was generated from a ".xlsm" excel file. In the cell of excel file, it shows that:
Code:
A
B
C
I would like to show it in the word file as:
Code:
A, B, C
Reply With Quote
  #2  
Old 12-22-2015, 03:13 AM
macropod's Avatar
macropod macropod is offline Suppress paragraph mark in mail merge field Windows 7 64bit Suppress paragraph mark in mail merge field 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

Word has no mailmerge fields (or other fields) that could remove such content from the mailmerge data - you need to change the data if you don't want to include its paragraph breaks in the mailmerge output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-22-2015, 06:57 PM
acerview acerview is offline Suppress paragraph mark in mail merge field Windows 10 Suppress paragraph mark in mail merge field Office 2010 32bit
Novice
Suppress paragraph mark in mail merge field
 
Join Date: Dec 2015
Posts: 2
acerview is on a distinguished road
Default

In my case, I am using the xlsm file as the database. Some files should use the following format as the caption
Code:
A
B
C
And some other documents should use the following format
Code:
A, B, C
in the content.

That's the reason why I would like to use "Replace" or "suppress".

Would any one please provide a solution? Thank you ^^
Reply With Quote
  #4  
Old 12-22-2015, 07:44 PM
macropod's Avatar
macropod macropod is offline Suppress paragraph mark in mail merge field Windows 7 64bit Suppress paragraph mark in mail merge field 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

What you want cannot be done via mailmerge. As I have already told you, the only way a mailmerge could produce the required output is by changing the data at the source. Your only other option is to edit the mailmerge output document after the data have been merged.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete paragraph base on merge field BenEWill Mail Merge 1 07-02-2014 02:52 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Suppress paragraph mark in mail merge field Suppress blanks in mail merge 0nyx175 Mail Merge 11 01-07-2014 02:45 PM
Suppress paragraph mark in mail merge field How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Suppress paragraph mark in mail merge field Easy mail merge but want to suppress rows ClaireAMAdams Mail Merge 5 04-30-2013 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:33 PM.


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