Thread: [Solved] Can't merge mail from Excel
View Single Post
 
Old 04-05-2014, 07:57 AM
Mahmed1 Mahmed1 is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Apr 2014
Posts: 17
Mahmed1 is on a distinguished road
Default
This line freezes my computer

.OpenDataSource Name:=strWorkbookName, AddToRecentFiles:=False, _
Revert:=False, Format:=wdOpenFormatAuto, Connection:="Data Source=" _
& strWorkbookName & ";Mode=Read", SQLStatement:="SELECT * FROM 'Sheet1'"
.SuppressBlankLines = True
Reply With Quote