protected void FillBookmarkWithCMAttachmentABNormal(Application app, SqlConnection con, string bookmarkName, string tableName, long cmId, string columnName, string columnCMId) { this.Logger.Info(tableName); object Normal = "Normal"; string query = "SELECT"; query = query + " " + columnName; query = query + " FROM " + tableName; query = query + " WHERE " + columnCMId + " = @CMId"; using (SqlCommand cmd = con.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.Add(this.NewSqlParameter("CMId", SqlDbType.BigInt, cmId)); Range rangeBookmark = app.ActiveDocument.Bookmarks[bookmarkName].Range; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { string fileContent = dr.GetNullableString(0); if (fileContent != null) { string htmlResult = ConvertHtmlAndFile.SaveToFile(fileContent); try { Application app2 = new Application(); Document sourceDocument = app2.Documents.Open(htmlResult); sourceDocument.Activate(); object start = sourceDocument.Content.Start; object end = sourceDocument.Content.End; Microsoft.Office.Interop.Word.Range myRange = sourceDocument.Range(ref start, ref end); myRange.Select(); myRange.Font.Name = "Roboto Light"; myRange.Font.Size = 10; IIFCommon.FindEmptyParagraphsAndDelete(sourceDocument); //DeleteCurrentSelectionLine(app2); //myRange.set_Style(ref Normal); sourceDocument.Save(); sourceDocument.Close(WdSaveOptions.wdSaveChanges); app2.Quit(); rangeBookmark.InsertFile(htmlResult); } catch (Exception ex) { throw ex; } finally { File.Delete(htmlResult); } } } } } }