Aplicații

E-mail 996 Solutii

How to Create an Automatic Outline in Microsoft Excel

It can be tough to organize a lengthy spreadsheet to make your data easier to read. Microsoft Excel offers a useful grouping feature to summarize data using an automatic outline. Here’s how it’s done.

What You Need to Create an Outline in Excel

In Microsoft Excel, you can create an outline of rows, columns, or both. To explain the basics of this topic, we’ll create an outline of rows. You can apply the same principles if you want an outline for columns.

For the feature to serve its purpose, there are a few things that you’ll need your data to include:

  • Each column must have a header or label in the first row.
  • Each column should include similar data.
  • The cell range must contain data. You cannot have blank columns or rows.

It’s easiest to have your summary rows located below the data that they summarize. However, there is a way to accommodate this if your summary rows are currently positioned above instead. We’ll describe how to do this first.

[mai mult...]

How to Automatically Add Captions to Instagram Stories

Captions are an important part of making sure videos are accessible to everyone, but they can be a pain to add on your own. Instagram has a nifty tool that can automatically add them to Stories. Let’s try it out.

The automatic captions feature is available when you record a video for your Instagram Story. The captions are actually one of the many “stickers” you can add to a Story. Instagram automatically transcribes what you say, but it can be edited as well.

[mai mult...]

How to Migrate from Gmail to ProtonMail

Import Your Gmail Inbox to ProtonMail

The first thing you’ll want to do is bring the contents of your old inbox over to the new one. Even though ProtonMail has a generous free plan, it falls well short of what Google can offer with Gmail. One of the most limiting factors is likely to be the 500MB inbox size limit.

If you have more than 500MB of email to import, you’ll need to upgrade to a larger plan to transfer the contents of your inbox. Alternatively, wipe the slate clean and start again (but keep ahold of your Gmail account so that you still have access to your old inbox).

Gmail Account Usage

If space isn’t a concern, there are two ways to import your Gmail inbox to ProtonMail: by using the Import Assistant in ProtonMail V4 (free), or by using the Import-Export desktop app for Windows, Mac, and Linux (premium account required).

At the time of writing in April 2021, ProtonMail V4 is currently in beta and can be accessed via beta.protonmail.com. Beta access is available to all users of ProtonMail, as this version will eventually become the default version for anyone who uses ProtonMail in a browser.

If you’re using ProtonMail V4 (or later), you’ll see it listed in the version number in the bottom left of the screen when you’re logged in. If you see an earlier version number, head to beta.protonmail.com and log in, then click on the “Settings” icon at the top of the screen.

ProtonMail V4

Under “Import & export,” click on “Import Assistant,” followed by “Continue with IMAP.” In the pop-up that appears, click on “Gmail” to see instructions on how to prepare your account (Don’t worry, we’ll run through them here.).

Now, head to Gmail and log in. Click on the “Settings” cog icon at the top of the screen, followed by “See all settings.” On the “Forwarding and POP/IMAP” tab, make sure that “Enable IMAP” is on so that the “Status” area reads “IMAP is enabled” in green text.

Gmail IMAP Enabled

On the “Labels” tab, make sure that you enable any labels that you’d like to show up by checking them as “Show in IMAP.” If you want to avoid transferring certain labels (like chats), disable them.

Show Gmail Labels in IMAP

Finally, head to your Google Account settings at myaccount.google.com and log in, and then visit the Security section. Under “Less secure app access,” make sure that you click “Turn on access (not recommended).”

If you have 2-step verification enabled on your account, you’ll need to create a new app password under the “App passwords” section instead. Make a note of this password, since you’ll need it for the next step.

Google 2-Step Verification App Passwords

Next, click “Start Import Assistant” (also labeled as “Skip to Import”) to get the ball rolling. You’ll need to log in with your Gmail account by using your primary credentials (username and password), or by using your email address and app-specific password (if you have 2-step verification enabled).

Skip to Import

Once you’re authenticated, ProtonMail will tell you exactly what will be imported. You can click on the “Customize Import” button to make further changes, like to cut-off dates and folders (labels), or hit “Start import” to begin the process.

Start Import Process in ProtonMail

If you don’t have enough space in your ProtonMail account for the email you wish to import, you will be warned. You can then make changes to your import so that everything fits. Learn more about importing via ProtonMail V4 on the Import Assistant support page.

Use the Import-Export Desktop App (Requires Premium)

If you have a premium ProtonMail account, you can use the dedicated Import-Export desktop app for Windows, Mac, or Linux to perform a similar import. In addition to this, you can also use the Import-Export app to import locally stored EML and MBOX files from other mail clients.

To do this, download Import-Export, and then follow the instructions to import your mail. This process can be made much easier by simply downloading your entire Gmail history in MBOX format via the official Google Takeout service.

Download Gmail as MBOX

As a paid customer, you have priority access to ProtonMail support to help you with any issues that you might encounter along the way.

Import Your Gmail Contacts to ProtonMail

You can import your contacts to ProtonMail relatively easily by exporting them as a CSV (comma-separated value) file directly from Google. You can do this by logging in to your Google account at contacts.google.com and then clicking on the “menu” button (which looks like three horizontal lines) and selecting “Export.”

By default, this will export all of your contacts. If you only want to export certain contacts, head back to the main list and select which contacts you want to export, and then head back to the Export page. Leave the format as “Google CSV” and click “Export” to download the CSV file.

