Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2020, 07:15 AM
tinfanide tinfanide is offline Mail merge: strange comparison error Windows 7 64bit Mail merge: strange comparison error Office 2010 32bit
Expert
Mail merge: strange comparison error
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Mail merge: strange comparison error

Please see the attachments for the mail merge issue. The result expected by me should have been:

1A
...
1D
...
2C
...
3B
...
3D
...

But it turns out to be:

1A
... (1D added under 1A)
2C
...
3B
... (3D added under 3B as well)



I believe the error is caused by the comparison in the field codes (i.e. <>) but I couldn't figure out where the error is. If I make a change to the data,



1A --> F1A


The error disappears. Thanks for any help in advance!
Attached Files
File Type: docx overdue.docx (14.3 KB, 6 views)
File Type: xls overdue.xls (28.5 KB, 6 views)

Last edited by tinfanide; 07-04-2020 at 01:32 AM.
Reply With Quote
  #2  
Old 07-05-2020, 03:40 AM
tinfanide tinfanide is offline Mail merge: strange comparison error Windows 7 64bit Mail merge: strange comparison error Office 2010 32bit
Expert
Mail merge: strange comparison error
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

Self-solved by adding double quotation marks around Place1 and Place2.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Error mklindquist0815 Mail Merge 1 07-14-2017 08:36 PM
Mail merge: strange comparison error mail merge error in vba texas1014 Word VBA 2 03-08-2017 03:25 PM
vba error when trying to do a mail merge texas1014 Mail Merge 1 03-08-2017 03:23 PM
Mail merge: strange comparison error Error 5631 in Mail Merge DoctorNadir Mail Merge 7 12-16-2011 04:38 PM
Mail merge error? SRE Outlook 0 01-11-2010 05:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft