Author: Bob Lin

With Excel automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them.

Step 1: Enable Developer tab – Macros and VBA tools can be found on the Developer tab, which is hidden by default, so the first step is to enable it.

1. On the File tab, go to Options > Customize Ribbon.
2. Under Customize the Ribbon and under Main Tabs, select the Developer check box.

Step 2: Record a macro

Follow these steps to record a macro.

1. On the Developer tab, in the Code group, click Record Macro.-OR-Press Alt+T+M+R .
2. In the Macro name box, enter a name for the macro. Make the name as descriptive as possible so you can quickly find it if you create more than one macro.Note: The first character of the macro name must be a letter. Subsequent characters can be letters, numbers, or underscore characters. Spaces cannot be used in a macro name; an underscore character works well as a word separator. If you use a macro name that is also a cell reference, you may get an error message that the macro name is not valid.
3. To assign a keyboard shortcut to run the macro, in the Shortcut key box, type any letter (both uppercase or lowercase will work) that you want to use. It is best to use Ctrl + Shift (uppercase) key combinations, because the macro shortcut key will override any equivalent default Excel shortcut key while the workbook that contains the macro is open. For instance, if you use Ctrl+Z (Undo), you will lose the ability to Undo in that Excel instance.
4. In the Store macro in list, select where you want to store the macro.In general, you’ll save your macro in the This Workbook location, but if you want a macro to be available whenever you use Excel, select Personal Macro Workbook . When you select Personal Macro Workbook, Excel creates a hidden personal macro workbook (Personal.xlsb) if it does not already exist, and saves the macro in this workbook.
5. In the Description box, optionally type a brief description of what the macro does.Although the description field is optional, it is recommended you enter one. Also, try to enter a meaningful description with any information that may be useful to you or other users who will be running the macro. If you create a lot of macros, the description can help you quickly identify which macro does what, otherwise you might have to guess.
6. Click OK to start recording.
7. Perform the actions that you want to record.
8. On the Developer tab, in the Code group, click Stop Recording .-OR-Press Alt+T+M+R .

Working with recorded macros in Excel

In the Developer tab, click Macros to view macros associated to a workbook. Or press Alt+ F8. This opens the Macro dialog box.

Caution: Macros cannot be undone. Before you run a recorded macro for the first time, make sure that you’ve either saved the workbook where you want to run the macro, or better yet work on a copy of the workbook to prevent unwanted changes. If you run a macro and it doesn’t do what you want, you can close the workbook without saving it.

Here’s further information on working with macros in Excel.

Working with recorded code in the Visual Basic Editor (VBE)

You can work with recorded code in the Visual Basic Editor (VBE) and add your own variables, control structures, and other code that the Macro Recorder cannot record. Since the macro recorder captures almost every step you take while recording, you can also clean up any unnecessary recorded code that serves no purpose in the macro. Reviewing your recorded code is a great way to learn or sharpen your VBA programming skills.

1. Go to File > Options.

2. On the General page, look for Personalize your copy of Microsoft Office.

3. In the Office Theme, select the color you prefer.

Please try this and let me know the result.

 To reset the view in Outlook to its default settings, follow these steps:

1. Open Outlook on your computer.
2. In the Outlook ribbon, switch to the “View” tab.
3. Click the “Reset View” button.
4. Confirm by selecting “Yes” in the confirmation window.

Your Outlook view will now be set to the default. If you’re still not satisfied with the view, you can also try the following options:

Click “Change View” in the same “View” tab and choose from three options: “Compact,” “Single,” or “Preview.”

Additionally, if you encounter any issues, you can reset the view using a command in Windows’ Run dialog box. Type the following command and press Enter:

outlook.exe /cleanviews

This will launch Outlook with the default view. If the problem persists, consider launching Outlook in safe mode to troubleshoot add-ins that might be causing the issue.

1. Download and install OneNote from Microsoft store or Microsoft 365.

2. With the OneNote open, post the text you want to convert to speech.

3. Click on View.

4. Click on Immersive Reader.

5. With the Immersive Reader open, you have option to setup Voice to select speed and voice.

6. Click Play icon to read the texts.

Each Google account has 15GB of free storage for documents, photos, and Gmail messages. to check your google account storage, click on Settings icon on the top right.

Then Settings.

You will see the storage.

Click View items taking up storage t view the details.

Click Clean up space to free more spaces.

you Clean up by service.

To generate a QR code in GeoVision GV-VMS (Video Management System), you can follow these steps:

1. Open GeoVision GV-VMS Software: Launch the GeoVision GV-VMS software on your computer. Ensure you have the necessary permissions and access rights to generate QR codes.
2. Go to Toolbar>Network>Mobile Services.

3. Send this QR code to the users.

To merge Focus and Other in Outlook, you need to Turn off Focused Inbox.

1. Select the View tab.
2. Select Show Focused Inbox.

The Focused and Other tabs will disappear from the top of your mailbox.

1. With Outlook pen, click on the “File” tab on the top left-hand corner.
2. Click on “Options” on the bottom of the left-hand side.
3. Under the “Mail” tab, uncheck “Always check spelling before sending“.

A. Email Remover App

Duplicate Email Remover Developer: MAPILab Platform: Microsoft Outlook (Windows) Features:

1. Easy-to-Use Interface: The app provides a user-friendly interface that allows you to quickly identify and manage duplicate emails.
2. Customizable Settings: You can customize the scanning criteria to suit your specific needs, such as searching within specific folders or applying filters based on email attributes.
3. Automatic Removal: Once duplicates are identified, the app offers options for automatically removing them based on your preferences.
4. Safe and Reliable: Duplicate Email Remover ensures the safety of your emails during the removal process, so you can trust that your important messages won’t be accidentally deleted.
5. Time-Saving: By eliminating duplicate emails, you can streamline your Outlook inbox and save time when searching for important messages.

How to Use:

1. Download and Install: Visit the MAPILab website or the Microsoft AppSource to download and install the Duplicate Email Remover add-in for Outlook.
2. Launch Outlook: Open Microsoft Outlook and navigate to the Duplicate Email Remover add-in.
3. Scan for Duplicates: Initiate a scan of your Outlook mailbox to identify duplicate emails.
4. Review Results: Once the scan is complete, review the results to see the duplicate emails found.
5. Remove Duplicates: Select the duplicate emails you want to remove and choose the appropriate action (e.g., delete, move to a different folder).

Note: Always ensure you have a backup of your emails before using any third-party tool for managing your mailbox.

Duplicate Email Remover by MAPILab is not entirely free. While it may offer a free trial period during which you can use its features, access to its full functionality typically requires purchasing a license or subscription.

Bitrecover Outlook Duplicate Remover.

• Download the wizard to your software and start it.
• Browse the PST file and open it in the software window.
• Select the mailbox folder where you want to delete duplicate data.
• Then select the PST file size and desired language.
• Finally, set the location for the result data and then press “Extract” to get a quick output.

Other remover apps: REMOVE DUPLICATE MESSAGES,  Outlook duplicate finder – Free Add-ins for Microsoft® Outlook,

B. Outlook Clean Up Tool

Outlook also offers an inbuilt function to remove duplicate emails in Outlook that we know as the Clean Up Tool. You need to follow the instructions as we have discussed below:

• Open Outlook and select a mailbox folder.
• Then click on “Home” and then “Cleanup”.
• Clean Up Conversation deletes and removes duplicate emails from a specific folder.
• The cleanup folder deletes duplicate emails from a specific folder.
• “Clean Folder and Subfolders” removes the duplicate folder and subfolders.
• You can opt any of them as per their comfort.
• Then right-click on the deleted data and tap on the empty folder that will permanently delete duplicate emails from Outlook.

C. remove duplicated emails manaully

If you’re experiencing duplicate emails in your Outlook inbox, you can follow these steps to remove them from within Microsoft 365 Outlook:

1. Open Outlook on your computer.
2. Go to the “Mail” tab at the bottom left corner of the Outlook window.
3. Select the folder where you have the duplicate emails (e.g., “Inbox”).
4. Click on the “View” tab in the ribbon at the top of the window.
5. In the “Current View” section, click on the “View Settings” button.
6. The “Advanced View Settings” window will open. Click on the “Filter” button.
7. In the “Filter” window, make sure the “More Choices” tab is selected.
8. Check the box next to “Only items with” and select “Unique Subject and Body” from the dropdown menu.
9. Click “OK” to close the “Filter” window.
10. Back in the “Advanced View Settings” window, click on the “Columns” button.
11. In the “Show Columns” window, select “All Mail fields” from the “Select available columns from” dropdown menu.
12. From the available columns, find and select “Modified” and “Size (KB)” and click “Add” to move them to the “Show these columns in this order” section.
13. Click “OK” to close the “Show Columns” window.
14. Back in the “Advanced View Settings” window, click “OK” to apply the changes.
15. You’ll be back in the main Outlook window with the duplicate emails filtered out.
16. Sort the emails by the “Modified” column by clicking on the column header. This will group the duplicates together.
17. Review the grouped duplicates and select the ones you want to delete.
18. Right-click on the selected duplicate emails and choose “Delete” from the context menu.
19. Confirm the deletion when prompted.

What is Microsoft PC Manager ?

Quoted:

On Windows 11 (or 10), PC Manager is an app from the Microsoft Store designed to enhance the overall performance, security, and management of the operating system. 

It serves as a comprehensive tool that helps you maintain your computer’s health by providing a variety of functionalities to resolve high memory usage, free up space quickly, disable and terminate unnecessary processes, scan for malware, and more.

However, the PC Manager app doesn’t introduce anything innovative since virtually every feature is already available on Windows 11 (or 10). The app feels more like a combination of the Task Manager and Settings app with a bunch of shortcuts to features and other Microsoft tools.