Hi all
Having a small issue in that I'm getting an error in that I'm trying to get a single row selected from a sheet but unsure...
Assistance would be greatly appreciated
Having a small issue in that I'm getting an error in that I'm trying to get a single row selected from a sheet but unsure...
VBA Code:
.ActiveDocument.MailMerge.OpenDataSource Name:="C:\users\gavin\desktop\Funding\Funding Summary.xlsm" _
, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=False, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:="", _
SQLStatement:="SELECT*FROM[Sheet2$]"
Assistance would be greatly appreciated