I use MailMerge with CSV file. The below is the format of CSV file.
SerialNo PledgeList
1 0001\t100\t200
So, my value PledgeList field includes \t . So, Header Record Delimiters Dialog appear to choose field delimiter manually. I have to choose field delimiter manually when opening mailmerge document. So, I would like to know how to do not to appear Delimiter Dialog Box to choose field delimiter manually Sample letter format is the following
«PAWNERNAME»
«ADDRESS»
Dear «PAWNERNAME»,
«PledgeList»
Yours Sincerely,
I want to include the Tab {PledgeList} in the below data
0001 TAB 1000 TAB 2000
This is a known problem described in a Microsoft Knowledge Base article: https://support.microsoft.com/en-us/kb/189014
In a nutshell, the solution is to duplicate the Headers line in the CSV file. This confirms the delimiter for Word and should suppress the dialog.
SerialNo PledgeList
SerialNo PledgeList
1 0001\t100\t200
HOWEVER: Word will not automatically interpret \t as a tab sign. It will insert the literal text. You'd need to perform a Find/Replace on the mail merge result. It might be better if you format your data as follows, where the space in the PledgeList is a tab character (ANSI 9):
"SerialNo" "PledgeList"
"SerialNo ""PledgeList"
"1" "0001 100 200"