|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Special Characters Unexpectly Change during Mail Merge with HTML MergeSource
Hi,
I have a mail merge which is using a HTML file as the data source. In the file there are fields which contain a text string which is a code 128 encoded barcode something like: ÒÏ!%%Y/_n113%6*ÍDK8Ìe>Í-1fÓ In some circumstances this is being changed during the mail merge to メマ!%%Y/_n113%6*ヘDK8フe>ヘ-1fモ The characters which are substituted in are not in the Code128 Character set so the barcodes do not print correctly. This doesn't happen all the time. I took a working file and a non-working file and created a file with two records. If I put the record from the working file first both records are merged correctly, if I put the non-working record first then both records print incorrectly. I have included two sample files (GOOD_SOURCE and BAD SOURCE) which I needed to rename to txt files to be able to upload them here. The picture shows how these two files appear in the Edit Recipients screen. I've tried this in Word 2010 and Word 2016 with identical results. I think that because you can see the issue in the Edit Recipients screen this is happening when word is reading the data rather than doing the mail merge. I get the same results if I use a blank document, or if I use the formatted document. I guess Word must be investigating the first record and deciding to change the data for some reason. Any help with this will be greatly appreciated. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge using HTML Data Source | chadnewman | Mail Merge | 0 | 09-21-2017 07:14 AM |
Is there a simpler way to get the first 2 characters of a field to appear in a mail merge? | Kimu | Mail Merge | 4 | 03-24-2017 02:42 AM |
Mail merge to html not working | CRMCathy | Mail Merge | 2 | 02-17-2015 07:59 PM |
mail merge (more than 255 characters) | allenglishboy | Mail Merge | 9 | 03-05-2013 06:52 AM |
HTML Content in Mail Merge Field | Ilmater | Mail Merge | 1 | 09-04-2011 02:47 AM |