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]
|