Formatting custom data type in mail merge.

macropod · #4 03-06-2022, 03:14 PM

Quote:

Originally Posted by ianpg56

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

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to do a mail merge type of addition of data after a mail merge has been done?	mtandino	Word	4	06-01-2021 02:00 PM
Mail merge type fields in publisher	TerryTunesmith	Publisher	1	02-12-2020 08:14 PM
Mail Merge type is not being retained as ‘letter’ when document copied from one location to another	milnor	Mail Merge	4	01-30-2019 01:37 PM
Mail Merge Document Type	craigj	Mail Merge	2	10-03-2016 08:39 PM
Custom Mail Merge	luke	Mail Merge	1	04-09-2013 03:10 PM