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

Thread Tools
Display Modes


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 05:30 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