MailMerge from txt file - failing when the file path contains a reserved SQL word

travb81 · #1 10-18-2018, 12:12 AM

Hiya,

I've got some VBA code that pulls some records from a database, throws them into a tab separated .txt file, and then sets up a mailmerge to that text file.
Works fantastically!

Except....
I've just been hunting for a glitch that occurred today. I've worked out that the file path contained the word 'where' in it.
eg "C:\Jobs\Timber where missing\"

Code:

        strPath = ActiveDocument.Path & "\MailMerge.txt"
        ActiveDocument.MailMerge.OpenDataSource strPath, , , True, False
        ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False

Any suggestion on how I can get around this?
I'm guessing this is because WHERE is an SQL reserved word...
If I manually do the mail merge, i get an SQL error. See image below.

I've tried to put ' or " at the start and finish of the strPath variable. No good.

The only work around is to rename the folder.
This isn't ideal - as if i go down this line, there are probably other SQL keywords that will cause problems.

Any suggestions for this unique situation?....
It is kind of a Microsoft Glitch / Bug...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Putting path and file name into all Word documents	Kevin Beach	Word	3	11-26-2016 06:14 PM
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
get file name without Path	Ziggy1	Word VBA	1	09-29-2006 07:55 PM