{"CACHEDAT":"2026-04-14 02:03:03","SLUG":"gmail-oBvOgIHRkL","MARKDOWN":"# Set up Gmail\n\n## Declutter your SciLMi Gmail Inbox\n\n[https://www.loom.com/share/452fb1842ec54c4091ee4d14fe27a070?sid=329058d2-f2d9-46ad-9876-19a73c62e30b](https://www.loom.com/share/452fb1842ec54c4091ee4d14fe27a070?sid=329058d2-f2d9-46ad-9876-19a73c62e30b)\n\n\n## Add Filter to Mark \"Closed\" Team Emails as Read\n\n* Go to Gmail (!) Settings:\n\n ![](/api/attachments.redirect?id=3c616a26-5d47-49ca-b071-cbc0a382aed1 \" =356x219\")\n\n* Go to tab \"Filters and blocked addresses\"\n* Scroll down and click \"Createa new filter\"\n* Type \"label:hiver-team-closed\" in the field \"Includes the words\":\n\n ![](/api/attachments.redirect?id=89e8d98f-940b-47ee-9767-14b78df7dbb9 \" =734x415\")\\n\n\n* Click \"Create filter\"\n* Click \"OK\" in \"Confirm filter creation\" popup:\n\n ![](/api/attachments.redirect?id=842a77f7-4ac1-42bf-bc14-eefa139dea64 \" =556x217\")\\n\n* Select the setting as shown in the screenshot and click \"Create filter\":\n\n ![](/api/attachments.redirect?id=405543c7-a7de-4b50-bb2f-48efd22ad385 \" =721x628\")\\n\n\n## Set up TEAM sender name\n\n* Our shared \"corporate\" sender name is \"E+ SciLMi Team\". Watch how to set \"E+ SciLMi Team as your default sender address:\n\n[https://www.loom.com/share/fff4f922e6cb45668065334e3eee0126?sid=88d86776-9ed0-465e-acd0-b908aa914236](https://www.loom.com/share/fff4f922e6cb45668065334e3eee0126?sid=88d86776-9ed0-465e-acd0-b908aa914236)\n\nNote that the signature will still have your name.\n\nSign official emails (from templates with \"E+ SciLMi Team.\".\n\nWhen we reply on specific emails, we can sign with our names to make the email sound more personal.\n\n\n## Corporate Signature\n\nThe signature will update automatically and show different banners depending on what we are promoting.\n\n ![](/api/attachments.redirect?id=b4257279-e925-4de8-a05e-ae0bff2d87eb \" =907x562.5\")\n\n\n# MailMerge → Send Personalised Mass Emails\n\n\n1. **Open the Google Sheet**\n * In Google Sheets or Google Drive, search for the file containing the relevant contacts (e.g. \"BIT Participants\") and open it.\n2. **Filter the recipients**\n * In the *Participants* tab, apply filters to select only the individuals you wish to contact.\n3. **Check and customise the MailMerge tab**\n * Confirm that the *MailMerge* tab shows the correctly filtered contacts.\n * If you need to add personalised information that is not currently displayed, go to cell A1 and adjust the formula to include the required columns. You may need editing rights, in which case please contact Maria.\n4. **Set up Mail Merge**\n * Follow Google's instructions: [Mail Merge Guide](https://support.google.com/mail/answer/12921167?sjid=1210165362469463433-EU)\n * Connect the *MailMerge* tab to Mail Merge.\n5. **Prepare and personalise your email**\n * Remove the unsubscribe link manually (!)\n * Always send a test email before sending to all recipients (!)\n * To personalise the body of the email, type `@` to see a dropdown containing the column headers from the *MailMerge* sheet.\n\n\n:::info\nBei Fehlermeldung: =ISEMAIL(\\[Zelle mit E-Mail\\] → so findet man schnell, welche E-Mail das Problem verursacht.\n\nManchmal ist es nicht-sichtbarer Fehler.\n\n:::\n\n# Use of Templates\n\nHiver has its own template function, but unfortunately we cannot use it with the free account.\n\nInstead, we organise our [email templates here in the Wiki](https://web.scilmi.eu/doc/email-templates-info-PF4Blr6GE6).\n\n\n\\\n# Search for Specific Emails in Gmail\n\n[https://www.loom.com/share/4c14df6f24404415beea0c9f3a90fdec?sid=c640a7f6-4794-4d97-a482-3c6d2fc6fb9a](https://www.loom.com/share/4c14df6f24404415beea0c9f3a90fdec?sid=c640a7f6-4794-4d97-a482-3c6d2fc6fb9a)\n\n\n\\","HTML":"

Set up Gmail

\n

Declutter your SciLMi Gmail Inbox

\n

https://www.loom.com/share/452fb1842ec54c4091ee4d14fe27a070?sid=329058d2-f2d9-46ad-9876-19a73c62e30b

\n

Add Filter to Mark "Closed" Team Emails as Read

\n\n

\"\"

\n\n

\"\"\\n

\n\n

\"\"\\n

\n\n

\"\"\\n

\n

Set up TEAM sender name

\n\n

https://www.loom.com/share/fff4f922e6cb45668065334e3eee0126?sid=88d86776-9ed0-465e-acd0-b908aa914236

\n

Note that the signature will still have your name.

\n

Sign official emails (from templates with "E+ SciLMi Team.".

\n

When we reply on specific emails, we can sign with our names to make the email sound more personal.

\n

Corporate Signature

\n

The signature will update automatically and show different banners depending on what we are promoting.

\n

\"\"

\n

MailMerge → Send Personalised Mass Emails

\n
    \n
  1. Open the Google Sheet
    2. \n
\n\n
    \n
  1. Filter the recipients
    2. \n
\n\n
    \n
  1. Check and customise the MailMerge tab
    2. \n
\n\n
    \n
  1. Set up Mail Merge
    2. \n
\n\n
    \n
  1. Prepare and personalise your email
    2. \n
\n\n
\n
Info
\n

Bei Fehlermeldung: =ISEMAIL(\\[Zelle mit E-Mail\\] → so findet man schnell, welche E-Mail das Problem verursacht. Manchmal ist es nicht-sichtbarer Fehler.

\n
\n

Use of Templates

\n

Hiver has its own template function, but unfortunately we cannot use it with the free account.

\n

Instead, we organise our email templates here in the Wiki.

\n

Search for Specific Emails in Gmail

\n

https://www.loom.com/share/4c14df6f24404415beea0c9f3a90fdec?sid=c640a7f6-4794-4d97-a482-3c6d2fc6fb9a

","UPDATEDAT":"2026-02-17T12:43:58.338Z","ID":"4b61518f-cd85-40a2-ae34-d63470fec8d8","TITLE":"Gmail"}