Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-26-2018, 04:00 AM
macropod's Avatar
macropod macropod is offline MailMerge from txt file - failing when the file path contains a reserved SQL word Windows 7 64bit MailMerge from txt file - failing when the file path contains a reserved SQL word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I have no idea what the character limit for SQLStatement1 might be; all I said is that no limit is specified. Assuming both are limited to 255 characters, you might explore the possibility of optimising the SQL code or even using field coding within the mailmerge main document to achieve the same outcome.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge from txt file - failing when the file path contains a reserved SQL word Putting path and file name into all Word documents Kevin Beach Word 3 11-26-2016 06:14 PM
MailMerge from txt file - failing when the file path contains a reserved SQL word Determining file path for linked image in Word 2007 samhdc Word 7 01-26-2015 04:21 PM
Display Full File Path Name of Document in Title bar MS-Word 2010 Carlos06x Word 1 10-12-2011 10:39 AM
Programmatically get File Path for currently opened WORD document franferns Word 1 11-26-2009 12:36 PM
MailMerge from txt file - failing when the file path contains a reserved SQL word get file name without Path Ziggy1 Word VBA 1 09-29-2006 07:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:38 AM.


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