Search
OneNoteGem
  • Home
  • Addins
    • Windows Office Addins >
      • Gem for OneNote
      • OneNote Search Bar
      • OneNote Gem - Favorites
      • OneNote Batch
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • Row to OneNote
      • Auto OneNote
      • Favorite to OneNote
      • Bridge for EndNote and OneNote
      • Anchor to OneNote
      • Anchor to OneNote for PDF
      • Bring to OneNote
      • Gem Table for OneNote
    • Windows UWP Addins >
      • Gem Menu for OneNote UWP
      • CiteBoard for OneNote
      • OneReader
      • OneMind for Windows OneNote
      • OneNote Reminder Cloud (UWP)
      • OneNote Batch Cloud (UWP)
    • Mac Addins >
      • Gem Menu for Mac OneNote
      • CiteBoard for OneNote
      • Bring to Mac OneNote
      • OneMind for Mac OneNote
      • OneNote Reminder for Mac
      • OneNote Batch for Mac
      • Fix One for Mac - Fix OneNote Login, Sync Tools
    • Android Addins >
      • CiteBoard for OneNote
      • Fix One for Android - Fix OneNote Login, Sync Tools
    • Cross-Platform Addins >
      • OneNote Reminder
      • OneMind for OneNote
      • CiteBoard for OneNote
      • Fix One - Fix OneNote Login, Sync Tools
    • Markdown Addins >
      • Gem for OneNote
      • One Markdown
    • Mind Map Addins >
      • OneNote Gem - Favorites
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • OneMind for OneNote
    • Other Addins >
      • One Markdown
      • Clip to OneNote
      • WordNote
      • OneShare
      • Fix One for Windows - Fix OneNote Login, Sync Tools
  • Buy
  • Documents
  • FAQs
  • Templates
  • Support
  • Release
  • WordNote
Gem Table for OneNote
 
 
The table of merged cells for OneNote

How to use Mail Merge from a .csv file to do Mass Mailings in OneNote?

2019-11-24 00:18
 
Gem for OneNote v32 begin to support use mail merge from a .csv file to do mass mailings in OneNote.

In this example, we need 3 Office software and 1 add-in to do mass mailings:
  • Excel, we use Excel to create a .csv file, which include a header row with field name.
  • Outlook,  in this example, we use outlook to send emails.
  • OneNote, we use OneNote to create a page as mail template.
  • Gem for OneNote, it will merge mail with .csv file and OneNote template page, and do mass mailings through Outlook.


Create a .CSV File in Excel

The first step, we create a "Contacts.csv" file in Excel.
The .csv file must include 2 things:
  1. Header row with field names. 
    The field names must same as OneNote template page field name. Gem will replace value according the field name.
  2. Email Address Column.
    Every row ( record ) must include an email address. Gem will send to this email address after merge mail.
Create a .CSV File in Excel
Create a .CSV File in Excel
Create a Template Page in OneNote

The second step, we create a template page for merge mail in OneNote.
The template page can do these:

Page Title
The page title will be used for mail subject. 
You can insert some general fields (from Gem for OneNote) into page title.
The General Fields include:
<<Date>>, <<DateTime>>, <<UTCDateTime>>, <<TimeZone>>.

Page Content
The page content will be used for mail body. 
You can insert all general fields into page content.
You also can insert all fields from .CSV file into page content.
Create a Template Page in OneNote
Create a Template Page in OneNote
Mass Merge Mails and Send using Gem for OneNote
  1. In "Gem for OneNote", click "Cooperation" tab -> "Outlook" group -> "Mass" feature.
  2. In pop up mass Email window, in "From" list box, choose an Outlook account as sender.
  3. In "CSV File" box, click "Folder" icon to select "Contacts.csv" from desktop.
  4. In "Count", input 6, it mean that merge 6 mails after click "Mass Send" button.

Index: the first index for merge mails from .csv file.
​
Mass Merge Mails and Send using Gem for OneNote
Mass Merge Mails and Send using Gem for OneNote
Preview the Merge Mail

    5. You can click "Preview" button to preview the merge mail in Outlook before send.
Preview the Merge Mail
Preview the Merge Mail
Mass Send Emails in Outlook

   6. After click "Mass Send" button, it will start merge mails with row of .csv file from index, and just generate "Count" number of mails,  and put them into Outlook's "Outbox" folder.
Mass Send Emails in Outlook
Mass Send Emails in Outlook
 
Download Gem for OneNote

Related Documents

  • EXE: Create a Note of Outlook and Microsoft Sticky Notes Directly from OneNote
  • EXE: Change OneNote Page Date Time to Outlook Item Date Time after Send to OneNote
  • Set Multiple Notebooks to Read-Only
  • How to create A4 Frame with underlines Genko in OneNote?
  • How to Create and Using Date Fields in an OneNote Template?
Command Line
Tag System
MindMap Add-Ins Comparison
Search Add-Ins Comparison
One Markdown Syntax
Table Formula
Gantt

Gem Menu Templates
Repair OneNote
OneNote Download
English website Chinese website
Mobile Site
Copyright © 2011-2025 Digital GemSoft. OneNoteGem.com All Rights Reserved.