View Single Post
 
Old 11-05-2015, 04:04 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,385
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

You could try opening the text file in Excel, then use the text-to-columns feature to split the data at the ~ characters. Once you've done that, you can use the Excel file as your data source. If you use the same Excel file each time, your mailmerge also won't need to be re-connected to the data source each time.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote