Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2022, 11:02 AM
Kalü Kalü is offline Split Data from Mergefield into seperate rows Windows 10 Split Data from Mergefield into seperate rows Office 2010 32bit
Advanced Beginner
Split Data from Mergefield into seperate rows
 
Join Date: Apr 2018
Posts: 43
Kalü is on a distinguished road
Default Split Data from Mergefield into seperate rows


Hey there,

I have a mailmerge document which creates a single table for each client.

In row 14 there is one Mailmerge field called Partners. There are many names sepreated by commata. Is it possible to split these names into rows (one row for each name) so that word creates automatically new rows?

I tried it with vba and macro recording but nothing is working out reliable and im so sad right now because i have to do this work every week all manually -.-
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Split Data from Mergefield into seperate rows Delete blank table rows in merged document and split document in docx and pdf based on excel rows Alex1s85 Word VBA 5 05-22-2021 12:05 PM
Split data in cells and duplicate rows ballpoint Excel Programming 6 02-07-2018 05:52 PM
Split Data from Mergefield into seperate rows Blank Rows in Table populated through Conditional IF statemement MergeField options in Word gideonpm Mail Merge 3 12-22-2016 01:20 PM
Macro Winword mailmerge split printpage with mergefield as filename pca Word VBA 2 02-28-2014 02:43 PM
Can I do this? sorting data in seperate columns shumonsaha Excel 0 07-04-2010 03:05 AM

Other Forums: Access Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft