1. Open the project’s root folder.
2. In Windows Explorer, right-click on project’s Main solution (.sln) → “Rename”.
   
3. Open the project in Visual Basic. In “Solution Explorer”, right-click on project → “Rename”.
   
4. In “Solution Explorer”, right-click on project → “Properties” → goto “Application” tab, rename “Assembly name” and “Default namespace” to match the project’s name.
   
5. If you wish to also rename the namespace, open one of your class files. Right click the namespace →”Rename…. ” This should search and replace all references to your namespace throughout the project.
6. Close the project. Delete the old “Solution User Option” (.suo).
   
7. In Windows Explorer, right-click on project’s subfolder → “Rename”.
   
8. Edit the .sln file and change the path of “.vbproj”.
   

Source: https://stackoverflow.com/questions/211241/how-can-i-rename-a-project-folder-from-within-visual-studio

Upon executing this SQL Statement:-

UPDATE `wp_ig_contacts`
INNER JOIN `wp_ig_lists_contacts` ON `wp_ig_contacts`.`id` = `wp_ig_lists_contacts`.`contact_id`
SET `wp_ig_contacts`.`updated_at` = "2021-07-06", `wp_ig_lists_contacts`.`status` = "unsubscribed"
WHERE `wp_ig_contacts`.`email` IN (SELECT `email` FROM `wp_ig_contacts_returned`)

If 1 email address belong to 1 group then 2 records will be updated:-

• 1 record in table “wp_ig_contacts” will be updated with `updated_at` = "2021-07-06"
• 1 record in table “wp_ig_lists_contacts” will be updated with `status` = "unsubscribed"

If 1 email address belong to 2 groups then 3 records will be updated:-

• 1 record in table “wp_ig_contacts” will be updated with `updated_at` = "2021-07-06"
• 2 records in table “wp_ig_lists_contacts” will be updated with `status` = "unsubscribed"
• 

MOBITEK^® E-mail Address Extractor is an useful digital marketing tool to extract the e-mail addresses from the body or the header of an e-mail. E-mail address extracted and then be imported into any e-mail broadcasting application or can be used to remove undeliverable e-mail address.

Note: free version does not support extracting e-mail address from Gmail and Yahoo Mail.

User’s Guide

1. Run “MOBITEK E-mail Address Extractor.exe”.
2. Go to “Settings” -> “POP3 Settings”.
   
3. In “Settings”, enter “Server Name”, “Username” and “Password” for POP3 e-mail. In “Security Settings” area, select the “Connection Security”, choose whether to use the default “None” or “SSL/TLS”. The “Port” will automatically change based on the selection.
   
4. To extract e-mail address from the body of e-mail, select “Extract E-mail Address from Body of E-mail”.
   
5. To extract e-mail address from the header of e-mail, select “Extract E-mail Address from Header”.
   
6. To extract e-mail address from only “Cc”, “To” and “From” section, select “Extract E-mail Address from ‘to’, ‘cc’ and ‘from’.
   
7. If you entered the wrong login information, you will a warning message, please re-check the settings (user name, password, etc.).
   
8. To cancel the extraction process, click the “Cancel” button.
   
9. After the extraction completed, a summary of the extraction process will be displayed.
   
10. All extracted e-mails will be shown in the “List of Extracted E-mails” tab. The total number of e-mails extracted will be shown in “The total e-mail(s) extracted”.  Copy e-mail addresses and paste a spreadsheet (csv) file that can be imported into any e-mail broadcast application.
    
11. Any duplicated e-mail extracted will be shown and added into “List of Duplicate E-mails” and the total number of duplicates shown in “Total duplicate e-mail(s)”.
    

Use My.Application.Info.Version.ToString

Source:

• AssemblyInfo.Version Property
• https://www.daniweb.com/programming/software-development/threads/484741/how-to-display-version