private void button1_Click(object sender, EventArgs e)//OK TO PROCESS Button
        {
            listView1.Clear();
            File.Delete(TempFolderPath + NonstandardFormFileNameOnly);

            Process.Start(GroupsFolderPath + GroupName + @"\Import");
            Process.Start(TempFolderPath);


            PopulateNonstandardWikiLog populate = new PopulateNonstandardWikiLog();

            populate.PopulateNonstandardWikiLogMethod();

            CreateTestResultOutlookEmail createEmail = new CreateTestResultOutlookEmail();

            foreach (string erid in GetNonstandardFileData.EmployerID)
            {
                ERID = erid;
            }


            GetStringBetweenString getStringBetweenString = new GetStringBetweenString();


            string requestersFirstName = getStringBetweenString.GetStringBetweenStringMethod(GetNonstandardFileData.Requester, "", " ");
            string managersLastName    = getStringBetweenString.GetStringBetweenStringMethod(GetNonstandardFileData.ApprovingManager, " ", "•");


            string emailTo      = GetNonstandardFileData.Requester;
            string emailCC      = GetNonstandardFileData.ApprovingManager;
            string emailSubject = GetNonstandardFileData.EmployerName + " - " + ERID + " - Nonstandard File Request Approved";
            string emailBody    = String.Format("<p style = \"font-size:11pt;\">Hello " + requestersFirstName +
                                                ",<br/><br/>" +
                                                "Your file(s) have been staged for processing and should " +
                                                "produce results within the next few hours.</p> ");

            createEmail.CreateTestResultOutlookEmailMethod(emailTo, string.Empty, string.Empty, string.Empty,
                                                           emailCC, string.Empty, string.Empty, string.Empty, emailSubject, emailBody);
        }
        private void PrivateGetOutlookEmailsFromDesignatedFolderMethod(string InboxFolderName)
        {
            Microsoft.Office.Interop.Outlook.Application outlook = new Microsoft.Office.Interop.Outlook.Application();
            NameSpace  outlookNameSpace = outlook.GetNamespace("MAPI");
            MAPIFolder rootFolder       = outlookNameSpace.DefaultStore.GetRootFolder();
            MAPIFolder defaultFolder    = outlookNameSpace.GetDefaultFolder(OlDefaultFolders.olFolderInbox);

            try
            {
                try
                {
                    MAPIFolder subFolderETL = defaultFolder.Folders[InboxFolderName];
                    SubFolderETLObject = subFolderETL;
                    SubFolderETLString = subFolderETL.ToString();
                }
                catch (System.Exception ex)
                {
                    MessageBox.Show("The subfolder " + SubFolderETLObject + " is not found under root folder " + defaultFolder, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }



                //MessageBox.Show(rootFolder.Name);

                //Get folder other than default inbox



                for (int i = 1; i <= SubFolderETLObject.Items.Count; i++)
                {
                    Microsoft.Office.Interop.Outlook.MailItem item = SubFolderETLObject.Items[i];
                    //MessageBox.Show(i.ToString());
                    //MessageBox.Show(item.Subject);
                    //MessageBox.Show(item.Body);
                    //MessageBox.Show(item.HTMLBody);

                    EmailSubjectLine = item.Subject;
                    EmailBody        = item.Body;

                    GetStringBetweenString getBody    = new GetStringBetweenString();
                    GetStringBetweenString getSubject = new GetStringBetweenString();


                    string body = getBody.GetStringBetweenStringMethod(EmailBody, "Comment", "Ticket URL");
                    string etlTicketNumberAndErid = getSubject.GetStringBetweenStringMethod(EmailSubjectLine.ToString(), "#", "-");
                    string etlTicketNumber        = getSubject.GetStringBetweenStringMethod(etlTicketNumberAndErid, "", ":");

                    string erid = getSubject.GetStringBetweenStringMethod(etlTicketNumberAndErid, " ", " ");
                    //string erid = getSubject.GetStringBetweenStringMethod(eridWithSpaces, " ", " ");

                    MessageBox.Show(EmailSubjectLine);

                    MessageBox.Show(body);
                    MessageBox.Show(etlTicketNumberAndErid);
                    MessageBox.Show(etlTicketNumber);
                    //MessageBox.Show(eridWithSpaces);
                    MessageBox.Show(erid);

                    //if (EmailBody.Contains("Comment"))
                    //{
                    //    MessageBox.Show(body);

                    //    if (EmailSubjectLine.Contains("Employer:"))
                    //    {
                    //        MessageBox.Show("If Subject line contains.."+erid);
                    //        ERID = erid;
                    //    }
                    //    else
                    //    {
                    //        MessageBox.Show("If Subject line contains.." + erid);
                    //        ERID = erid;
                    //    }

                    //}
                    //else
                    //{
                    //    //do nothing
                    //}


                    //get email contacts from the implementation spreadsheet
                    //MessageBox.Show("ERID going into GetSpecificDataFromExcelDatabase: " + ERID);
                    GetSpecificDataFromExcelDatabase getData = new GetSpecificDataFromExcelDatabase();
                    getData.GetSpecificDataFromExcelDatabaseMethod(ERID);



                    //create email
                    string emailBody = String.Format("<p style = \"font-size:11pt;\">Hello Everyone,<br/><br/>" +
                                                     "Test results are below:<br/><br/></p> ");


                    CreateTestResultOutlookEmail createEmail = new CreateTestResultOutlookEmail();
                    //createEmail.CreateTestResultOutlookEmailMethod();
                }
            }
            catch (NullReferenceException ex)
            {
            }
            catch (ObjectDisposedException ex)
            {
            }
            catch (EntryPointNotFoundException ex)
            {
            }
        }