Find in site
Office OneNote Gem Add-Ins
  • Home
  • Addins
    • AddIns Internal (Windows10,8,7) >
      • Bridge for EndNote and OneNote
      • Gem for OneNote >
        • OneNote Gem - Excel Editor
        • Translate Gem for OneNote
      • Mind Map for OneNote
      • OneNote Gem - Favorites >
        • OneNote Gem - Keyword Tags
        • OneNote Mind Map
    • Web and Link AddIns (Windows) >
      • Anchor to OneNote >
        • Anchor to OneNote for Acrobat >
          • Anchor to OneNote for Adobe Acrobat Reader
          • Anchor to OneNote for Adobe Acrobat Reader DC
        • Anchor to OneNote for Chrome
        • Anchor to OneNote for Firefox
        • Anchor to OneNote for Access
        • Anchor to OneNote for Excel
        • Anchor to OneNote for Opera
        • Anchor to OneNote for PowerPoint
        • Anchor to OneNote for Outlook
        • Anchor to OneNote for Project
        • Anchor to OneNote for Publisher
        • Anchor to OneNote for Visio
        • Anchor to OneNote for Word
      • Anchor to OneNote for PDF
      • Bring to OneNote >
        • Bring to OneNote for Acrobat
        • Bring to OneNote for Firefox
        • Bring to OneNote for Thunderbird
        • Bring to OneNote for Chrome >
          • Install Bring to OneNote for Chrome
        • Bring to OneNote for Opera
        • Bring to OneNote for Internet Explorer
        • Bring to OneNote for Safari
        • Bring to OneNote for Windows Explorer
        • Bring to OneNote for Word
        • Bring to OneNote for Excel
        • Bring to OneNote for PowerPoint
        • Bring to OneNote for Visio
        • Register Bring to OneNote
      • Bring to Mac OneNote
      • Favorite to OneNote >
        • Favorite to OneNote for Chrome >
          • Install Favorite to OneNote for Chrome
        • Favorite to OneNote for Firefox
        • Favorite to OneNote for Internet Explorer
        • Favorite to OneNote for Opera
        • Favorite to OneNote for Windows Explorer
        • Image to OneNote
      • Row to OneNote >
        • Row to OneNote for Access
        • Row to OneNote for Excel
        • Row to OneNote for Project
    • Mind Map AddIns (Windows10,8,7) >
      • Mind Map for OneNote
      • OneMind for Office OneNote
      • OneNote Gem - Favorites
      • Pons for MindManager and OneNote
      • Pons for Visio and OneNote
    • AddOns External (Windows10,8,7) >
      • Auto OneNote
      • OneNote Batch >
        • OneNote Batch Command Lines
        • Google Keep Importer
        • Register OneNote Batch
      • OneNote Reminder
      • OneNote Search Bar
      • Fix One
    • Markdown AddIns (Windows) >
      • One Markdown
      • Gem for OneNote
    • Mac OneNote AddIns (MACOS) >
      • Gem Menu for Mac OneNote
      • OneMind for Mac OneNote
      • Bring to Mac OneNote >
        • Bring to OneNote for Mac Safari
        • Bring to OneNote for Mac Chrome
        • Bring to OneNote for Mac Firefox
    • UWP OneNote AddIns (Windows 10) >
      • Gem Menu for OneNote UWP
      • OneMind for OneNote UWP
      • OneReader
    • Cross-Platform AddIns >
      • OneMind for OneNote >
        • OneMind for Mac OneNote
        • OneMind for Windows Office OneNote 2016, 2013, 2010
        • OneMind for Windows OneNote
      • CiteBoard for OneNote
  • Download
  • Buy
  • Documents
    • Document
    • FAQs
    • Markdown
    • Formula for OneNote Table
    • Mind Map AddIns
    • Evernote Documents
    • OneNote Download
    • Release
  • Support
  • Templates
    • OneNote Templates
    • Gem Menu Templates
  • ⭐ WordNote

Addin for Mac OneNote



Read More

OneNote's Outlook Mail Merge Example

2/23/2016

1 Comment

 
This example describes how to use "Gem" tools to merge mail for Outlook.

In this example, we will use follow software.
  • Excel and add-in "Row to OneNote for Excel".
  • OneNote and add-in "Gem for OneNote".
  • Outlook


Send Excel Row as a Table to OneNote
  • Install "Row to OneNote" add-ins, This add-ins include "Row to OneNote for Excel".
  • Install "Gem for OneNote" add-ins.
  • Run OneNote
  • Run Outlook
  • Run Excel, open a Payroll excel file like follow image.


