Thread: [Solved] Start MailMerge for 3 different Word documents in Excel depending on value in column A
View Single Post
 
Old 02-05-2019, 05:18 AM
Kalü Kalü is offline Windows 10 Office 2010 32bit
Advanced Beginner
  
Join Date: Apr 2018
Posts: 43
Kalü is on a distinguished road
Default
Nervermind, I got it by adding
Code:
 where (Anz>0)
into the vba code:
Code:
SQLStatement:="SELECT * FROM `Sheet1$` where (Anz>0)"
Can i somehow replace the large amount of text with abstracts in word that only show the full amount of text when the letters are merged?
Reply With Quote