Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-24-2018, 04:58 AM
Tom SheehaN Tom SheehaN is offline Windows 10 Office 2016
Novice
 
Join Date: May 2018
Posts: 1
Tom SheehaN is on a distinguished road
Default 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*DK8e>-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.
Attached Images
File Type: jpg GoodAndBackEditRecipients.jpg (138.6 KB, 4 views)
Attached Files
File Type: txt GOOD_SOURCE.txt (4.3 KB, 0 views)
File Type: txt BAD_SOURCE.txt (4.4 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 11:25 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft