private void Merge3Btn_Click(object sender, RibbonControlEventArgs e) { XLForms.StaffSelectForm staffForm = new XLForms.StaffSelectForm(); staffForm.ShowDialog(); Document currentDoc = XLDocument.GetCurrentDoc(); long startPosition = currentDoc.Content.Start; long endPosition = currentDoc.Content.End; string templateXML = XLDocument.CopyRangeToWordXML(currentDoc.Range()); List <XLMain.FPIClient> clients = XLMain.FPIClient.GetFPIClients(staffForm.selectedStaff.crmID, "where direct_debit = 0 and Last_year = 1"); if (clients.Count > 0) { XLDocument.MergeFPIData(clients.OrderBy(c => c.office).ToList(), templateXML); } else { MessageBox.Show("No clients founds to merge."); } clients = XLMain.FPIClient.GetFPIClients(staffForm.selectedStaff.crmID, "where direct_debit = 0 and Last_year = 1", false); if (clients.Count > 0) { XLDocument.MergeFPIData(clients.OrderBy(c => c.office).ToList(), templateXML); } else { MessageBox.Show("No foreign clients founds to merge."); } }