In Excel:
  1. Select a row in Excel.
  2. Click "View" tab -> "OneNote Gem" group -> "Row to OneNote" button.
  3. It will pop up a "Excel Header Row" window to help you to specify the header row.
Send Excel Row as a Table to OneNote
Send Excel Row as a Table to OneNote
Convert Table to Text

After click "OK" in "Excel Header Row" window. Add-In will convert Excel row as a table and save to a new OneNote page.

In OneNote,
  1. Select this table.
  2. Click the second "Gem" tab in hidden "Table Tools"
  3. Click "Convert Table to Text" feature in "Converts" group.
  4. This feature will pop up a "Convert Table to Text" window. In this window, choose "Other" option.
  5. Input "=" as delimiter to input box.
Convert Table to Text
Convert Table to Text
Copy Fields and Go to Gem Outlook Custom Fields File
After Click "OK" in "Convert Table to Text" window, it will convert table to text and separate with "=".

Last Name=Jones
First Name=Bob
Soc. Sec.=222-22-2222
Hours=20
Rate=$20
Wage=$400


These fields fit for Gem Outlook Custom Field format.
Gem Outlook Custom Field format is: 
Field Name = Field Value

We will use these fields later.
  1. Select all these fields and press "Ctrl + C" to copy them to clipboard.
  2. Click Gem "Cooperation" tab -> "Outlook" group -> "Field" menu -> "Go to Custom Fields Folder" menu item.
Copy Fields and Go to Gem Outlook Custom Fields File
Copy Fields and Go to Gem Outlook Custom Fields File
Edit Gem Outlook Custom Fields File
Gem open windows explorer and navigate to "GemOutlookCustomFields.txt" file.
  1.     Double click on "GemOutlookCustomFields.txt" file to edit it.
  2.     In NotePad,  press "Ctrl + V" to paste fields from clipboard.
  3.     Next, press "Ctrl + S" to save the "GemOutlookCustomFields.txt" file.
Edit Gem Outlook Custom Fields File
Edit Gem Outlook Custom Fields File
Create a Mail Template to Merge Fields for Outlook

Now, go back to OneNote create an Outlook Mail Template page.
The template page embed the field names using "<< >>".

Click "Outlook" group -> "New" ( New Outlook Email ) feature to create a Outlook email and merge with Gem fields.
Create a Mail Template to Merge Fields for Outlook
Create a Mail Template to Merge Fields for Outlook
A Merge Outlook Message
After click "New" ( New Outlook Email ) feature, Gem will pop up an Outlook email window, and convert OneNote page to Outlook email message, and replace the fields (enclosed by "<< >>") to   their values.

Now, we can got a merge Outlook message.
A Merge Outlook Message
A Merge Outlook Message
Tips:
If you can write a VBA to dynamic to replace "GemOutlookCustomFields.txt" fields, you can easy to create merge emails for multiple people.
Gem for OneNote v31 add: Recognize new custom field "Email".
Email=YourName@domain.com
​Gem will add this field to "To:" box.
1 Comment
OneNote是否可以实现类似于Outlook Vote的功能
3/24/2016 01:25:17

Can OneNote reliaze Vote function which is in Outlook?

Reply



Leave a Reply.

    RSS Feed

    Table of Contents

    Document Table of Contents
    ​OneNote FAQs

    Categories

    All
    Anchor To Onenote
    Auto OneNote
    Bring To Onenote
    Bring To Onenote Tips
    Browser Addons
    CiteBoard
    Favorite To Onenote
    Fix One
    Mac Gem Menu
    Mind Map For OneNote
    Notegem Monitor
    Office Tips
    One Markdown
    OneMind
    Onenote
    Onenote Batch
    Onenote Batch Tip
    Onenote Favorites
    Onenote Favorites Help
    Onenote Gem
    Onenote Gem Tips
    OneNote Reminder
    Pons For MindManager
    Pons For Visio
    Row To Onenote
    Search Bar
    Send To Onenote
    UWP Gem Menu

Command Line 
OneNote Tag Tree
Mind Map Tool

MindMap Add-Ins Comparison
One Markdown Syntax
OneNote Table Formula
OneNote Gantt

Repair OneNote
Add-Ins Documents
OneNote FAQs
OneNote Download
Release


View and Commert PDF in OneNote

MOBILE SITE
Copyright © 2011-2020 Digital GemSoft Ltd. OneNoteGem.com All Rights Reserved.