Export Gmail Contacts as CSV

Head back to mail.protonmail.com and log in, and then click on the “Contacts” button at the top of the screen. From here, you can click on “Import,” and then drag your .CSV file into the window to upload your contacts. You might want to spend some time on the Contacts page tidying up entries after you’ve completed this process.

Import Contacts via CSV to ProtonMail

Don’t see the option to import via CSV? Log in at contacts.protonmail.com and then click on “Settings,” followed by “Import.” You can then use the “Import Contacts” button to locate the CSV file and upload your contacts here. If you are using ProtonMail V4 or later, you’ll need to use this method.

Forward Incoming Gmail Messages to ProtonMail

With your inbox and contacts successfully imported, you will likely want to make sure that any mail going to your old address is forwarded to your new one. If this isn’t the case (for example, if you are “starting fresh” due to too much incoming mail at your old address), then you can skip this step.

To forward mail from your Gmail account, log in at mail.google.com and click on the “Settings” cog at the top of the page, followed by “See all settings.” Under the “Forwarding and POP/IMAP” tab, click “Add a forwarding address” and enter your new (ProtonMail) address.

Add Forwarding Address to Gmail

Click “Next” and then “Proceed” to finalize your decision. Head back to your ProtonMail account, where you should find a confirmation email from Google. You’ll need to click the link in this email to complete the process.

Gmail Forwarding Confirmation Email

Refresh your Gmail account one last time and head back to Settings > Forwarding and POP/IMAP. Then select “Forward a copy of incoming mail” and specify the ProtonMail address you just added. Hit “Save Changes” at the bottom of the screen and you’re done.

Set Up Forwarding in Gmail

The Finishing Touches

With your inbox transferred, mail forwarded, and contacts ready to go, it’s time to start using your new email address. There are a few things that you should remember to do to ensure that you can complete the migration:

  • Update your online accounts to reflect your email address changes (social media, online shopping, utilities, health care, and so on).
  • Notify your contacts of your new address. You should use the “BCC” field to send mail to multiple contacts without sharing the full list of recipients.
  • Download the ProtonMail mobile app for Android or iPhone so that you can access your email on the go.
  • If you’re a premium ProtonMail user, you can download ProtonMail Bridge, which allows ProtonMail to work with mail clients like Outlook, Thunderbird, and Apple Mail.
[mai mult...]

How to Reset a ProtonMail Password

ProtonMail logo

Since ProtonMail is a secure email service that prioritizes privacy and security, resetting your password is a bit different from “regular” webmail providers like Gmail. You can do it, but here’s what you need to know.

ProtonMail has two password modes: single-password mode and two-password mode. If you haven’t enabled two-password mode, you don’t need to worry about this, as you’ll be using the default single-password mode.

In single-password mode, the same password is used to log in and decrypt your inbox. In two-password mode, you have one password for logging in (your account password) and another for decrypting your mailbox (your mailbox password). ProtonMail itself does not have access to any of your passwords, regardless of which mode you’re using.

ProtonMail Two-Password Mode

If you’re using two-password mode, changing either of your passwords will default you to single-password mode. When the password used to decrypt your mailbox is changed, you will no longer be able to read your old emails. If you remember it later, you can restore access to your older emails by recovering the decryption key.

Regardless of which password mode you’re using, changing your password will result in your older emails no longer being readable. You will still be able to see unencrypted data like the sender, subject line, and metadata, but you won’t be able to read the message body or access attachments.

When you create a new password, you’ll also create a new key used to decrypt data stored in your inbox. You will only be able to read any emails sent or received after the reset, since they will be encrypted using the new key.

Reset Your ProtonMail Password via Recovery Email

This method assumes that you set up a recovery email when you registered your ProtonMail account. To reset your account password, visit mail.protonmail.com and click on the “Get help” link below the “Login” button.

ProtonMail Login

Using two-password mode? To reset your mailbox password, log in using your account password. Then, on the “Decrypt Mailbox” screen, use the “Forgot Password” link, and follow the rest of the process as normal.

Reset ProtonMail Password

Click on “Reset Password” and enter your ProtonMail username and a recovery email. This email must match the one that you specified when signing up in the first place.

ProtonMail Recovery Email and Username

Confirm your decision in the box that appears and make sure that you understand that proceeding will prevent you from being able to decrypt the contents of your inbox. In the next step, you will be sent a recovery code, but be sure to leave the recovery web page open while waiting for the email to arrive.

Warning: This will wipe all the emails in your account. You’ll be able to access your account again, but all of your previously received emails will be gone. You will still receive emails sent to the address in the future.

confirm your password reset

Once you have the email, enter the recovery code, followed by the “Reset Password” button. Another window will appear warning you about what will happen to your inbox when you proceed with the next step.

ProtonMail Reset Password Recovery Code

Enter the word “DANGER” in capital letters into the box to confirm your decision, followed by the “Reset” button.

ProtonMail Confirm Reset

Finally, enter a new password, and make a note of it in a secure place (like a password manager). Hit “Reset Password” to complete the process. You can now head back to mail.protonmail.com and log in with your new password.

Reenable Additional Security When You’re Done

Resetting your password will disable two-password mode and two-factor authentication. If you want to carry on using these features, make sure that you reenable them via Settings > Account (two-password mode) and Settings > Security (two-factor authentication).

Enable Two-Factor Authentication in ProtonMail

[mai mult...]