View Single Post
 
Old 03-06-2022, 03:14 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Quote:
Originally Posted by ianpg56 View Post
I have a merge field in a tab delimited csv file that is of the format ["element 1", "element2"] from 0 to 12 elements
CSV files have Comma-Separated Values. A tab-delimited file is not a CSV file, no matter what extension you give it.
Quote:
Originally Posted by ianpg56 View Post
An example of the field in the csv would be <field separator tab>["element 1", "element2"]<field separator tab>
Evidently, then, you data are coming from some other system. You should get whoever produces the data to output in a format that is suitable for mailmerge. Alternatively, pre-process that data so it's suitable for mailmerge. That would require all 12 elements to be catered for in each record, even if empty.

Your ["element 1", "element2"], etc. do not constitute custom data types - in a tab-delimited file they are a single piece of data and, with the double-quotes, are liable to mess up a mailmerge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote