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

travb81 · #1 10-21-2018, 04:17 PM

Quote:

Originally Posted by Guessed

Looking at https://docs.microsoft.com/en-us/off...6)%26rd%3Dtrue it appears that you have two options to explore.

1. Include a SQLStatement variable to see if Word doesn't try to interpret the Name as a SQL statement instead.
2. Create a .qry file and point at that instead

Hi Andrew,
Thanks for your reply.
#1 - I tried parameter

Code:

SQLStatement:=";"

, without success

#2 - Not too sure what you mean, can you offer any further assistance? I'm not trying to query an SQL source, but set a txt / csv type file as the datasource for the mail merge.

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