|
|
#10
09-01-2017, 05:57 AM
|
||||
|
||||
Presumably, it was actually:
SELECT * FROM c:\MERGE\user\word.txt WHERE [M_2] IS NOT NULL Your VBA code should thus contain: SQLStatement:="SELECT * FROM " & doc & "WHERE [M_2] IS NOT NULL"
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| mailmerge omit lastrecord |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to get datasource element | ragesz | Mail Merge | 1 | 09-29-2013 07:12 PM |
 Mailmerge to Email with a mailmerge attachment
|
Baldeagle | Mail Merge | 8 | 02-11-2013 04:40 AM |
|
Mailmerge to Email with a mailmerge attachment
|
Baldeagle | Mail Merge | 13 | 05-29-2012 02:04 PM |
| Access MailMerge DataSource in VB | advin | Mail Merge | 1 | 01-04-2010 01:34 AM |
| Changing DataSource | ntfirewall | Mail Merge | 0 | 03-30-2007 06:01 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode