Author: Bob Lin

1. Login Cato Network cloud.
2. Navigate to Site Configuration>Hosts.

3. Double click on the Host to check the IP and MAC addresses.

1. Login Cato network cloud.
2. Click on Network>Site, and then your site.

3. Click on Known Hosts in the left pan.

4. Under Known Hosts, select the host you want to reserve the IP, click on 3 dots and then Save as a static host.

5. You should see the Reserved under IP Allocation.

You can also check all reserved hosts by going to Site Configuration>Hosts.

Situation: The client would like to forward emails sent to Microsoft group to an external email address. However, Microsoft group doesn’t have forwarding feature.

Resolution 1: Create an internal mailbox using Exchange online license.

1. Created an internal mailbox using Exchange online license, for example username@chicaotech.net with Exchange online license.
2. Added username@chicaotech.net as member of he group, for example accountsreceivables@chicagotech.net group.
3. Setup Forwarding on username@chicaotech.net to chicagotech.net@gmail.com.

With this setup, all emails sent to accountsreceivables@chicagotech.net should be forwarded to chicagotech.net@gmail.com.

Resolution 2: Create a Mail Contact

1. Access Microsoft 365 Admin Center: Log in to the Microsoft 365 Admin Center using your administrator credentials.
2. Access Exchange Admin Center (EAC): Once logged in, navigate to the Exchange Admin Center (EAC). This is where you can manage email settings for your organization.
3. Create a Mail Contact: You need to create a mail contact for the external email address to which you want to forward emails. To do this:
   • Go to the Recipients section in the Exchange Admin Center.
   • Choose Contacts and click on the plus sign to add a new mail contact.
   • Fill out the necessary information, including the external email address.
   • Save the changes.
4. Create a Mail Flow Rule: Now, you’ll create a mail flow rule to forward emails sent to the Microsoft Group to the external email address:
   • Go to the Mail Flow section in the Exchange Admin Center.
   • Click on the plus sign to create a new rule.
   • Set up the conditions for the rule. You would typically specify the Microsoft Group as the recipient.
   • Configure the action to forward the emails to the mail contact you created earlier.
   • Save the rule.
5. Testing: Send a test email to the Microsoft Group to ensure that emails are being forwarded to the external email address successfully.

By following these steps, you should be able to forward emails sent to a Microsoft Group to an external email address. Make sure you have the necessary administrative privileges to perform these actions within your Microsoft 365 environment.

if you would like to share a SharePoint folder with an external guest with full permissions, you should select “Share People you specify can edit” instead of “Anyone with the link can edit”. Here is how.

1. With SharePoint open, click Share on the folder you want to share.

2. By default, it is Anyone with the link can edit. Click on it. You should have an option to “Share People you specify can edit” and select it.

3. After Apply, type the guest email address and then Send.

4. The guest should receive an email with the link. Open it and Microsoft will request verify Your Identity.

5. Enter the Verification Code and click on Verify.

6. After login, you should be able to upload, delete and rename files, folders.

In sum

In SharePoint, “Anyone with the link can edit” and “Share People you specify can edit” are two different options for controlling access to documents or files within SharePoint sites or document libraries:

1. “Anyone with the link can edit”: This option allows anyone who has the link to the document or file to access it and edit it. It is a more open sharing option and is often used when you want to share a document with a wide audience without requiring specific permissions or user accounts. However, it can also pose security risks if the link falls into the wrong hands or is shared inadvertently. Also, a guest with “Anyone with the link can edit” permissions can only upload files, create subfolders, but can’t delete files and rename folders.
2. “Share People you specify can edit”: This option allows you to specify specific individuals or groups who have permission to edit the document or file. When you choose this option, you typically enter the email addresses or usernames of the people you want to grant edit access to. This option provides more control over who can access and edit the document, limiting it to only those individuals or groups that you explicitly specify. For example, a guest with “Share People you specify can edit” can upload files/folders, delete and rename files/folders. Also, you may e requested to login Microsoft to access the shared SharePoint.

Here is the example how to share a SharePoint using “Share People you specify can edit”.

1. With SharePoint open, click Share on the folder you want to share.

2. By default, it is Anyone with the link can edit. Click on it. You should have an option to “Share People you specify can edit” and select it.

3. After Apply, type the guest email address and then Send.

4. The guest should receive an email with the link. Open it and Microsoft will request verify Your Identity.

5. Enter the Verification Code and click on Verify.

6. After login, you should be able to upload, delete and rename files, folders.

In summary, the “Anyone with the link can edit” option is more open and accessible, while the “Share People you specify can edit” option provides more control and security over who can access and edit the document. The choice between these options depends on the level of access control and security requirements for the document or file in question.

1. Sign in to https://admin.microsoft.com as a global or SharePoint admin.
2. In the left pane, select Users > Active users.
3. Select the user.
4. Select the OneDrive tab, and under Sharing, select Manage external sharing.

5. Select a new external sharing level, and then select Save.

1. Login Office.com using your Microsoft credentials, and open the Admin app.
2. Open the SharePoint admin center
3. Click Sites, then click Active sites
4. Select your site and click Sharing

1. Select Anyone or New and existing guests, then click Save.

• 1. Navigate to Office.com, sign in using your Microsoft credentials, and open the Admin app.

2. Open the SharePoint admin center

3. Click Policies, then click Sharing

4. Move the SharePoint slider to Anyone or New and existing guests.

5. Click Save

Situation: The client would like to know if there is a way to sum total expenses from different receipts and Invoices.

Resolution: In this example, we will use PDF files as receipts and Invoices format, combine them and export them to an Excel file. Then submit the Excel file to ChatGPT to sum total expenses. Here are the steps.

Step 1: How to convert PDF files into Excel spreadsheets

Step 2: Submit exported Excel file to ChartGPT to sum total amount. This is the example result.

Note: these is no way to upload the file to ChtGPT so that you need to copy and paste. And you may not be able to copy and paste a big file. You may separate the file, for example, into monthly data.

1. Combine all PDF files: In the left, click on Combine files.

Click on Add Files.

Select all PDF files.

Click on Combine.

2. In All tools, click on Export a PDF.

Select Microsoft Excel XLSX and then Convert to XLSX.

3. Save the converted file and Name your new Excel file and click the Save button. That’s it.

4. The new created Excel will open automatically.