I am trying to merging with this code
And i am gettting type mismatch in the marked line. What I am doing wrong ?Code:Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim wrdMailMerge As Word.MailMerge Dim wrdMergeFields As Word.MailMergeFields wrdApp = CreateObject("Word.Application") wrdApp.Visible = True Dim dt As New DataTable dt.Columns.Add("col1") Dim dr As DataRow dr = dt.NewRow() dr(0) = "Dana" dt.Rows.Add(dr) wrdApp.Documents.Open(sTemplatepath & "\" & sTemplateFileName) ' With wrdApp.Documents(0).MailMerge Dim myConnectString As String = "Persist Security Info=False;Integrated Security=SSPI;database=xxx;server=xxx;Connect Timeout=30;User Id=xxx;Password=xx" Dim con As New SqlClient.SqlConnection(myConnectString) con.Open() Try With wrdApp.ActiveDocument.MailMerge .OpenDataSource(Name:="", _ ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", Passwordtemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=Word.WdOpenFormat.wdOpenFormatAuto, _ Connection:=con, _ sqlStatement:="select * from solmergedocument", SQLStatement1:="", _ SubType:=Word.WdMergeSubType.wdMergeSubTypeAccess) .Destination = Word.WdMailMergeDestination.wdSendToNewDocument .SuppressBlankLines = True With .DataSource .FirstRecord = Word.WdMailMergeDefaultRecord.wdDefaultFirstRecord .LastRecord = Word.WdMailMergeDefaultRecord.wdDefaultLastRecord End With .Execute(False) End With Catch ex As Exception MessageBox.Show(ex.Message) End Try wrdApp.ActiveDocument.SaveAs("c:\dana.docx") wrdApp.Documents.Close()


Reply With Quote